Consolidate data from another worksheet

**jyothijayanna** · 09-06-2012, 02:04 AM

Hi,

Please help me create a formula that will take values from different sheets (Oct & Nov), and cleanly stack them on the master sheet.

Thanks

**arlu1201** · 09-06-2012, 07:40 AM

Your sheets are named as 1st Quarter and 2nd Quarter and not Oct & Nov as you have specified. I hope you have uploaded the correct file.

You have duplicating entries between both the sheets, how do you want the values to show up in the Master tab? Average of both?

**jyothijayanna** · 09-08-2012, 12:59 AM

Originally Posted by arlu1201

Your sheets are named as 1st Quarter and 2nd Quarter and not Oct & Nov as you have specified. I hope you have uploaded the correct file.

You have duplicating entries between both the sheets, how do you want the values to show up in the Master tab? Average of both?

Oh my....I have uploaded correctly.

**JBeaucaire** · 09-08-2012, 07:10 AM

I would have to recommend VBA for this, especially if you're really going to be adding more sheets, as is typical when we see sheets named after months. This macro, installed into the MASTER sheet module, will do this. Each time you bring up the MASTER on screen from a different sheet, it will recreate the data for you.

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Right-click the MASTER tab name
3. Select VIEW CODE
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save the workbook

Now go to the OCT or NOV sheet and make some edits, then look at the MASTER sheet again, it will reassert the data.