hi, this is my first topic and im not very clued up on forums, just though it would be a good place for some urgent help, ok, this is my question, as per my file i want to match up data from column D with data from column B and if found match, copy it to column C to the same raw as the match found, i hope someone out there can give me some help its very much appreciated.
thanks in advance
jorge
Maybe this in C2 copied down: =INDEX($A$2:$A$308,MATCH(D2,$B$2:$B$308,0))
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
hi, many thanks, that wasn't exactly what i wanted but i think it actually worked a lot better because the idea was exactly that to match the sku, so many thanks, how amazing is this 2 minutes waiting and got a reply and solutions, wow.
regards
Jorge
It must be psychic Monday
Dom
lol, maybe you can also tell me if instead of matching and coping the column A into column C, i would do the same but match the column D with column A and copy into column C (same raw as match) the ones that match, do i make sense ??
regards
Jorge
Can you post an example of what you want this to finish up looking like, not sure I follow.
Dom
hi , ive drawn some graphics in the sheet, maybe it makes more sense like that.
jorge
In C2 copied down: =IF(ISNUMBER(MATCH(B2,$D$2:$D$99,0)),B2,"")
Dom
hi, that worked perfect, thank you so much, could i cut it over the data instead of coping it over?
jorge
Not sure what you mean by this.Originally Posted by monteiro1969
Dom
i mean what the formula does is coping and match the values from D to C but leaves the data still on D, and what i mean is cutting the data from D to C instead of coping, im sorry for my English im Portuguese and its not easy to explain in a different language
jorge
No problem, your English is far better than my Portuguese (or any other language for that matter).
You can't alter a fixed value held within another cell using a formula I'm afraid. Anything like that would take a VBA macro. I could probably put something together if you're interested but will have to be tomorrow as finishing work now.
Dom
Hi dom,
sorry for late reply, that would be really nice, how much would that cost me? the thing is i can work with that formula however because all the data is still left in its original place it will be confusing to sort out the ones that dont match the column A, the idea is to allocate the ones that match the column A to products in stock and the ones that are left without match they will be given a different colour cell, it would be fine if i could have the cells that don't match in column D in a different colour.
after your great help and knowledge i have taken the decision to learn excel properly and will do as soon as i have some time.
many thanks once again.
Jorge
How about this?
It loops through the entries in column D and where a match is found in column B puts the value in column C and deletes the entry from D. You would therefore only be left in D with items that could not be found.
Please Login or Register to view this content.
The code needs to be placed in a regular code module and will work on the active worksheet.
Dom
Hi Dom, it works fine however it doesn't copy the matched cells over to the column C but it does indeed remove the matched cells from column D but i need both columns, column C with the matched results ( in the same raw as the match) and column D with all the cells that don't match. thanks again, you have been great.
jorge
Seems to work for me if I've understood you. See attached example.
Dom
Hi Dom,
yes it does indeed many thanks once again, you have been amazing and very patient, any advise where i could have a crush course on excel? is lynda.com a good start?
jorge
Hi Dom,
how do you create that macro button? its very cool and convenient.
jorge
Never heard of Lynda.com until you mentioned it. The problem with most courses I've come across is that they tend to focus on using Excel functions without really explaining how the application itself really works. I guess they are okay but you'd do far worse than getting a decent Excel book and asking questions on places like this. You'll learn far more than a general course will give you if you're prepared to put in some work yourself.
For the macro button you just draw it off the Forms toolbar and Excel will ask you if you want to attach a macro to it.
Dom
hi Dom,
many thanks once again for your great help.
jorge
Hi Dom,
Over a year ago you were a great help and made up a formula to me that has been a fantastic help for me and my work (here is the tread for that http://www.excelforum.com/excel-gene...-new-post.html ) however i have now come to a situation where i need to extend that formula further, where before i needed to match up the data from one column with another i now need the same formula but i also need the 3 following columns to follow as well, im enclosing a sheet with the initial formula you done for me and what else i would like, i hope im not being chicky and asking for help again and i really hope you can help me again.
The idea is to match column D with the data from column B and move matching results to column C however this updated formula needs also to move all the data from column E F G H I J along with column D but its the D data that needs to match the data from column B, columns E F G H I J need to follow the Data from D. i hope you understand what i mean.
many thanks once again.
Last edited by monteiro1969; 05-13-2012 at 02:52 PM. Reason: adding file
Monteiro1969,
Don't post a question in an older thread -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks