Sheets/Workbook Not Calculating after Macro run
So Sheets 2 through 19 have pasted data from an external source, which I then created a Summary sheet for with references to the cells I want to show data from.
I then created an English and French tab because my first paste into Sheets 2 through 19 is with English data, then I paste again with French data (both from external sources).
On both the English & French tabs, the data for the last 2 weeks needs to be updated so I need to pull data from Row 21 on the Summary tab into certain cells in Column H and I respectively. For instance Summary!D21 needs to be entered into English!H3, Summary!D22 into English!H4, etc etc. You can see Macro "EngAbsV2" for what goes where. I also created macro "FrAbsV2" because I need to do the exact same steps on the French sheet.
My problem is that when I run "EngAbsV2", the formulas gets entered but nothing shows up because the sheet/workbook doesn't want to recalculate. So when I go back and look at the Summary sheet, it also shows blanks, seemingly "Uncalculating" itself.
I've also tried creating a macro where a cell value from English equals the cell value from Summary but it also shows up blank until I hit F9 because Summary shows blanks even though 2 minutes ago I saw data. Ideally this is the best solution because I don't want it referencing the formula, I want it referencing the value that is there at the moment. That value will then change once I go from English data to French data and I don't want English and French referencing the same data.
I've even gone to the macro recorder and recorded pressing F9 yet that doesn't work either. It only works if I physically press F9 or press the Calculate Now button on Excel.
Does anyone have any solutions?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By fakhteh in forum Excel Formulas & Functions
Last Post: 09-24-2016, 08:05 AM
By sudric in forum Excel Programming / VBA / Macros
Last Post: 02-18-2015, 11:53 AM
By cgsweger in forum Excel Formulas & Functions
Last Post: 01-17-2014, 04:26 PM
By KeithMale in forum Excel Programming / VBA / Macros
Last Post: 06-13-2013, 05:37 PM
By synergio in forum Excel Programming / VBA / Macros
Last Post: 12-28-2012, 06:20 AM
By firstname.lastname@example.org in forum Excel Programming / VBA / Macros
Last Post: 10-10-2012, 08:56 AM
By StargateFanFromWork in forum Excel Programming / VBA / Macros
Last Post: 01-26-2006, 02:35 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1