Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Marietta, Georgia, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Formatting (Excel 2003)

    What is the best way way to set up a template with predetermined formatting that will pull data from a spreadsheet?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Formatting (Excel 2003)

    Can you be more specific about what you want to do?
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Jul 2004
    Location
    Marietta, Georgia, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Formatting (Excel 2003)

    See attached. The tab entitled "Mylar" is information that is dumped from Microsoft Access. I am taking this information and formatting it to look like what is on the "Format" tab. I'm wondering if there is a way to be able to make the formatted information "fill" in to the template called on the "Format" tab.
    Any help would be appreciated.
    I'm not very familiar with VBA and wonder if this would be the way to go, or if there would be a simpler way to set up formulas in the "Format" tab to pull information from the various fields on the "Mylar" tab.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatic Formatting (Excel 2003)

    Why aren't the project numbers listed in numeric or alphabetic order in the first row of the Format sheet?
    Why is Jan-07 listed below Jul-07 to Dec-07?
    Why do not all project numbers from the Mylar sheet occur on the Format sheet?
    Why does the number of rows per month vary, with some months having empty rows?
    Why are some entries in the narrow columns highlighted in green and others not?
    Why are some entries highlighted in yellow?
    Why do some entries have a dotted red border?
    Why is the text in D2 italic?

  5. #5
    New Lounger
    Join Date
    Jul 2004
    Location
    Marietta, Georgia, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Formatting (Excel 2003)

    1. They can be listed in numerical order on the format sheet; however, they correlate to a community name and the community names would be entered in alphabetical order.
    2. Should be January '08 (my bad).
    3. I manually formatted this sheet to use an example and did not transfer all information from one sheet to the other.
    4. Again, this is manually formatted and the number of rows correlate to the number of deliveries for the specific month for the specific community.
    5. The columns highlighted in green are done so to delineate them as "houses under construction."
    6. The fields highlighted in yellow have a different meaning "Pending CAN."
    7. Dotted red border pertains to buyers who have a contingency property.
    8. Italicized names indicate lots that have closed.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatic Formatting (Excel 2003)

    Since we don't know the community names and the number of deliveries per community, I don't see how we could automate transferring the data.
    Same goes for the specific formatting such as colors and borders.

Posting Permissions

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