Hi folks,
I had posted a thread about this yesterday, but I managed to make quite a bit of progress on what I was trying to complete and now my goal has changed somewhat.
If I am going against forum rules, please let me know and I will continue on the original post - if not I will gladly close the thread down (not sure how to do that, I assume I need to request it from an admin?)
I have created a merged spreadsheet with tabs containing formulas hard coded with numbers, not cell references, e.g. =(250+75)*4)*2+...
What I am trying to do is search through all the tabs in the workbook and determine how many times the number is multiplied in a row - for example, in the case of the last cell, the column *250* would display "8"; I hope this is clear.
What is my best way of going about this? Now that I have the merged sheet, I only have a total of 6 tabs to look through in one workbook. I do need to look up about 8 different values in each cell and total these at the end of the row for each individual value.
Thank you!
Bookmarks