Recording macros [Closed]

Report
Posts
1
Registration date
Sunday November 16, 2014
Status
Member
Last seen
November 16, 2014
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Any one know how to record a macro
From sheet to sheet? For example

I want to copy and paste open task from sheet one to two and next week open task from sheet two to three and so on

I recorded the following macro:
Filer. Open. Copy. Click sheet two. Paste it worked but when i use that recording it only goes as far as the copy....it wont paste the open tasks on sheet three

Any help is greatly appreciated!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
what macro you have used. It should paste. Could you paste your code here
Hi rizvisa

Im not too familiar with macro and codes. I didnt use codes i only recorded the
Macro: filter. Open. Copy. Paste on the next sheet
Thanks!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
Well could you paste that recorded macro ?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!