Conditional logic based on name of worksheet

Here's an idea.

set a variable to a number based on which sheet is active.
And that variable should be associated to which column you want to pull data from.

if sheet "Tampa" is active, set i=1
if sheet "Detroit" is active, set i=2
if sheet "Dallas" is active, set i=3

then I would use the "offset" property in the range object.

Please Login or Register  to view this content.

Then if activesheet = "Tampa" you will pull data from column A
If activesheet = "Detroit" you will pull data from column B
If activesheet = "Dallas" you will pull data from column C

Thats sounds perfect. Let me try it and get back to you.

Thanks a bunch.

That did it.

You guys are great!