VBA CODE to Copy Paster data from one sheet to other sheet on a daily basis

Hi all,

Could any one please help me.

We used to have a extract data which will change on a daily basis.

But I want to see the trend of the same for a month.

The data looks like

Unit----- period------- Amt

Product will remain unchanged but period and the amount changes on a daily basis
While I want to see the trend .

I want to see the data gets pasted on a daily basis one after the other.

Herewith i have attached the sample sheet where in the before sheet we will extract the data daily which will change on a daily basis .

I want the after sheet to capture the data and paste the data one after the other as it was on the sheet.

hope this helps.

Thanks a lot.

Try this macro. Change the sheet names to suit your needs.

Please Login or Register  to view this content.

Thanks for the assistance,

The Coding is not working it shows error as

"Object Variable or With Variable not set" while trying to run the Macro.

Try the attached file. Click the button. Is this what you want?

Hi Mumps1,

Thanks a lot for the help the Coding is working very fine.

Regards,

Aravind

My pleasure!

Hi Mumps1,

The coding is not working when there is no data in the after sheet.

When I am trying to paste the data for the first time it's not working
Once I pasted the data manually it works.

Could you please help me by providing the code for pasting the data from the first time itself .

Thanks in advance

Hi Aravind. Please try this macro:

Please Login or Register  to view this content.

Hi Mumps1,

Thanks a lot for the coding this is working very fine.

Glad it worked out.