Hi forum,
I have hit a wall creating this macro...
I need a macro that will read the number in cell T1, then copy the value in cell G3 (either "Y" or "N"), and paste it below G3, T1 amount of times.
For example,
T1 = 5
G3 = "Y"
Macro will copy the "Y" in G3 and paste it 5 times, filling range G4:G8.
This will mean range G3:G8 all show "Y".
Seems like this should be fairly simple but I have struggled to develop a clean solution. Any help is appreciated.
Thanks.
Bookmarks