I am trying to figure out a way to drag cell ranges, and have Excel recognize the pattern of the range. I have several thousand ranges I need to edit, and manualy copying new ranges becomes extremely time consuming. The ranges will reflect cells in the pattern A2:A3, A4:A5, A6:A7, etc. When I...