That should work. Try putting that sheet qualifier in the formula before you add the extra sheet and see what you get.
After that, maybe post the workbook for us to see.
That should work. Try putting that sheet qualifier in the formula before you add the extra sheet and see what you get.
After that, maybe post the workbook for us to see.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote