Consolidation of multiple data sources

  • Thread starter Thread starter leimst
  • Start date Start date
L

leimst

Hi,
I have always been an Excel guy and have never used Access until just
recently when a friend showed my how to use it to identify duplicates in
some very large spreadsheets I was working on. Now having seen just a small
sampling of what Access can do, I was wondering what other applications it
would be suited for.

So here's the question. I have a spreadsheet that I am populating, a
dashboard of sorts, and the data to populate it is coming from 3 other
spreadsheets and an .html documents as well. On a monthly basis, I am
collecting these spreadsheets and the .html document, manipulating and
bringing the data into the consolidated spreedsheet. Would Access be a
preferred method to consolidate this information and maybe even put some
automation around the process?

Thanks for any help in advance,

Brian
 
Steve said:
Hi Brian,

I provide help help with both Access and Excel applications for a very
modest fee. I have automated many Excel processes and have converted many
Excel processes to Access.

Steve
(e-mail address removed)
Click to expand...


Okay class, all together:

These newsgroups are provided by Microsoft for FREE peer to peer support.
stevie is a known troll who does not understand the word FREE and is only
here to con unsuspecting posters into paying him for software of
questionable value.

stevie, how come you have stopped trying to pull this scam in CDMA?

John... Visio MVP
 
Back
Top