My boss has asked me to automate a file, I have gotten the file to do everything once the data is inside it. Now it is just getting the data there.
The data will be saved in the same format every month like so: L:\Packaging\ANALYSIS\{Year}\{Year Month}\Forecast\[Forecast{Month}.xlsx]
Currently I have a drop down on the first sheet that lets you select the month, then the entire workbook updates calculations based on the new month.
What I was thinking:
Have a macro that finds cells that look up data in that file, then replaces the year and month data with the new data. on several sheets
The data I want to replace is on sheet2 sheet4 sheet7 the data I want to replace it with is on Sheet1 B3.
Also: is it possible to have the macro run every time the drop down box is changed?
Sorry if this is super basic, but I am new to using VBA.
Thank you all,
Robert.
The data will be saved in the same format every month like so: L:\Packaging\ANALYSIS\{Year}\{Year Month}\Forecast\[Forecast{Month}.xlsx]
Currently I have a drop down on the first sheet that lets you select the month, then the entire workbook updates calculations based on the new month.
What I was thinking:
Have a macro that finds cells that look up data in that file, then replaces the year and month data with the new data. on several sheets
The data I want to replace is on sheet2 sheet4 sheet7 the data I want to replace it with is on Sheet1 B3.
Also: is it possible to have the macro run every time the drop down box is changed?
Sorry if this is super basic, but I am new to using VBA.
Thank you all,
Robert.
