How do I automatically copy columns to/from Excel worksheets?

P

Paul

I'm trying to set up a workbook where data that I enter on one worksheet,
that needs to also be shown on other worksheets, within the same workbook,
will automatically be displayed when entered on the main worksheet.
 
J

Jacob_F_Roecker

Have you tried paste link?

Select your range of cells on your input sheet and use CTRL+C

Then go to where you want them to be pasted.

Use the dropdown menu near the clipboard icon on the toolbar and select
paste special.

You'll see a selection there for Paste Link

This will copy whatever you put in your first sheet into the others.

I hope this helps

[email protected]

BTW if you need the formatting to look the same (dates in the same format
and such.) do a regular paste then the paste link.
 
D

DNA

You could take the sheet that's your "master" and reference cell or cells
from another worksheet's cells. Is that what you're talking about? If
so, something like this:

Master A1 would be =SUM('Worksheet Name'!B46) where B46 is the data you
want to reference.

HTH
 
Top