Forum Discussion
Copying column widths and row heights from one sheet to another
Hello everyone. I have to reformat a rubbish PDF i get sent everyday so i can make it legible. i have arranged the cell widths and heights and cut and pasted the data but there are 14 columns and as many as 30 rows. I have this information on PDF everyday. Is there a way i can automate this so my sheets are all the same looking?
2 Replies
HelloCoxyTJW,
Yes. You do not need to manually resize columns and rows each day. The simplest solution is to create one sheet formatted exactly as required with the correct column widths and row heights, then copy that sheet each day and paste your new data into it so the layout remains consistent. Alternatively, save the formatted workbook as an Excel template (.xltx) and use it daily. If you prefer automation, you can use a short VBA macro to copy column widths and formats from a template sheet to your working sheet. Keeping one clean template sheet and reusing it daily is the most efficient and maintainable approach.
Have you tried Data, Get Data, From File, From PDF?
