Macro to transfer previous weeks data.

**coolhit** · 10-08-2009, 06:28 AM

Hi

Please can some help me I have spreadsheet where i want to transfer current weeks data to archive as its now last weeks data.

ie. date 27th sunday October 2009 to 3rd Saturday October 2009 data is in current week sheet which is now old and its last weeks data, so i want a button to transfer to archive sheet bottom of old data and clear the current week sheet.

Please can you assist me

I have attached file.

Regards

**royUK** · 10-08-2009, 06:48 AM

I have added a row in the weekly sheet between the merged cells & the header row of the table.

Please Login or Register  to view this content.

**coolhit** · 10-08-2009, 07:23 AM

Originally Posted by royUK

I have added a row in the weekly sheet between the merged cells & the header row of the table.

Please Login or Register  to view this content.

Hi Roy

So sorry to trouble you said "I have added a row in the weekly sheet between the merged cells & the header row of the table". I can't see where this is.

two sheet i have is sheet 1 = Current Week and sheet 2 = Archive.
Button i have called is CmdTransferButton.

I download the file inserted the code on the button created but didn't work.

Please can i beg you if you could update the file and i will download it, i am been very cheeky.

appricate you help

regards