I have a previous macro that autopopulates based off of a data validation list selection. What I would like to happen is when I make a selection in the Training Plan sheet, cell N172, the macro would clear the contents of Training Plan A171:B182. Then go to the templates page, search in the first row for the same text that was selected in Training Plan N172. When it finds it, select the 12 cells below it and the 12 cells to the right of those cells, and copy and pastes it to Training Plan A171:B182.
For example, if "Another Name" was selected in Training Plan N172, the macro would find "Another Name" in Templates E1 and then copy and paste Templates E2:F13 into Training Plan A171:B182.
I have used the term copy and paste, however it would be great if it didn't actually utilize the clipboard as occasionally I get errors with macros that do use the clipboard.
I can not use set ranges to copy and paste from on the Templates sheet. Right now there are 3, but there will be more added as time goes on and I don't want to have to rework the macro every time one is added.
I will have to expand this out to work based off of Training Plan N172:N183. I am not asking someone to write the whole thing, but I may have questions on how to expand it out.
Thanks in advance. I hope the tone of my post doesn't sound demanding.
Bookmarks