Consolidating multiple worksheets into one

Hi,

I'm sorry if this a basic problem.

I have 3 worksheets with different data. All have the same column headings. I would like to merge them into one sheet with the same columns headings.

The number of rows of data in each sheet will vary on a daily basis.

Thanks in advance for your help!

Matt

you mean you want to glue the new data on the bottom of the old?
Automatically?

No, I want to simply reference the data from the 3 worksheets together on one worksheet.

Here is an example for clarity:

Sheet 1 = 4 rows
Sheet 2 = 10 rows
Sheet 3 = 6 rows

The master sheet should therefore have 20 rows of data referenced from the 3 sheets.

Sheets 1 to 3 may then change data the following day so

Sheet 1 = 3 rows
Sheet 2 = 5 rows
Sheet 3 = 3 rows

The master sheet should therefore have 11 rows of data referenced from the 3 sheets.

Thanks Charlie

I think I'd need to use code to do that - are you comfortable with VBA or were you hoping for a formulaic solution?

Really?! It seemed like such a simple task!

I don't mind VBA code. But the most I have done is minor editing of macros.

Thinking about it now, maybe I could just use a marcro to select the data then copy it?

Do macros record things like CTRL+Down to find hte end of selection of data?

Macros can record Ctrl+End.

Alternatively you could have your Master sheet to read in three different sections, then use a Macro to copy paste.
Eg.
Master sheet lines 1 - 200 = Sheet1 lines 1 - 200
Master sheet lines 201 - 400 = Sheet2 lines 1 - 200
Master sheet lines 401 - 600 = Sheet3 lines 1 - 200

If 200 lines are not enough, then you can simply use a bigger interval.
Then have your Macro copy-paste the info into another sheet and sort the info in descending order. The blanks will simply show at the bottom as NIL items. The data values will all be listed above. This might be a simpler macro to record.

Ah, that's a great idea. The sort will do the job nicely.

Thanks Rasonline. I will set that up and see how it goes.