I have 15-16 sheets.. AND I ENTER data in sheet1 & sheet2 .. i want excel to copy data from sheet1 / sheet2 to sheet3 or anyother sheet based on condition .. i am keeping column b as code .. if code is entered in column B in sheet3 or anyother sheet then excel should search the same code from sheet1 / sheet2 to match and copy the row and paste in different coloumns that i want in sheet3 or anyother sheet ...it should search for the same coloumn name and copy the data and paste to sheet3 in the same coloumn .. first it should search for the code and then the coloumn and paste the data of the row.
sheet1 has
DATE CODE NAME EXCEL WORD ACCESS
22-11-2014 1 EXCEL 9
22-11-2014 3 WORD 5
22-11-2014 66 ACCESS 2
other sheets i want to copy based on code and then coloumn
sheet3 has
DATE
CODE
NAME WORD
sheet 4 has
DATE CODE NAME EXCEL
sheet5 has
DATE CODE NAME ACCESS
please if anyone can help me fast.. would be of great help.
thank you.
and yes , i am using excel 2007
sheet1 has
DATE CODE NAME EXCEL WORD ACCESS
22-11-2014 1 EXCEL 9
22-11-2014 3 WORD 5
22-11-2014 66 ACCESS 2
other sheets i want to copy based on code and then coloumn
sheet3 has
DATE
CODE
NAME WORD
sheet 4 has
DATE CODE NAME EXCEL
sheet5 has
DATE CODE NAME ACCESS
please if anyone can help me fast.. would be of great help.
thank you.
and yes , i am using excel 2007