moving excel sheets

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.
 
D

Don Guillett

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.
 
R

RagDyeR

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.
 
Top