how to auto populate data from multiple sheets to a master

**Fosachy** · 04-20-2009, 08:50 PM

Hi guys

Been struggling with this and don't know where to start. Any suggestions would be helpful.

Im trying to create a master report which will be used to send out daily. The problem is everyday there is new data for each of the headings and instead of copy and pasting each new data for the day i would like it to automatically be auto populated to the master report.

Is there any way to do this using coding instead of linking?

Thanks in advance

**JBeaucaire** · 04-20-2009, 09:17 PM

ONE REPORT that culls information daily from multiple other workbooks with the UNCHANGING names...this could easily be done with macros OR with worksheet functions. Both will work fine if the sheets are well designed.

Post a complete sample set of support sheets and a mockup of the summary report you make daily and we'll look it over.

**Fosachy** · 04-20-2009, 09:45 PM

Here is the sample

note the data will come from different worksheets however same data on each. At times there may be a row missing from the data.

Therefore it may need to call data based on the "text" since the name never changes, only the data

Thanks

**JBeaucaire** · 04-20-2009, 10:11 PM

So, since there are no dates in the "example data.xls" file, I presume you will just want to use today's date. As such, it will also have to be a macro since worksheet functions would need a date in the data, too.

So, since we're talking macro, how usable will a macro I give you be since your data set looks pretty dumbed down...or are you actually counting animals?

I've attached this macro to a button to simplify running it. Try running it twice in a row:

Please Login or Register  to view this content.

Those bits in red you'll have to get right. Correctly located, this macro will work on closed workbooks.

**Fosachy** · 04-21-2009, 06:15 PM

It works!!! BUT......

JB your right i dummy'd down my data so much that when i'm trying to use my real data its too hard to comprehend.

I may have left out some important things about the master and now when trying to manipulate your code its not working.

Please let me know what u think i should do.