My Dear Excel Friends,

Greetings.

I have a an excel table with over 10 columns and 31 rows (each row represents each day). Now, the entry passed on the second day needs to be printed on the same sheet as printed for the first entry. Why? Well a supervisor signs-off the first entry. He wouldn't sign the first entry again. It would be absurd and impractical.

I tried to print a selection, range of cells and particular row only etc. However, each time the cells are printed as the first line.
How do I get excel to print only what I have entered new for the day in the exact position of that day on the same sheet of paper? Hope I am clear with my requirement.

I am decent at VBA. So, if there is no viable usual route, please do guide me via the VBA route.

Thanks in advance for your expert advise.


Philip