Macro to transfer row if criteria is met or update

Newbie19

New Member
Joined
Apr 14, 2013
Messages
24
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!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
In the Master tab is there an index or value that uniquely identifies each row in each of the 14 sheets?
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top