Currently I am able to successfully copy the data from a closed workbook and paste into a specified sheet in my open workbook. However, I am having to give the exact range of cells to copy which will become an issue eventually. I need to select all cells that have data in them from cells A4 and beyond in the closed workbook and paste as a table into a specified sheet in my open workbook. Again, I need to have the capability to select, copy a dynamic range beginning from cell A4. Below is my existing code.
Bookmarks