Duplicate Forumla with copy and paste 8 columns.

[forscienCe]

Ok I am a web & graphic designer so i am not a pro with Excel. I have recently done a marketing sms campaign and i exported a scv file from The cloud software Netsuite, this is exported with each user having a unique internal id. So i then imported this into a bulk sms portal website. 5800 records imported. Now there is a reply service where they say yes. On the SMSportal i can export results as a excel file. But i lose all those internal id's. So the only way to identify who said yes is two put the two excel files together and identify the duplicates.

But what i need done is little more complicated. I need t first have the SMS exported file check the Netsuite one and find the duplicated once it identifies the duplicates it needs to copy all the columns right next to it or something? But i need all those columns so i can reimport it into netsuite and update the contact records so we can see who replied yes and have it on record.

Let me know if this makes sense???

[brokenbiscuits]

I would suggest, if you can, to upload a sample workbook of the data you're working with. What you're wanting can most probably be done, but it's impossible to say how from the info above.

[Andrew-R]

I think it makes sense, but it would be really handy if you could post examples of both of the files. If you do I'd be happy to knock together a quick Excel macro for you.

[teylyn]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

With your first post, you ignored our rules about thread titles. With your second post, you ignored our rules about duplicate posts. I strongly urge you to read and understand our forum's rules before you post anything else.