If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
selective output tabling
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 |
Thread Tools | |
Display Modes | |
|
|