London_Calling
Active Member
- Joined
- Feb 27, 2007
- Messages
- 256
I haven’t done this kind of project before and my guess is there are as many ways of doing it as there are excel users. I am, however, working in pretty much an excel vacuum and would very much like a range of input about your general approach. The particulars of this project are:
Data (i) from the web (ii) from the company database and (iii) in spreadsheets from departments within the company needs to be consolidated and coherently reported/published.
Reporting involves graphs, charts and (I guess) pivot table/lists type numeric presentations.
My main question at the moment is how to consolidate – I presume simple vba subs to funnel (copy) the relevant data from all the sources into a fresh workbook, and then to automate that procedure when it’s complete for the purposes simplifying monthly updating?
Might there be alternative methodology, anything I need to be watchful of (I’m looking out for conflicting data types) . . . comments welcome!
Cheers
Data (i) from the web (ii) from the company database and (iii) in spreadsheets from departments within the company needs to be consolidated and coherently reported/published.
Reporting involves graphs, charts and (I guess) pivot table/lists type numeric presentations.
My main question at the moment is how to consolidate – I presume simple vba subs to funnel (copy) the relevant data from all the sources into a fresh workbook, and then to automate that procedure when it’s complete for the purposes simplifying monthly updating?
Might there be alternative methodology, anything I need to be watchful of (I’m looking out for conflicting data types) . . . comments welcome!
Cheers