i have a workbook with couple sheets. sheet1 has info that gets "empty" out
every day (sales) on page2 i have dates down colum a and need the sales
from sheet1 to be carried over.

for this ill need a macro to copy info from sheet1 cell c15 to the next open
cell down ward in colum a. i allready have a macro that print and clear
the info enterd on a dayly basis.