Hello,
I one last issue I am trying to solve to complete my project and I am at a loss on how to fix it.
Sheet1 = "Inventory Value Report" - I am using this as an "import tab" where a new value report is pasted every time it needs to be used.
My issue is that the first macro that runs deleted unnecessary columns, and this causes errors on subsequent macros because the column has been deleted and several #REF errors are inserted into the formulas.
Is there a way to run an INDEX:MATCH function where the ranges selected stay constant, no matter if the sheet is reformatted or data is deleted?
I one last issue I am trying to solve to complete my project and I am at a loss on how to fix it.
Sheet1 = "Inventory Value Report" - I am using this as an "import tab" where a new value report is pasted every time it needs to be used.
My issue is that the first macro that runs deleted unnecessary columns, and this causes errors on subsequent macros because the column has been deleted and several #REF errors are inserted into the formulas.
Is there a way to run an INDEX:MATCH function where the ranges selected stay constant, no matter if the sheet is reformatted or data is deleted?