Hello fellow Excelers -
I am looking for a place to get started with my code.....I have a workbook ("Workbook 1") that has data that I need to move to another workbook. Workbook 1 has a date in Cell E3 with names in Column B and the data that needs to be moved in Column E.
I have another sheet "Workbook 2" that has dates in row 2 starting in column B and Names (the same names as workbook 1) in column A. I want to move the data from workbook 1 column E to workbook 2 in the column that has the date match with Cell E3 from Workbook 1 and the data should be put in the row that has a name match in column A with Column B from Workbook 1.
I am learning VBA, and this code will help me get started for what I am looking to do. Please let me know if I can clarify anything.
Thanks for all help.....
I am looking for a place to get started with my code.....I have a workbook ("Workbook 1") that has data that I need to move to another workbook. Workbook 1 has a date in Cell E3 with names in Column B and the data that needs to be moved in Column E.
I have another sheet "Workbook 2" that has dates in row 2 starting in column B and Names (the same names as workbook 1) in column A. I want to move the data from workbook 1 column E to workbook 2 in the column that has the date match with Cell E3 from Workbook 1 and the data should be put in the row that has a name match in column A with Column B from Workbook 1.
I am learning VBA, and this code will help me get started for what I am looking to do. Please let me know if I can clarify anything.
Thanks for all help.....