Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 3 worksheets that I fill with Data depending if the country is US,
Canada or Not Defined. What I want to do is reference the worksheet with a variable such as if country = US then n = 1 else if country = Canada then n = 2 else n = 3 endif This worksheet(n) = the data I don't know if this can be done. I get an error when I try it. If I can do this then I don't have to write a section for each of the different worksheets. Thanks In advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
making a portion of reference to a worksheet variable in a formula | Excel Discussion (Misc queries) | |||
Vlookup with variable worksheet reference | Excel Worksheet Functions | |||
Making a file and worksheet reference into a variable.... | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Using a variable as a row reference? | Excel Programming |