Transfer duplicate information between files

[ash1130]

I have two Excel files with duplicate information needed in each. So I don't have to manually copy and paste each cell that needs to get transferred to the other (there are hundreds and they are not always in the same cell), is there a formula or macro that I can run to do this for me? For instance, I need what is located in cells D5, D9, D24, D41, etc. in File 1 to get transferred to cells D7, D14, D31, D59, etc., in File 2.

[ExcelHelper2]

If your data has one specific identifier, you could just use the function VLOOKUP. VLOOKUP(key,area,column number, match type) searches a key from a specific area. For more information please see the documentation or the link. I hope this works for your case. One can also write a macro, but I think this would be an easier solution for you.
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[ash1130]

Thank you for getting back to me. Unfortunately, it is not working. I am typing in the formula as =VLOOKUP(F3, WEEKONE!A3:H41, 7, FALSE). F3 is the value from the 'WEEKTWO' spreadsheet that I want looked up; 'WEEKONE!A3:H41' is the spreadsheet and cells that I want checked for said value, 7 is the column number that I want transferred to the cell in which I am typing the formula. Do you have any suggestions or know why it is not working? When I hit enter, '#N/A' is in the cell in which the formula was typed.

[ExcelHelper2]

I would bet that the searched value is not be found in the first column of the area. The weakest point of the function in my opinion is that the searched value needs to be found in the first column of the area. Try to change your area that this is the case. The '#N/A' means that no match was found.
The function needs an unique value for the search, if there are more matching values the function just stops on the first matching row. If the comparison needs more logic, then a macro is needed.

[ash1130]

Thank you so much for your help. I ended up changing the search value to a smaller range and changed the column number accordingly. It worked this time. You have saved me a lot of time!