Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically copy columns to/from Excel worksheets?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically copy columns to/from Excel worksheets?
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 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. "Paul" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically copy columns to/from Excel worksheets?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel table in Word automatically from data in Excel | Excel Discussion (Misc queries) | |||
Excel file automatically opens - More Info | Excel Discussion (Misc queries) | |||
Find differences between two Excel workbooks or worksheets | Excel Discussion (Misc queries) | |||
How do you turn off automatic "save a copy" in Excel | Excel Discussion (Misc queries) | |||
Excel won't copy outside sheet | Excel Discussion (Misc queries) |