Hi all
I have gone through the past post find it difficult to get some help from previous post.
The idea is i want to create a command button that is able to update values in sheet 1 from sheet 2.
When the command button is pressed. The macro will check all the Id and update with new figures if it matches with that in sheet 2.
If it notices and old account number that is not found in sheet 2 it will delete this. The tricky thing is the row in which it has to update this figure is not on the same row as the account no. If it also finds that there is a new account no in sheet 2 that is not in sheet 1, it should insert it following the format below. It the value is the same then it should do nothing.
It should add them in ascending order of the account no.
Thanks a million
Below is an example of the idea
Sheet 1
A B C
Account no Text Amount
1- 10012 Tequeue
2- Checkbook 2000
3-
4- 10013 Bernato dia
Checkbook 3000
Sheet 2
A B C
Account no Text Amount
1-10011 Setin 500
2-10012 Tequeue 4500
3-10013 Bernato dia 3000
4-10014 Newman 1000
please help
I have gone through the past post find it difficult to get some help from previous post.
The idea is i want to create a command button that is able to update values in sheet 1 from sheet 2.
When the command button is pressed. The macro will check all the Id and update with new figures if it matches with that in sheet 2.
If it notices and old account number that is not found in sheet 2 it will delete this. The tricky thing is the row in which it has to update this figure is not on the same row as the account no. If it also finds that there is a new account no in sheet 2 that is not in sheet 1, it should insert it following the format below. It the value is the same then it should do nothing.
It should add them in ascending order of the account no.
Thanks a million
Below is an example of the idea
Sheet 1
A B C
Account no Text Amount
1- 10012 Tequeue
2- Checkbook 2000
3-
4- 10013 Bernato dia
Checkbook 3000
Sheet 2
A B C
Account no Text Amount
1-10011 Setin 500
2-10012 Tequeue 4500
3-10013 Bernato dia 3000
4-10014 Newman 1000
please help