-
That works for everything except the Material Specifications. For that I will have to use a macro. I believe that I can use
Select Case ActiveSheet.Range()
to actually select the worksheet. The problem I am having is that I don't know how to initiate the command or how to go to a command that will basically use the vlookup on the selected sheet. The only way that I know how to do this is to use an if() statement with all of 15 sheets defined in it.
I will try that for now but if anyone can suggest an easier/better way, I would be most grateful.
Thanks
Shane
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules