Consolidation of multiple data sources

[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

 

[John... Visio MVP]

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)

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

 

[Keith Wilby]

Your tracking of all my posts in the newsgroups your malicious persecution
and libelous statements about me have got to come to an end. You are an
embarassment to the standards of what MVP stands for. Your actions are
being documented and a large dollar amount lawsuit is being prepared
against you.

Best of luck with that mate:

http://www.theregister.co.uk/2008/07/29/advfn_libel_eady_mosley/