Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula or script needed
I am trying to use a formula or script to take the data from Sheet two column
C to sheet one given certain criteria in sheet one column A and sheet two columns A and B. Below are the two sheets along with what sheet one should look like after. This is for a rather large range of data. Thank you Jeremy Sheet one A B 1 5657 0020 2 5657 0021 3 1345 0010 4 1345 0020 5 1342 0020 Sheet two A B C 1 5657 0020 JDR1 2 5657 0020 JDR2 3 5657 0020 JDR3 4 5657 0021 JDR4 5 1345 0010 JDR5 6 1345 0020 JDR6 7 1342 0020 JDR7 8 1342 0020 JDR8 9 1342 0020 JDR9 What sheet one should look like on sheet one from data in sheet two columns C A B 1 5657 0020 JDR1, JDR2, JDR3 2 5657 0021 JDR4 3 1345 0010 JDR5 4 1345 0020 JDR6 5 1342 0020 JDR7, JDR8, JDR9 Can look like and go to e and so on if more JDR numbers corresponding to A in sheet one A B C D E F 1 5657 0020 JDR1 JDR2 JDR3 2 5657 0021 JDR4 3 1345 0010 JDR5 4 1345 0020 JDR6 5 1342 0020 JDR7 JDR8 JDR9 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Script Code needed for Grouping Rows | Excel Discussion (Misc queries) | |||
Formula Help needed | Excel Worksheet Functions | |||
Vlookup formula script | Excel Discussion (Misc queries) | |||
How can I script formula? | Excel Worksheet Functions | |||
Help needed (Automatic script function) | Excel Discussion (Misc queries) |