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?
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?
