Hi all,
Every day I get a long list of data in two colums. Such as follows:
C1 C2
q 1
w 2
e 4
r 4
t 6
w 4
For every combination of a value in C1 and C2, there is a unique code which includes text and numbers. EG. 67XY.
I need to create a macro which creates from the two colums C1 and C2, Column C3 with all the unique codes.
Can anyone aid me in this?
Last edited by JBeaucaire; 07-10-2013 at 10:14 AM. Reason: Corrected the title, as per Forum Rules. Please take a moment to read the forum rules, link is in the menu bar above.
Do you have a list of these unique codes?
HTH
Regards, Jeff
Yes, its a long list in excel, which I cant post here due to privacy rights. sorry.
The list shows me for example:
q 1 001XY
q 2 002XY
w 1 11ZZ
w 2 TJF
The list does not show consistancy, as I show above. The unique codes differ in length, and signs.
I would look into a simple lookup table.
Take your unique codes and place them in a table with the q1 in the same column and the 001XY next to it.
Now in C1 >> =LOOKUP(A1&B1,G1:H4)
I hadn't thought of that, but that works perfect thanks!
Glad to hear you have a working solution now and thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
In addition to my last question, maybe you can help with the next step aswell. The lookup function works good, when using an additional file with the table.
However I need to create the macro such that when I open a new list of input data, I can execute the macro, leading to the correct output without having to open the additional file with the table.
I have added an example workbook which shows the idea. Test workbook.xlsx
Input is the list i get and open, output is the list that should result from the macro. The codes is the list in between, which I need to intergrate somewhere such that I don't have to open it everytime in order run the macro.
Thanks!
I'm sorry but I am completely lost as to what you are wanting. You keep mentioning macro, but this is a formula we are working with so getting confused.
sorry, I clearly didn't explain it very good. I will try again!
The workfile shows:
- Input, this is the data I get
- Output, this is the dataformat as I want to have. Thus I need a macro which can transfrom input format to output format
- Codes, is the step in between input and output. This is the link between the Account and Counterparty, and the reference number which is necessary in the output.
The problem is, that I get the inputs in different documents everytime. I then want to run the macro on the new document, get the right output and continue with that. However, for that to work I need to have the codes .xls open, which is not always possible, as the macro will be run from different computers. So I am wondering how to solve this.
I hope this is more clear?
Any chance you could change the privacy information so that you could upload files? (I have done this numerous times...)
I think we generally want to see a starting point, and end result.
Example:
Customer - Account - Couterparty
Cat - Kitty Litter - Dog
I can create a macro that will output redirect to Excel. As for running a macro without Excel being opened, I am not that advanced yet...
Last edited by ussenterprise; 07-12-2013 at 02:32 PM.
Rep is appreciated. Click my * if I helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks