PDA

View Full Version : how to search,compare and copy between sheets?



goldesign
02-26-2012, 03:19 AM
compare and complete from sheet1 to sheet2

in sheet1 i have :
column A: name
column B: surename
column C: unique number

in sheet2 i have:
column A: unique number (similar or not to sheet1 column C)
column B: a text
column C: another text

i want a button in sheet1 or sheet2 to search and compare in sheet2 by unique number and add in sheet2 after columns A,B,C data from sheet1 columns A nad B, after this the sheet2 will look like:
column A: unique number (similar or not to sheet1 column C present in both sheet's)
column B: a text
column C: another text
column D: name (from sheet1)
column E: surename (from sheet1)

The search and compare and copy condition between sheets can be interogated by document open, or a button, any one can hellp me, i put a sample attached. Excel 2007 with macro or without.

Edited:
i try to get this solution work but dont work:


vbaexpress.com/forum/showthread.php?t=22080

mdmackillop
02-26-2012, 12:11 PM
Why not post a proper sample with suitable data and a desired result?