Hello! I am somewhat experienced with excel macros and basic computer programming. In column A I have data that is labelled "A2 - NS", "A2 - 19", "A2 - 21", "B2 - NS", "B2 - 19", "B2 - 21", "C2 - NS"... Continuing down the column to "H2 - 21". I now want to copy all these rows and paste them below these rows, but with the new values being "A3 - NS," A3 - 19..... (note that I only want the 2 to become a 3 without changing the rest of the string... for EACH row)
I cannot for the life of me figure out how to write a macro that can help me, but I imagine it is quite simple. Understanding how to write this macro will help me quickly make sheets for future data sets
Thanks,
Steve
Bookmarks