getting information from sheet 1 into sheet 2

  • Thread starter Thread starter Sherrill
  • Start date Start date
S

Sherrill

we use excel as a drawing register, with the first set being version A and
the second set being Version B and so on. I want to link the second sheet
into the first sheet with something that searches a cell and if that cell is
empty then go to the cell in the previous colum but same row and if that cell
is empty then go to the next previous cell, same row and previous colum.
I am a beginner with just enough knowledge to stuff everything.
 
I want to understand your situation better. Your have a workbook with at
least two worksheets.

On sheet 1, you have data maybe in the first few columns and you want to
copy only the last column of data in a row for row basis to sheet 2. Is
that correct?

This would require a macro to do.

In pseudo code, it would look like this

1. look at the last possible column using the first row of data on sheet 1
2. if there is data there, copy it over to sheet 2 first column(same row),
otherwise look at the next cell to the left and repeat step 2 until there
are no more cells to look at tin this row.
3. look at the last possible column using the next row of data on sheet 1
4. repeat steps 2 and 3 until there are no more rows to look at on sheet 1.

Dennis
 
Back
Top