moving excel sheets

  • Thread starter Thread starter Joanna Sprague
  • Start date Start date
J

Joanna Sprague

How did i move a row from one excel sheet to another, when it hits a
certian date. So for example if one sheet two i had a colum that once
it hit the date in one of the cells in that colum it would jump to
sheet one.
 
You can do this sort of thing with a worksheet_change event macro. Does the
whole column move or just the cell or the row of the cell? More explanation
needed.
 
In one sentence you mention rows, and in the other, you mention columns.

Without using code, one possibility would be to set up the Sheet1 row to
display (copy, *not* move) the contents from, say Sheet2, Row 10, if the
date in D1 was met or exceeded:

=IF(TODAY()>=D1,INDEX(Sheet2!$10:$10,COLUMN(A:A)),"")

Enter this wherever you wish in Sheet1, and copy along a row, across as many
columns as you wish data to be returned.

Change "A:A" to match the starting column of data on Sheet2.

If you wish to pursue this route, there are ways to go "column to row" as
well as "row to column".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Joanna Sprague"
message
How did i move a row from one excel sheet to another, when it hits a
certian date. So for example if one sheet two i had a colum that once
it hit the date in one of the cells in that colum it would jump to
sheet one.
 
Back
Top