Hello. I have a file that has a list of items (about 200) in column A. Each item has the same fields associated to it in column B (e.g. Beginning inventory, Expected Receipt, Forecast, Shipped Units, Open Orders, Ending Inventory). There's more, but you get the point. The data extends forward many weeks starting in Column C. These fields are populated by a formula. I'm looking to run a macro that allows me to hardcode only certain fields mentioned above but leave the others active.
I'd like Beginning and Ending Inventory to always remain a formula but hardcode the others starting in Column C through the end of the row. The number of items is constantly changing so it would need to be able to loop until the last sku. Same with the number of weeks in the columns.
Is this possible?
I'd otherwise just leave the formulas but I think they're causing the file to run very slowly.
Thanks in advance.
I'd like Beginning and Ending Inventory to always remain a formula but hardcode the others starting in Column C through the end of the row. The number of items is constantly changing so it would need to be able to loop until the last sku. Same with the number of weeks in the columns.
Is this possible?
I'd otherwise just leave the formulas but I think they're causing the file to run very slowly.
Thanks in advance.