Hi all,
I'm working on a Macro that would be doing the following steps:
1. Select a range of data in an open Excel sheet and copy it (Columns A till C should be fixed. The rows should be dynamic and search for the last one filled)
2. Open a closed workbook in a fixed folder
3. Paste the copied data to that workbook
4. Close the workbook
I have already a macro to select and copy a dynamic range of data and paste it into a new workbook. Can anyone please help me modify the code or give me a direction on how to solve my Macro?
Thank You
Bookmarks