Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
range name global
hi community
how can i create a range name that can be use within 2 worksheets, example in worksheet 1, i have range from A1:A3 and name that as "Fruits" also in worksheet 2, i have range from A1:A3 with similar data and also wanted to name that as "Fruits" my objective is as and when I am in worksheet 1 or worksheet 2, all i need to do is click the Name Box and select "Fruits", excel will select for me the range (A1:A3) if I am in worksheet 1 and when at worksheet 2, excel will select A1:A3 in worksheet 2 thanks community for the assistance :) -- oldLearner57 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Global Save As? | Excel Discussion (Misc queries) | |||
=OFFSET(!$A$1,,,,) - global range naming | Excel Worksheet Functions | |||
Range name: Change from sheet specific to global | Excel Discussion (Misc queries) | |||
Global Calculation ??? | Excel Discussion (Misc queries) | |||
Global Function | Excel Discussion (Misc queries) |