Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I duplicate info from an original worksheet to another?
On worksheet #1, I have two hundred names I want duplicated on worksheets 2 &
3. I also want worksheet 2 & 3 to reflect any changes that I make to worksheet #1 should we add or delete any names. I would rather not do this cell by cell if I do not have to. HOpe this makes sense |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I duplicate info from an original worksheet to another?
Use the paste special feature.
On worksheet #1 copy the entire column (or all of the names and some extra ones for name you may want to add later). On the worksheets that you want the names to copy to - go to the cell where you want the names to copy to - go to Edit / Paste Special - Click on the 'Paste Link' button on the bottom of that window. Now when you add, change or edit a name on Worksheet #1 the rest of the worksheets will update. Note: if you add, edit or change the paste linked cells on the other worksheets - it will break the link! Hope this helps. Tonya "spiderWebb" wrote: On worksheet #1, I have two hundred names I want duplicated on worksheets 2 & 3. I also want worksheet 2 & 3 to reflect any changes that I make to worksheet #1 should we add or delete any names. I would rather not do this cell by cell if I do not have to. HOpe this makes sense |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract duplicate rows to another worksheet | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
AUTOMATICALLY REFERENCE SALES INFO FROM WORKSHEET #1 INTO INDIVID. | Excel Worksheet Functions | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |