| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to modify a primary worksheet linked to another worksheet
Hello,
I need to know how to modify a primary worksheet which is linked to another worksheet/cells, without changing the data of a secondary worksheet. I want to add/delete/move rows to the primary worksheet without affecting the other linked cells. How can I do that? Please I need some help! Thanks! Marcela |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to modify a primary worksheet linked to another worksheet
Hi,
Make a copy to another workbook "mamorellana" wrote: Hello, I need to know how to modify a primary worksheet which is linked to another worksheet/cells, without changing the data of a secondary worksheet. I want to add/delete/move rows to the primary worksheet without affecting the other linked cells. How can I do that? Please I need some help! Thanks! Marcela |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to modify a primary worksheet linked to another worksheet
????
"Eduardo" wrote: Hi, Make a copy to another workbook "mamorellana" wrote: Hello, I need to know how to modify a primary worksheet which is linked to another worksheet/cells, without changing the data of a secondary worksheet. I want to add/delete/move rows to the primary worksheet without affecting the other linked cells. How can I do that? Please I need some help! Thanks! Marcela |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to modify a primary worksheet linked to another worksheet
Hi Eduardo,
Can you please give me further instructions how to do it? I have a primary worksheet that contains dates. Example: Book1 - Cell I19 has a date as of 16-Jun-06. And Book 2 - Cell L2 is linked to Book 1 - Cell I19 as =[Book1.xls]Sheet1!$I$19. If I add, move or delete rows on the primary worksheet, all the dates in the secondary worksheet are mess up. What can I do?? I want to add/move/delete rows on Book1 without affecting Book2. Thanks! Marcela "mamorellana" wrote: ???? "Eduardo" wrote: Hi, Make a copy to another workbook "mamorellana" wrote: Hello, I need to know how to modify a primary worksheet which is linked to another worksheet/cells, without changing the data of a secondary worksheet. I want to add/delete/move rows to the primary worksheet without affecting the other linked cells. How can I do that? Please I need some help! Thanks! Marcela |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to modify a primary worksheet linked to another worksheet
One guess ..
Provided Book1.xls is always simultaneously open with Book2.xls In Book2.xls, instead of: =[Book1.xls]Sheet1!$I$19 you could use: =INDIRECT("[Book1.xls]Sheet1!I19") which will always point to that particular source cell, ie I19 in Sheet1, in Book1. Irrespective of what you may do (eg: add/move/delete rows in Book1) which may impact that particular source cell. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "mamorellana" wrote: I have a primary worksheet that contains dates. Example: Book1 - Cell I19 has a date as of 16-Jun-06. And Book 2 - Cell L2 is linked to Book 1 - Cell I19 as =[Book1.xls]Sheet1!$I$19. If I add, move or delete rows on the primary worksheet, all the dates in the secondary worksheet are mess up. What can I do?? I want to add/move/delete rows on Book1 without affecting Book2 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to modify a primary worksheet linked to another worksheet
I already tried using =INDIRECT infront of the formula, but whenever I modify
Book1 by adding, moving or deleting rows, all my dates in Book 2 are mess up. Should I lock the full row in Book1? or what else can I do? Thanks!! Marcela "Max" wrote: One guess .. Provided Book1.xls is always simultaneously open with Book2.xls In Book2.xls, instead of: =[Book1.xls]Sheet1!$I$19 you could use: =INDIRECT("[Book1.xls]Sheet1!I19") which will always point to that particular source cell, ie I19 in Sheet1, in Book1. Irrespective of what you may do (eg: add/move/delete rows in Book1) which may impact that particular source cell. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "mamorellana" wrote: I have a primary worksheet that contains dates. Example: Book1 - Cell I19 has a date as of 16-Jun-06. And Book 2 - Cell L2 is linked to Book 1 - Cell I19 as =[Book1.xls]Sheet1!$I$19. If I add, move or delete rows on the primary worksheet, all the dates in the secondary worksheet are mess up. What can I do?? I want to add/move/delete rows on Book1 without affecting Book2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Email worksheet linked to another worksheet | Excel Discussion (Misc queries) | |||
| Date of worksheet comes out numbers on other linked worksheet | Excel Worksheet Functions | |||
| Links not updated when primary worksheet is sorted | Excel Worksheet Functions | |||
| Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
| How do I replicate data from primary worksheet to other worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
