I am editing an excel that contains many sheet names, sheet names are in month year format ex:June 2020, July 2020, August 2020 etc
My requirement is to create a new sheet then copy the data from last sheet and paste it there, new sheet name should be the next month and year after the last sheet. Ex: if the current last sheet is called “August 2020”, Copy that sheet , create new sheet and name it “September 2020” and paste everything that is copied from “August 2020” to “September 2020” just like if we would have done it manualy using windows copy paste.
Issues i am having
My code/setup works as far as creating a new sheet and copying data but
The new sheet is not creating at the end thus becoming the new last sheet , So with our example, after the code runs , “September 2020” should be the last sheet, but its created as the second last, see image:
The data that was copied are all there on the new sheet including highlight colors but the spacing is wrong, on the new sheet all data is shrunk, this wont happen when we do copy paste using windows copy paste method: see image below
thanks for the help in advance
Here is a sample test file:test.xaml (8.4 KB)