Transferring from one sheet to another.

ARMATT

New Member
Joined
Nov 15, 2015
Messages
3
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?
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
4,013
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 ...
 

Watch MrExcel Video

Forum statistics

Threads
1,129,991
Messages
5,639,415
Members
417,088
Latest member
jonstr101

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top