View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sunil Somani Sunil Somani is offline
external usenet poster
 
Posts: 1
Default Help for excel macro ( to append records)

Dear All,

Please suggest me the sample code or steps to append records at the end in a
excel sheet in same workbook.

Background: I am writing a macro, IN my work book there are two work sheets.
One is daily ( Populated with daily data and erase yesterdays data)
One is Monthly ( Motive is to keep daily data for Monthly calculations)

Now task is to copy data/records from daily sheet to Monthly sheet today and
then append everyday data from daily sheet to monthly sheet.

I am facing issue in appending the data.

Kindly advise, either with sample code or steps.

Thanks in advance,

Best regards,
Sunil Somani