Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet reference
Hello again,
I have a new question... I need to reference cells a2:d8 into another worksheet in a different part, such as a9:d15. I'm hoping that there is a way to do this without having to reference each cell individually... because I have 8 different worksheets where I need to reference the same group of information. Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet reference
Hi Mike. AFAIK you will have to reference each individual cell. However,
you can select the target sheets as a group, type an = sign in A9 and then select A2 from your base sheet and it will update all the selected sheets at once. Keep the sheets selected and copy and paste A9 in A10:A15. Finally, copy A9:A15 over to D9:D15. This should establish your matrix in all the target sheets. HTH -- Sincerely, Michael Colvin "Mike" wrote: Hello again, I have a new question... I need to reference cells a2:d8 into another worksheet in a different part, such as a9:d15. I'm hoping that there is a way to do this without having to reference each cell individually... because I have 8 different worksheets where I need to reference the same group of information. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using cell contents to reference worksheet names | Excel Discussion (Misc queries) | |||
Worksheet reference behaving funny | Excel Discussion (Misc queries) | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference a cell to get worksheet name | Excel Worksheet Functions |