I came across Chandoo.org last night and loved it. I picked up some great tips and wanted to jump in and join the fun too.
I have one question. Something I have been searching for a solid answer for some time.
How to join several worksheet data. Not consolidate numbers or figures, but lists of people and information, like a company staff list.
The example workbook contains 3 worksheets, each with data set out with the same column names. I want to combine that data into 1 worksheet (I have included the desired output as a sheet too, for reference). From what I have read perhaps OFFSET may work??
The thing is, this example contains only 3 worksheets, whereas in reality I am going to be working with around 60 separate workbooks - not sheets in the same workbook (all with the same set up and columns), and around 2500 records in total. And growing.
The reason I come here is two-fold:
1. to see if there is a general solution for the 'example sheet'
2. to get some general input and advice or ideas on how to get around this. For example, how best to use the Master Spreadsheet to then share the selected data to each of the 60 people. Or how best to then get this back from people to then 'hopefully' be able to put it all back together or update the MASTER.
I welcome any comments and thank you in advance to taking the time to read through my challenge.
I have one question. Something I have been searching for a solid answer for some time.
How to join several worksheet data. Not consolidate numbers or figures, but lists of people and information, like a company staff list.
The example workbook contains 3 worksheets, each with data set out with the same column names. I want to combine that data into 1 worksheet (I have included the desired output as a sheet too, for reference). From what I have read perhaps OFFSET may work??
The thing is, this example contains only 3 worksheets, whereas in reality I am going to be working with around 60 separate workbooks - not sheets in the same workbook (all with the same set up and columns), and around 2500 records in total. And growing.
The reason I come here is two-fold:
1. to see if there is a general solution for the 'example sheet'
2. to get some general input and advice or ideas on how to get around this. For example, how best to use the Master Spreadsheet to then share the selected data to each of the 60 people. Or how best to then get this back from people to then 'hopefully' be able to put it all back together or update the MASTER.
I welcome any comments and thank you in advance to taking the time to read through my challenge.