conditional copying from one sheet to another & dynamic print area

[QUOTE=arlu1201]
Hi,
I have three sheets.
In first sheet row A to F contain data and G is used for entering date.
I have used code which works great to delete entire row from sheet- and paste it to sheet 2 as soon as I enter date in G or column 7.


Now, I have duplicated the rows of sheet 1 to sheet 3.

I need help for
1. I want only populated rows from sheet 1 to be copied to sheet 3 at any given time.
( it is to remind us that the rows are deleted when the date is entered so it is ongoing status of entering new data and deleting the completed one)

2. Secondly the rows are formated in sheet 1 and 3 ( showing borders) of only populated cells.

3. At any given time if I print sheet 1 or 3, it should print only populated print area.

Is there anyone willing to help me please.

Kind regards