Tags: 1-3, consolidates, copying, excel, final, microsoft, missing, msdn, non-blank, number, rows, sheet, sheets, software, worbook

Copying non-blank rows to another sheet...

On Microsoft » Microsoft Excel

2,320 words with 1 Comments; publish: Mon, 26 May 2008 14:31:00 GMT; (30662.99, « »)

I think (hope) i am missing something simple here...

I have a worbook with a number of sheets (1-3), and a final sheet "4" that consolidates the information.

After some processing, the sheets 1-3 have variable amounts of data. I am trying to copy the data from each of the sheets into sheet 4.

The data in sheets 1-3 use columns A-F - all cells in column "A" will contain an index number, but this is not unique to each row.

One method i had thought of using was to calculate the last non-blank row of column "A", and then copy range A1->F(last row) and then paste into the relevant place in the last sheet... but I just can't help feeling that there must be a simple (advanced) f

ilter in VB that will select all the non-blank cells and allow to copy / paste.

I'm very curious to know if there is... i can work through the above option OK... TIA

Mike

All Comments

Leave a comment...

  • 1 Comments
    • Hi

      have a look at

      http://www.rondebruin.nl/copy2.htm

      Regards

      Frank Kabel

      Frankfurt, Germany

      "Mike" <mike.excel.todaysummary.com.iacovou.com> schrieb im Newsbeitrag

      news:0555C0A4-076D-4EC0-812A-9506BB513720.excel.todaysummary.com.microsoft.com...

      > I think (hope) i am missing something simple here...

      > I have a worbook with a number of sheets (1-3), and a final sheet "4"

      that consolidates the information.

      > After some processing, the sheets 1-3 have variable amounts of data.

      I am trying to copy the data from each of the sheets into sheet 4.

      > The data in sheets 1-3 use columns A-F - all cells in column "A" will

      contain an index number, but this is not unique to each row.

      > One method i had thought of using was to calculate the last non-blank

      row of column "A", and then copy range A1->F(last row) and then paste

      into the relevant place in the last sheet... but I just can't help

      feeling that there must be a simple (advanced) filter in VB that will

      select all the non-blank cells and allow to copy / paste.

      > I'm very curious to know if there is... i can work through the above

      option OK... TIA

      > Mike

      #1; Mon, 26 May 2008 14:32:00 GMT