I have a big old spreadsheet that i have that is one big old bit of data with lots of cells.
These cells then get split by country and then customer name, then this auto exports into lots of seperate spreadsheets that i can email to the relevant people. This is great, but when it exports, it doesnt keep the cell widths in the new sheet. Is there something i can add to my macro that will keep the format of the cell width in the new sheets it auto creates?
this is my current code:
Also, if someone knows how to make it so that the sheet doesnt have to be called sales, as it is just a one tab spreadsheet anyway, and it doesnt matter what it is called thereby replacing or removing the
3rd line completely from the macro, i would be really grateful.
thanks,
(but the main thing is to get the cell width/ format to carry over)
Bookmarks