FInd and Paste
Posted on 2011-09-25
Trying to build a macro in workbook "Overall" thta will do the following.
1. Open workbook "Data1", which is located in C:/user1/Data.xlsx
2. Copy the data in sheet "In-Outbound" from the range of A2:E to where the value of CALL is located in Column A For example if the word CALL is in A 18, then copy A2:E18.
3. Paste that value in workbook Overall.Sheet "In-Outbound" on the next empty row after the cell that contains Outbound. For example if the work Outbound is in cell A1, then paste in cell A2.