Good evening all,
I need to extract the formula data in cell J10 across 150+ tabs of an excel file & list those formulas to a report tab.
The formulas are different in J10 from tab to tab so I can't do a global change. In addition, some tabs don't have a formula in J10 at all.
I need to modify the formulas slightly & to not miss any tabs, my thought was to have the formulas extracted in a list format on another tab, I can do the find & replace function.
I've never done VB before, so if that's what you are going to suggest, I'll need a little bit of direction on how / where to enter it.
Thanks !!!
Bookmarks