G
Guest
How can I open a file with multiple sheets and have a formula or code return
the names of the sheets so i can perform calculations on varying sheets with
out manually having to input them into my formulas.
Example: i open a file created by anouther user that has 7 or 8 sheets with
different names depending on the data in the sheets. I want to be able for my
formulas to adjust to those names with having to input them in manually.
the names of the sheets so i can perform calculations on varying sheets with
out manually having to input them into my formulas.
Example: i open a file created by anouther user that has 7 or 8 sheets with
different names depending on the data in the sheets. I want to be able for my
formulas to adjust to those names with having to input them in manually.