JBeaucaire
Forum Guru

Hi JBeaucaire,
Hope you can help me.
Need to find if duplicate values exist in a column A and B, then copy - paste ROW to new sheet.

DATA Sheet1
Column A Column B Column C
Surname Firstname Addresss
Conde Zaldy USA
Conde Janice CHI
Gates Billy PHIL
Conde Zaldy CHI

Results :
DATA Sheet 2
Column A Column B Column C
Surname Firstname Addresss
Conde Zaldy USA
Conde Zaldy CHI


Thanks in advance,
Zaldy

no way, a simple thank you would not do for such awesomeness! i think i might have to use the H word here... HERO

I just wanted to thank you for the help you provided me. Your code worked great. Thanks again. jasono

question, why are you using 2003? why not upgrade to a version more deserving of your mad skills? p.s, super thankful you post on the wknd. thanks for all of your help!

Thank you for your reply, I have Updated Original post and replaced the excel file.

Hi JB,
Thanks alot for yr help.I have encountered one more problem please help me.

Hello JB,
You helped me out with a big project last time and I can see you get a lot of messages asking for help, well I am hoping you can work your wonders again. I have most of the code already prepared thanks to the help of another forum member, but I just need to add to it so that once the end of the month is reached, via a formula that I found that computes the end of the month given a date, it will input 4 rows in between before it starts the next month. If you could help, the link to my post is http://www.excelforum.com/excel-prog...s-reached.html. Thanks

Hello Jerry, can you please revisit my post and see why its not working for me?
http://www.excelforum.com/excel-prog...ml#post2438051
Thank You...
Rick

Jerry
How is it going? You helped me out a while back with an amazing Macro that make my life much easier. You created a Macro that removed and entire order (multiple lines) if that order contained the Part # of my choosing. It has worked amazing, but the other day our company introduced multiple part #'s that contain text and when I type in text it says invalid number. I tried to tweek it slightly but wasn't able to get it to work. Can you help with this. It would have to be able to select text or a number. Here is the link to our original message in forum. http://www.excelforum.com/excel-gene...ng-orders.html -Please help if you can. Thanks again, Kenny

Jerry
I am sorry to bother you, but I really am having a hard time with this and you have experiance with this. I need to copy data from multiple workbooks and paste to one.

I need to create a macro that will go to multiple other spreadsheets (files) and gather certain data (from cells I27, j27, k27) and bring it back to my current spread sheet (and paste to cells c65, d65,e65). For example every day the same spreadsheet is filled out and saved by the date (11-18-10). I need to be able to create a one spreadsheet to copy data from certain cells in each of those sheets and copy them into a yearly spreadsheet with each row as a date and paste into cells c, d, e of that date row.

So there is a workbook for everyday with the same format. I need to copy three cells from each of those workbooks and paste them into one workbook that each row is a day and I need to paste that data into the correct row (date).