+ Reply to Thread
Results 1 to 7 of 7

Advice for auto-formatting large spreadsheet

  1. #1
    Registered User
    Join Date
    10-11-2011
    Location
    Kansas City, Missouri
    MS-Off Ver
    Excel 2007
    Posts
    3

    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?
    Last edited by sgordon25; 10-26-2011 at 03:41 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Help with 14,000 row spreadsheet

    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
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    10-11-2011
    Location
    Kansas City, Missouri
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Advice for auto-formatting large spreadsheet

    Thanks for your reply. Attached are 2 small examples of what I'm trying to describe. Thanks!
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Advice for auto-formatting large spreadsheet

    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

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Advice for auto-formatting large spreadsheet

    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.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-11-2011
    Location
    Kansas City, Missouri
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Advice for auto-formatting large spreadsheet

    Thank you VERY much for your time on this!

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Advice for auto-formatting large spreadsheet

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1