i am trying to import data from one excel sheet to another based on the date. One of the files is dynamic and changes/overwritten daily, therefore the date changes and the values are replaced. The problem i am having is keeping the data in the target spreadsheet once the date changes. Everything i try gives me a circular reference. I am opening the files and updating using a batch file so enabling the iterative calculation in the options wont cure it. Below is a sample of the calculation i am using in one once of the cells: =IF(A19='daily exports30.csv'!$C$5,'daily exports30.csv'!$B$49,AY19). AY19 looks at the cell with the calculation in to ensure its saved when the date changes. I have no experience with macros or VB so im struggling. can you help????
Solved by V. D. in 21 mins