Hello! I am working with a workbook in excell that I want to use to transfer info onto another sheet. I want to write a macro that will look at a cell in sheet 1 then compare it to the cells in sheet 2. If the value in sheet 1 matches the value in sheet 2 then I want excell to transfer that info from the selected cell on sheet one into the matching cell on sheet 2.
Example
transfer from Sheet 1: record no 1
to
sheet 2 : record no 1
there are alot of record numbers and I only want the row to be transfered if the record no matches from sheet 1 to sheet 2.
I hope I have not made that top confusing. Help please?
Thanks
Colleen
Bookmarks