Hello,
I will be using two sheets - both identically labeled, spaced, etc. Sheet 1 (Name is "Open Items") will consist of the input data, with it being columns A-R with various and simple formulas included (eg: Cell L120 =J120*H120) and also a Margin calculation and Profit calculation. Column R is going to be the data that I'd like to use to kick the entire row to the other sheet (Sheet 2 - named "Completed Items"). This will be a simple "YES" and "NO". The data will be generated onto "Open Items", with Column R stating "NO" until the task is complete (sometimes days, weeks, months) Once it is changed to "YES" I'd like the row to be moved to "Complete Items". If possible I would like this to be automatic from here on out - I have ~300 lines I need to move and I'd like to automate the process going forward as well as function properly for the existing rows. With the two sheets being identical, I'd like to have the simple formulas intact as it moves from "Open Items" to "Completed Items" with totals calculating a few rows from the bottom of the list and kept up to date as the data moves from "Open Items" to "Completed Items"
I know exactly what I want to happen, but no idea how to get it to work. I am terrible at explaining so please let me know if there is anything I can try to explain better or in more detail that would be of use.
Thank you very much for your time.
I will be using two sheets - both identically labeled, spaced, etc. Sheet 1 (Name is "Open Items") will consist of the input data, with it being columns A-R with various and simple formulas included (eg: Cell L120 =J120*H120) and also a Margin calculation and Profit calculation. Column R is going to be the data that I'd like to use to kick the entire row to the other sheet (Sheet 2 - named "Completed Items"). This will be a simple "YES" and "NO". The data will be generated onto "Open Items", with Column R stating "NO" until the task is complete (sometimes days, weeks, months) Once it is changed to "YES" I'd like the row to be moved to "Complete Items". If possible I would like this to be automatic from here on out - I have ~300 lines I need to move and I'd like to automate the process going forward as well as function properly for the existing rows. With the two sheets being identical, I'd like to have the simple formulas intact as it moves from "Open Items" to "Completed Items" with totals calculating a few rows from the bottom of the list and kept up to date as the data moves from "Open Items" to "Completed Items"
I know exactly what I want to happen, but no idea how to get it to work. I am terrible at explaining so please let me know if there is anything I can try to explain better or in more detail that would be of use.
Thank you very much for your time.