Macro

[Greg Lions]

I have a file (Inbound) with two tabs (active container)
and (history). The active container tab has 20 columns
one of the columns (emptied date) once it is fill-in (may
have several fill-in at one time)with an actual emptied
date, I would like to run a macro to move that row into
the history file. I want the history file to keep all
records that are transfered into it.

TFTH,
Greg

 

[Dave Peterson]

If I were doing it manually, I'd apply Data|filter|autofilter to the range.

Filter by that column to show non-blanks.

Copy those visible cells and paste into the other sheet.

Then come back to the original worksheet and delete those rows.

If I wanted it automated, I'd start by recording a macro when I did it manually.

If you need help with your recorded code, post back.