if statement with multiple ifs and multiple worksheet returns
I have looked as best i can on the site. i have designed an excel 'Master'
worksheet with continuous months on separate W/S behind ie Master,
jul2013, aug2013 etc I would like to insert an if statement does the
following from cell e2 in master look in 'master' b2 if b2 = say 'aug2013'
then go to worksheet 'aug2013' and brings back contents of 'cell b102'
on the master sheet this would need to be repeated in next cell down ie e3
checks b3 and goes to corresponding sheet and retrieves cell b102
i have tried multiple if statements but not having much luck would vba
help or something? Any thoughts much appreciated
No comments:
Post a Comment