Hi all, I am in need of some assistance with VBA
I am trying to :
1. On a workbook sheet 'Data', I am trying to import a specific sheet (Sheet1) from an existing file C:\Test.xlsx only.
2. Overwriting the existing entries from 'Data' (if any)
What is the best way to approach this? .. could any one share a light-weight vba macro that can achieve this?
Would clearing 'Data' first before importing be one of the solution?
I am trying to :
1. On a workbook sheet 'Data', I am trying to import a specific sheet (Sheet1) from an existing file C:\Test.xlsx only.
2. Overwriting the existing entries from 'Data' (if any)
What is the best way to approach this? .. could any one share a light-weight vba macro that can achieve this?
Would clearing 'Data' first before importing be one of the solution?