Previous Topic Next Topic

Recording macros

Closed
Xiomara888 Posts 1 Registration date Sunday November 16, 2014 Status Member Last seen November 16, 2014 - Nov 16, 2014 at 11:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 16, 2014 at 11:00 PM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 16, 2014 at 12:23 PM
what macro you have used. It should paste. Could you paste your code here
Xiomara888
Nov 16, 2014 at 01:14 PM
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!
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 16, 2014 at 11:00 PM
Well could you paste that recorded macro ?

Similar discussions

How to send audio in Instagram
suyaprakash8429 -
Andy._Tani -

2 responses