ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 958
- Office Version
- 365
- 2010
- Platform
- Windows
Hello everyone,
This has probably been asked here many times.
I have 1 workbook that contains worksheets for each day of the month of July 2020
I have another worksheet 'sheet1" that I use a macro to transfer data from the dated (July) worksheets.
The macro works like this:
"sheet1" has an area where I copy and paste to a cell range. Before it copies the data from a selected month worksheet the macro goes to the worksheet and runs additional macros to calculate data. Once the calculations are completed the macro copies the data back to the "sheet1" worksheet.
Everything works great except 1 thing. I tried entering the 2 lines of code in the proper place:
Application.ScreenUpdating = False
Application.ScreenUpdating = True
Unfortunately the 2 lines of code will not keep all the calculations on the "sheet1" worksheet. Meaning the macro runs, it goes to the Jul222020 worksheet then goes back to the "sheet1" worksheet. Then back and forth until macro completes all the calculations.
Any help would be greatly appreciated.
Thank you.
This has probably been asked here many times.
I have 1 workbook that contains worksheets for each day of the month of July 2020
I have another worksheet 'sheet1" that I use a macro to transfer data from the dated (July) worksheets.
The macro works like this:
"sheet1" has an area where I copy and paste to a cell range. Before it copies the data from a selected month worksheet the macro goes to the worksheet and runs additional macros to calculate data. Once the calculations are completed the macro copies the data back to the "sheet1" worksheet.
Everything works great except 1 thing. I tried entering the 2 lines of code in the proper place:
Application.ScreenUpdating = False
Application.ScreenUpdating = True
Unfortunately the 2 lines of code will not keep all the calculations on the "sheet1" worksheet. Meaning the macro runs, it goes to the Jul222020 worksheet then goes back to the "sheet1" worksheet. Then back and forth until macro completes all the calculations.
Any help would be greatly appreciated.
Thank you.