Hey there! I'm working on an excel program that's powered almost exclusively with buttons. That's pretty simple and I understand how to work with those, but there's one in particular that's perplexing me. I think it's possible, but it may not be. I'm guessing I'll need macros to edit my macros.
Here's the idea -
Once you press the button, data gets transferred from the sheet "M1" to the sheet "Master". The transferred data follows:
(M1 to Master)
E4 to H3
E7 to I3
E10 to J3
E15 to K3
E17 to L3
E21 to M3
E24 to Q3
E27 to O3
E30 to P3
E37 to N3
I4 to H4
I7 to I4
I10 to J4
I15 to K4
I17 to L4
I21 to M4
I24 to Q4
I27 to O4
I30 to P4
I37 to N4
M4 to H5
M7 to I5
M10 to J5
M15 to K5
M17 to L5
M21 to M5
M24 to Q5
M27 to O5
M30 to P5
M37 to N5
S4 to H6
S7 to I6
S10 to J6
S15 to K6
S17 to L6
S21 to M6
S24 to Q6
S27 to O6
S30 to P6
S37 to N6
W4 to H7
W7 to I7
W10 to J7
W15 to K7
W17 to L7
W21 to M7
W24 to Q7
W27 to O7
W30 to P7
W37 to N7
AA4 to H8
AA7 to I8
AA10 to J8
AA15 to K8
AA17 to L8
AA21 to M8
AA24 to Q8
AA27 to O8
AA30 to P8
AA37 to N8
As you can see, it follows a definite pattern. However, that's not all:
The first time I press the button, I want the data to transfer to those cells. However, for each time after that, I want it to transfer six rows down.
For example, AA4 to 8H would turn in to "AA4 to H14", then to "AA4 to H20", and so on.
My end goal is for this work 70 or so times, so that would be to row 423.
Any ideas?
Thanks!
Bookmarks