D
dads3nads
Hi,
I have an extended table;
A B C D E
1 key area code present required
2 1 LGA FD J3 2 1
3 2 LGA1 G2 0 3
4 3 LGA2 X5 3 0
5 4 LGA3 I/14 1 2
6 5 GA L2 6 0
7 6 1A Z1 1 2
8 ...
The formula in 'E1' is: =IF(D2>=3,0,3-D2)
All other cells contain static/manually enterd data.
What I need to do is create another sheet that tabulates all keys that
are required and omits those that are not without running a macro
preferably.
e.g. 'Order' worksheet would look like this;
A B C D E
1 key area code present required
2 1 LGA FD J3 2 1
3 2 LGA1 G2 0 3
4 4 LGA3 I/14 1 2
5 6 1A Z1 1 2
6 ...
any suggestions welcome
many thanks
I have an extended table;
A B C D E
1 key area code present required
2 1 LGA FD J3 2 1
3 2 LGA1 G2 0 3
4 3 LGA2 X5 3 0
5 4 LGA3 I/14 1 2
6 5 GA L2 6 0
7 6 1A Z1 1 2
8 ...
The formula in 'E1' is: =IF(D2>=3,0,3-D2)
All other cells contain static/manually enterd data.
What I need to do is create another sheet that tabulates all keys that
are required and omits those that are not without running a macro
preferably.
e.g. 'Order' worksheet would look like this;
A B C D E
1 key area code present required
2 1 LGA FD J3 2 1
3 2 LGA1 G2 0 3
4 4 LGA3 I/14 1 2
5 6 1A Z1 1 2
6 ...
any suggestions welcome
many thanks