parscon
07-01-2012, 02:55 PM
Dear firends ,
I have 14 workbooks and each workbook have some sheets . now i need a VBA code that when i search number , can search all workbooks with their sheets and if found any data , copy the row of them to new workbook .
for example : i have 11123542 number in 8 workbook when i search , copy all of them (the row ) that founds to workbook new .
just column A is same but other column are diffrent .
Thank you .
I have 14 workbooks and each workbook have some sheets . now i need a VBA code that when i search number , can search all workbooks with their sheets and if found any data , copy the row of them to new workbook .
for example : i have 11123542 number in 8 workbook when i search , copy all of them (the row ) that founds to workbook new .
just column A is same but other column are diffrent .
Thank you .