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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to modify a primary worksheet linked to another worksheet
Hi,
in order to copy to another workbook, highlight your sheet, right click on the mouse, copy, go to a new sheet let's say sheet5 go to cell A1, right click on the mouse paste. Now you have your copy, you can play around with the numbers, without compromising your data. you can copy all the information in a new workbook. same procedure up to copy, then go to a new workbook again to cell a1 and paste there hope this helps "mamorellana" wrote: 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 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to modify a primary worksheet linked to another worksheet
.. whenever I modify Book1 by adding, moving or deleting rows,
all my dates in Book 2 are mess up Can you illustrate clearly with some sample data the above scenario? Show us some examples of your before/after scenario right now, and exactly what you would like to happen instead. As it stands, I'm out of further guesses. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "mamorellana" wrote: 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? |
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) |