Hi All
I've been searching for a few days now for a macro that will copy and paste cells if a certain criteria is met. I also would like it to update any previous entries if change is made.
The background is I have a workbook with 14 tabs and a "Master" tab. Each tab has 3 columns (D, E and F) that contain data and i wish to copy the 3 cells from that row if the cell in Column F contains any number from 1-5. If it does and the macro is run again the following week with a change made to the previous number then is there a way this could auto update the previous weeks entry instead of creating a new one i.e. 1st week it is a "2" but the following week it is now a "3"?
Any help is greatly appreciated!
I've been searching for a few days now for a macro that will copy and paste cells if a certain criteria is met. I also would like it to update any previous entries if change is made.
The background is I have a workbook with 14 tabs and a "Master" tab. Each tab has 3 columns (D, E and F) that contain data and i wish to copy the 3 cells from that row if the cell in Column F contains any number from 1-5. If it does and the macro is run again the following week with a change made to the previous number then is there a way this could auto update the previous weeks entry instead of creating a new one i.e. 1st week it is a "2" but the following week it is now a "3"?
Any help is greatly appreciated!