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
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