I get a an excel document every day. I have to transfer a portion of the information onto a second excel sheet. While the information changes daily the location on both sheets never changes. I'm tired of copying and pasting! What is something I can do to speed this process up of transferring data form one sheet to another sheet? Could a macro be a good solution for this issue?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Transferring from one sheet to another.
- Thread starter ARMATT
- Start date
Logit
Well-known Member
- Joined
- Aug 31, 2016
- Messages
- 4,846
Yes ... a macro would do the copy/paste instantly.
You would need to indicate the layout of both sheets as well as the name of the sheets. This could be assisted if you
would post a sample workbook (no confidential information) to a CLOUD website for download and review. Indicate
in the workbook how the data should be copy/pasted ...
You would need to indicate the layout of both sheets as well as the name of the sheets. This could be assisted if you
would post a sample workbook (no confidential information) to a CLOUD website for download and review. Indicate
in the workbook how the data should be copy/pasted ...
Upvote
0
Similar threads
- Question
- Question
