Removing Screen flicker and adding efficiency to Copy Paste Macro
Hello smart excel users,
I have a macro that I’ve made that pulls data from other reports. I typically get to use .range = .value2 because I use table 99% of the time, however, in the case of my stand alone reports I cannot use tables and I have to use merged cells. because of this, I have not been able to come up with a good macro that removes the need to copy and paste data a bunch of times between workbooks and it causes the screen to flicker like crazy when going back and forth between the two workbooks (disabling screen updating will not work as its two separate windows) and unfortunately I need a bunch of copy pastes instead of just one due to the limitations revolving around copy paste of merged cells and paste area size differences…..
I’m sure there’s a way to get all the data that I require to be pulled over without the extensive back and forth but I have not found a solution yet.
I have attached two sample workbooks. The one which is TEST REPORT has a button that can be clicked. It prompts you to select the source data that I have also attached and should pull the data from the source report.
Please let me know If you have any ideas on how it could run smoother and potentially remove the horrendous screen flickers.
Hello smart excel users, I have a macro that I’ve made that pulls data from other reports. I typically get to use .range = .value2 because I use table 99% of the time, however, in the case of my stand alone reports I cannot use tables and I have to use merged cells. because of this, I have not been able to come up with a good macro that removes the need to copy and paste data a bunch of times between workbooks and it causes the screen to flicker like crazy when going back and forth between the two workbooks (disabling screen updating will not work as its two separate windows) and unfortunately I need a bunch of copy pastes instead of just one due to the limitations revolving around copy paste of merged cells and paste area size differences….. I’m sure there’s a way to get all the data that I require to be pulled over without the extensive back and forth but I have not found a solution yet. I have attached two sample workbooks. The one which is TEST REPORT has a button that can be clicked. It prompts you to select the source data that I have also attached and should pull the data from the source report. Please let me know If you have any ideas on how it could run smoother and potentially remove the horrendous screen flickers. Read More