Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy part of large WS to another sheet
Excel 2000 - I'm trying to help a co-worker with this, but I'm only a bit
more proficient than she is. She has a very large worksheet and would like to copy sections of it to individual sheets (in the same workbook), so that she can work on the smaller sheets - easier to read, not so much scrolling, etc. and update the larger, original worksheet at the same time. I can copy one formula and have it reference back to the original sheet, but when I try to copy the whole section, the formulas are copied, but they don't reference back to the large sheet. I'm pretty sure this is not difficult to do, but I don't know if I've worded the problem clearly enough for someone to help us. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy part of large WS to another sheet
Try Edit/Paste Special and use the PasteLink button.
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy part of large WS to another sheet
Thank you so much! I'd never even noticed that there was a Paste Link option.
I realized after I posted the question though, that even if we get the links (and now I know how) we still won't be able to do what we wanted - change the info on the new sheet and have it update the original one. We can make the changes on the original one and the new, smaller sheet will be updated. Is there a way, or should she just stick to working on the large sheet? The whole purpose of copying sections of the large 'summary' sheet was to have fewer rows/columns to deal with at one time. "Jovan Timotijevic" wrote: Try Edit/Paste Special and use the PasteLink button. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy part of large WS to another sheet
With the Filtering functions Excel provides under DataFilter you wopuld be
better off keeping everything on one sheet. Easier to manage. Gord Dibben MS Excel MVP On Tue, 19 Jun 2007 05:46:00 -0700, Aurise wrote: Thank you so much! I'd never even noticed that there was a Paste Link option. I realized after I posted the question though, that even if we get the links (and now I know how) we still won't be able to do what we wanted - change the info on the new sheet and have it update the original one. We can make the changes on the original one and the new, smaller sheet will be updated. Is there a way, or should she just stick to working on the large sheet? The whole purpose of copying sections of the large 'summary' sheet was to have fewer rows/columns to deal with at one time. "Jovan Timotijevic" wrote: Try Edit/Paste Special and use the PasteLink button. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
Find and copy part of a cell | Excel Worksheet Functions | |||
How do I copy part of each cell in a column? | Excel Discussion (Misc queries) | |||
Copy cell formating as part of a formula | Excel Worksheet Functions | |||
Unable to format colors on part of a large spreadsheet | Excel Worksheet Functions |