Newbie! I am looking for a macro to assign to a command button that will copy cells in row A2:A10 in worksheet1 based on a criteria (date) giving in cell A1 , then search worksheet2 (column A) for the criteria (date) giving in (Worksheet1! A1) and paste the cells in (Worksheet1! A2:A10) next to the found date in worksheet2.
I would really appreciate the help.
Bookmarks