I hope someone can help me please. I have two workbooks "Ordering System" and "Retail_Master".
I need a macro within the workbook "Ordering System" that when I run it, it opens up workbook Retail_Master and copies and pastes cell range (A1:I20) from sheet "Chris" into the worksheet "Chris" in the Retail_Master" workbook and then saves and closes the Retail Matser workbook.
If I then run the macro again I need the macro to paste the next set of data on the next line down. I have tried using a number of different sets of code of the internet but with no success, can anyone help me??
Bookmarks