Also, I think your formula in H55 could be simplified to this...
=E55*C55*IF(B55="All",SUM($B$8:$B$10),VLOOKUP(B55,$A$8:$B$10,2,0))
Also, I think your formula in H55 could be simplified to this...
=E55*C55*IF(B55="All",SUM($B$8:$B$10),VLOOKUP(B55,$A$8:$B$10,2,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Many thanks...this has worked.
Surprised you cracked it with my vaguaries!
Last edited by simongra; 07-26-2018 at 03:42 PM.
Thanks...I will edit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks