Hello,
Does anyone know of a macro that will copy from 'Random Stats'! and paste to the 2015, 2016, 2017, or 2018 Stats sheets with these ranges:
B6:E105
I6:J105
L6:M105
O6:P105
R6:S105
U6:Y105
Thank you very much for your help,
XJ
Hello,
Does anyone know of a macro that will copy from 'Random Stats'! and paste to the 2015, 2016, 2017, or 2018 Stats sheets with these ranges:
B6:E105
I6:J105
L6:M105
O6:P105
R6:S105
U6:Y105
Thank you very much for your help,
XJ
Since the yellow columns with formulae are consistent with the formulae on the Random Stats sheet whi not just copy the whole of B6:AA105) and paste to B6 on all the four annual sheets?
Why do you need to copy those particular columns disjointed columns?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
I want to avoid the random parts so the data will be fixed in the 2015-2018 sheets.
Last edited by xjohnson; 12-10-2018 at 05:15 PM.
Hi
Try this macro
Please Login or Register to view this content.
Thank you Richard but I don't want the formulas to paste just the values please.
Is it possible?
Perhaps there needs to one macro specific to each year sheet?
Change to
Please Login or Register to view this content.
Thank you that works!. One more small request please. It is leaving the columns U to V on the Random Stats sheet in copy mode. Can that be corrected?
I will be back in 45 minutes thank you,
XJ
Yes just conclude the macro with
It will speed up if you also make the first linePlease Login or Register to view this content.
and the last linePlease Login or Register to view this content.
Please Login or Register to view this content.
I thank you so much for your help. The year sheets remain in paste mode on the U to Y columns now but it's okay I guess.
Please Login or Register to view this content.
My pleasure and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks