automatically moving data depending on date

[nchok]

I have a spreadsheet with the following column titles:

Relationship Name
Fund Name
Request Live Date
Live Date
Opp Type
Opp Specs
.....

I have three worksheets in the workbook (each with all the same column
titles from above):

In Progress
Live & Funding


In the "In Progress" worksheet, I want my row of information to move to
the "Live & Funding" worksheet when the Live Date has either passed or
is the current date. For example, if the Live Date reads 6/26/06 and
the current day is 7/1/06, I would like the row of information in this
column automatically moved from the "In Progress" sheet to the "Live
and Funding" sheet.

Is there any way you can help me with VBA code to do this sort of a
function? I don't want the information copied from one sheet to the
next - i want it move from In Progress to Live & Funding.

 

[Bernie Deitrick]

Moving data is a bad idea. Simply add another column of formulas, along the lines of:

=IF(D2 > TODAY(), "In Progress","Live and Funding")

Then filter on that column to show "In Progress" or "Live and Funding".

HTH,
Bernie
MS Excel MVP