ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto - reformatting (https://www.excelbanter.com/excel-discussion-misc-queries/119481-auto-reformatting.html)

Paul-K

Auto - reformatting
 
I am using Zoomerange to do customer surveys.

There results are downloadable in a excel sheet, but the column widths are
too wide as the answers are a rating of 1-5, comments (text) are not wrapped
so the cell extends too wide, and I want to deletete a couple columns.

I download the survey results every week and want to know if there is a way
to automate the process of formating the work sheet.

Don Guillett

Auto - reformatting
 
record a macro while doing it. You may need to clean it up a bit afterwards.

--
Don Guillett
SalesAid Software

"Paul-K" wrote in message
...
I am using Zoomerange to do customer surveys.

There results are downloadable in a excel sheet, but the column widths are
too wide as the answers are a rating of 1-5, comments (text) are not
wrapped
so the cell extends too wide, and I want to deletete a couple columns.

I download the survey results every week and want to know if there is a
way
to automate the process of formating the work sheet.





All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com