DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,968
I think this is the worksheet function to use, but not positive.
I have employee names in row 1 every other column starting in U1. So U1, X1, AA1 etc...
I would like to reference these employees down column A. Rather than enter the physical cell reference for each employee name down column A, I was thinking that using the offset somehow would work. But not sure how to get started.
Any assistance please?
thanks,
ds
I have employee names in row 1 every other column starting in U1. So U1, X1, AA1 etc...
I would like to reference these employees down column A. Rather than enter the physical cell reference for each employee name down column A, I was thinking that using the offset somehow would work. But not sure how to get started.
Any assistance please?
thanks,
ds