Dates question

[SlimPickins]

I want to generate a list on a new sheet (sheet4) that will show info
corresponding to "sheet 1".

Basicly make a list on sheet 4 that will show rows of info from sheet
1 between 4.5 through 5 years past. If today is past five years remove
from list on sheet 4.

Sheet 1

700 rows and columns out from A to AH
column A entry listing 1-700. this column will grow with repeated info
as time goes on, updated as I do required service.
column B Date of service

Need to be notified on Sheet 4 of service coming due.
Service needs to be done every 5 years.

If I confused you I'll try to get into greater detail.


Slim

 

[Dave Peterson]

I'd keep all my data on one worksheet. But I'd apply Data|Filter|autofilter to
show/hide stuff.

If you really want to split it into a new worksheet, apply that filter and copy
the visible rows to the new sheet.

If you want the data removed from the original sheet, copy those visible rows,
paste them in a new sheet and come back and delete those rows.

 

[Dave Peterson]

Record a macro when you do it once and tweak the heck out of it????

 

[SlimPickins]

I'll pass that on to the client. But I don't think that is what he
wants.

He wants automation or as close to automation as possible.

Slim