Update different sheets . VBA

di20041991

New Member
Joined
Apr 25, 2014
Messages
1
I'm new to all VBA concepts so I really need help. I have a file with 3 sheets. The first one contains clients from the UK and FR (this being column 3) , the second one clients only from the UK and the third one clients only from FR. I want a code that will update the second and third sheet once a modification occurs in sheet1.

I have to specify that clients are randomly added and arranged, so the new entries won't neccessarily be in the last row. My sheets are called : sheet1, sheet2, sheet3.

I don't know if there's a code for updating, but I was thinking of having one who would clear the sheet and then copy all rows from sheet 1 who meet the criteria (country - column C, starting with C9 because of the headers).

All tables have 18 columns, the criteria column being C.

Do you think you can help me with this?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

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