cdtouchberry
02-03-2019, 02:44 PM
I have data in a saved desktop folder: C:\Users\NAME\Desktop\QuickFS\Data.xlsx
The "Data" file has 5 worksheets (Overview, Income Statement, Balance Sheet, Cash Flow Statement,Ratios), which I would like to copy into my active workbook (named"Data_Analysis"). My active workbook is located at: C:\Users\Name\Desktop\Data_Anlaysis.xlsx
"Data_Analysis" will be open at the time of the import, while the "Data" file will be closed. The "Data_Analysis" file has many worksheets, including 5 worksheets named identically to those found in the "Data" file(Overview, Income Statement, Balance Sheet, Cash Flow Statement, Ratios). When the data in the "Data" file changes, I would like to run the VBA and import the new data into the correct worksheets and overwrite the previous data. Because I have formulas in the "Data_Analysis" file linking to the 5 worksheets (Overview, Income Statement, Balance Sheet, Cash Flow Statement, Ratios), these sheets can't be created as new, and they must overwrite on the appropriate sheets in the "Data Analysis"workbook.
Thanks in advanced for your help.
CDT
The "Data" file has 5 worksheets (Overview, Income Statement, Balance Sheet, Cash Flow Statement,Ratios), which I would like to copy into my active workbook (named"Data_Analysis"). My active workbook is located at: C:\Users\Name\Desktop\Data_Anlaysis.xlsx
"Data_Analysis" will be open at the time of the import, while the "Data" file will be closed. The "Data_Analysis" file has many worksheets, including 5 worksheets named identically to those found in the "Data" file(Overview, Income Statement, Balance Sheet, Cash Flow Statement, Ratios). When the data in the "Data" file changes, I would like to run the VBA and import the new data into the correct worksheets and overwrite the previous data. Because I have formulas in the "Data_Analysis" file linking to the 5 worksheets (Overview, Income Statement, Balance Sheet, Cash Flow Statement, Ratios), these sheets can't be created as new, and they must overwrite on the appropriate sheets in the "Data Analysis"workbook.
Thanks in advanced for your help.
CDT