Best Approach for consolidating data from different workbooks

[EliseFreedman]

Hi There

In my department, we collect Physiotherapy information like type of treatment, dates, area of pain etc.

There is a team of 4 physios and I have set each physio up with a copy of the spreadsheet for collecting their own data. I did originally set them up with links to a single shared worksheet but data kept going missing so I ended up splitting it into individual workbooks. This has worked well for a few months now

We would now like to collate the information from all the workbooks so that we can get totals for the numbers of treatments etc. Obviously I could simply cut and paste the info into a master spreadsheet but I would prefer to automate it. I played about with the merge workbooks code from the Rondebruin Website but couldnt get anywhere (the code was simply pasting the name of the selected workbook rather than the data from it. What is the best approach to take to merge all the data.

 

[SkipVought]

Hi,

Is the data tabular?

Is the data on more than one sheet?

Is the table structure identical?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[EliseFreedman]

Yes the Data is Tabular and has the identical structure in each workbook. Only the content of the data is different. There is more that one sheet in each workbook but I am only interested in a specific sheet

 

[xlbo]

I would also ask....is the data cleared ans re-imported each time or are you just going to add new dtaa to the bottom of a master list?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[PHV]

You may consider MS-Query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

yes, MS Query. faq68-5829

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}