Hope everyone enjoyed the long weekend. My brain must be mush...

I know this is a little ridiculous, esp since I cannot figure it out. Here is the situation: I have a workbook with 4 sheets. The first three contain info for three different things. The number of rows change on each of these sheets. This is important to note. The fourth sheet pulls (well not yet, but thats the question) only specific columns from each row on the three sheets.

Question: How do I pull the rows containing only the specific columns from all three sheets on to the fourth... without whitesapce or blank rows. I basically want to combine the rows on to the fourth. The columns selected are the common data, so it matches up when combined on the fourth sheet. The issue is that I cannot figure out an automated way to do so without knowing how many rows from each sheet it is going to pull into the fourth.

Here is what I have been using:

IF('Sheet1'!A3="",IF('Sheet2'!A3="",IF('Sheet3'!A3="",,'Sheet3'!A3:E3),'Sheet2'!A3:E3),'Sheet1'!A3:E3)

Problem is, when it goes to Sheet 2, if picks up on the numbered row where sheet 1 left off. Ex: Sheet 1 has 20 rows and then a blank, it imports the 20 rows then switches to sheet 2 at the 21st row, not starting over on the 1st row of Sheet 2.

If the number of rows is static, this is easy, but Sheet 1 might get 34 rows today, then tomorrow 15. The number of rows on each sheet is dynamic.

I know this is a little ridiculous, esp since I cannot figure it out. Here is the situation: I have a workbook with 4 sheets. The first three contain info for three different things. The number of rows change on each of these sheets. This is important to note. The fourth sheet pulls (well not yet, but thats the question) only specific columns from each row on the three sheets.

Question: How do I pull the rows containing only the specific columns from all three sheets on to the fourth... without whitesapce or blank rows. I basically want to combine the rows on to the fourth. The columns selected are the common data, so it matches up when combined on the fourth sheet. The issue is that I cannot figure out an automated way to do so without knowing how many rows from each sheet it is going to pull into the fourth.

Here is what I have been using:

IF('Sheet1'!A3="",IF('Sheet2'!A3="",IF('Sheet3'!A3="",,'Sheet3'!A3:E3),'Sheet2'!A3:E3),'Sheet1'!A3:E3)

Problem is, when it goes to Sheet 2, if picks up on the numbered row where sheet 1 left off. Ex: Sheet 1 has 20 rows and then a blank, it imports the 20 rows then switches to sheet 2 at the 21st row, not starting over on the 1st row of Sheet 2.

If the number of rows is static, this is easy, but Sheet 1 might get 34 rows today, then tomorrow 15. The number of rows on each sheet is dynamic.

Last edited: