Advice for auto-formatting large spreadsheet

Please forgive my ignorance.... I am working with a 14,000 row spreadsheet that has to be formatted just perfectly to print the way we need it to. It is a list of products and prices from a vendor.

Once a month, I get a new spreadsheet from our vendor with the formatting all out of whack again. My challenge is that I need to update the numbers in my spreadsheet and keep the formatting perfect for printing, and would love any shortcut on accomplishing this.

In other words, right now, Spreadsheet A has all products and pricing and is fit to print in a very particular manner. Soon, vendor will send me Spreadsheet B, all contents of which needs to go back into Spreadsheet A so it'll be fit to print again. Formatting Spreadsheet B every month would take hours and hours. I'd love a way to get the data from B into my perfectly formatted A.

Any ideas for me?

Welcome to the forum. You probably need to amend your thread title to ward off the moderators.

Something like "Advice on formatting large spreadsheet", perhaps.

You could, maybe, copy and paste special | formats from sheet A to sheet B.

Or you could record a macro whilst you format the new sheet to meet your requirements. Ir will probably need some tweaking for generality and efficiency.

If you post some before and after sample workbooks, I'm sure someone could offer a VBA solution.


Regards

OK, give me a little time and I'll draft a VBA macro for you.

May take a little while, so don't fret ;-)

Regards

See the sample attached.

I think I've picked up on most, if not all, of the formatting requirements.

If not, record a macro while you do the formatting and incorporate the code into the macro provided. If you hit any problems, let me know.

Regards

Please Login or Register  to view this content.

You're very welcome.

If this has answered your question, please mark your thread as solved. See my signature for details or the FAQ.

Regards