Create simple excel vba for importing data from another sheet.
Budget: $10 – $25 USD
Objective: copy paste data from two files in a folder to a destination excel file
Open Excel file from a folder if the file name contains a particular 'text'.
The 'folder path' and 'text' for above will be mentioned in a sheet in the destination file.
Copy paste contents in a range from source file to destination excel file.
Count the number of cells in the range with numbers (=XX)
Write to a cell ... 'Processed File A and imported XX records'
If file A is not found, write to cell 'File A not found' and exit macro
Repeat above steps for file B.
Open Excel file from a folder if the file name contains a particular 'text'.
The 'folder path' and 'text' for above will be mentioned in a sheet in the destination file.
Copy paste contents in a range from source file to destination excel file.
Count the number of cells in the range with numbers (=XX)
Write to a cell ... 'Processed File A and imported XX records'
If file A is not found, write to cell 'File A not found' and exit macro
Repeat above steps for file B.