I have a problem with my nested if statements as im trying to use more than 7
this is the code i'm currently using and it works for me but i need to add 3 more sheets to it
this is what it needs to be
Please Login or Register to view this content.
is there another option?Please Login or Register to view this content.
Thanks in advance
Try like this,
Please Login or Register to view this content.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
You may want to use VBA and run a macro. There isn't the same 'Argument Limit' as there is for individual cells in a spreadsheet.
If you post a sample, I may be able to write a macro that would work for you.
Click on the * icon if this post has been helpful.
This worked perfectly thanksOriginally Posted by Haseeb A
is there a way for it to pick up weather there is a duplicate entry or not? ie if they were working in 2 areas at the same time?
Enter all 9 sheet names in a range & define a name like 'Shtnames', then in a cell eg; B5 with CTRL+SHIFT+ENTER
and copy down.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks