| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using offset to select a range
Does any on know how to use the offset function to select a range in another
excel file I'm trying to use this with the sumif function, and want to select the column location based on target location column A Thanks -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using offset to select a range
Don't understand the question. Can you post an example of data in each
workbook together with the conditions for the sumif and the result you would expect in the example of data. Also this is posted under Excel programming. Do you want the answer in VBA? -- Regards, OssieMac "QuietMan" wrote: Does any on know how to use the offset function to select a range in another excel file I'm trying to use this with the sumif function, and want to select the column location based on target location column A Thanks -- Helping Is always a good thing |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using offset to select a range
Thanks, figured it out
-- Helping Is always a good thing "OssieMac" wrote: Don't understand the question. Can you post an example of data in each workbook together with the conditions for the sumif and the result you would expect in the example of data. Also this is posted under Excel programming. Do you want the answer in VBA? -- Regards, OssieMac "QuietMan" wrote: Does any on know how to use the offset function to select a range in another excel file I'm trying to use this with the sumif function, and want to select the column location based on target location column A Thanks -- Helping Is always a good thing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range Select with ActiveCell and Offset property | Excel Programming | |||
| Help in using an Offset in a .Range().Select | Excel Programming | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Select Range - using Offset ( 40 ,0 ) - not working | Excel Programming | |||
| Select and Copy Range using Offset | Excel Programming | |||
Hybrid Mode
