Happy Turkey Day,
I am looking to build a macro that will loop down a column and when it finds a particular string, it will start adding values backwards ( towards the top of the page) from a corresponding column in that row.
In my attached spreadsheet...I would like the loop to go and find the first instance of the string "bos" in column c and from there... start adding the value in Cell i13 to cell f12 and posting the result in g12 and then the value in g12 is added to the value in f11 and that result is posted in g11 so on and so on...all the way to cell g2.
Let me know if there is additional clarification needed. it would be a big help to see how you guys would approach this with loops.
Bookmarks