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

Hi all,

I am a beginner and certainly need help. I am also a new member and accept my apology for making initial errors in posting a question as I am not used to terms like thread, quote etc etc.
If any one can help me on this then I will be very thankful. If you need any clarification on my question, then please feel free to ask me, as it may be the case that my question may need rephrasing.
Please help
Kind regards