I've attached a simple example of what I am trying to do.
I want to copy down formulas in the "Buyer (Example)" tab so that it shows all the items on a list in the MRP tab. (It seems redundant but in the real example it make sense to have a second tab.)
I need to do this using the last number in they "Buy Column" on the MRP tab. The number is 17. I need to copy down the formulas in the "Buyer (Example) tab down 16 rows (17 minus the 1 row I already have.)
The number of items on the "MRP" tab is random every day. It could be 17 items today but 25 items tomorrow.
Bookmarks