Results 1 to 10 of 10

vba to create proposals

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2015
    Location
    Pennsylvania
    MS-Off Ver
    MS Office 365
    Posts
    85

    Question vba to create proposals

    Good Morning and thanks for reading. This forum has been a tremendous help, when "the google" hasn't. I am new to VBA and self taught with youtube and these forums, so I apologize if my code is sloppy or poorly written. With that being said, I have a workbook that has our bid sheet. I am trying to create the proposal from the bid sheet using VBA. I have it now so that it's almost workable, but have a few questions.

    1. How do I format this code, shP.Cells(k, 4).Value = "Approx. " & shB.Cells(j, 3) & " " & shB.Cells(j, 4) & " @ $" & Round(shB.Cells(j, 11), 2) & " / " & shB.Cells(j, 4)
    to show "Approx. 150 SF @ $500.00/SF" instead of showing "Approx 150 SF @ $500/ SF" *I NEED TO HAVE THE TWO DECIMAL POINTS*

    2. I need to have the "Title Block" which is the 1st 7 rows of the proposal to be on every page that is needed. I have already set up the header to show info, and maybe I could use that, but the formatting in the headers was poor, if I remember correctly.

    3. I'd like to have automatic page breaks when the Disclaimer section goes to a 2nd, or even 3rd page. How can I put the disclaimer section on the last page, and be on the bottom of the page?

    Thanks again in advance

    attached is part of the workbook, I tried to put the code in, but it's telling me its too long
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 10-01-2020, 06:13 AM
  2. Replies: 7
    Last Post: 03-28-2019, 05:19 PM
  3. Price lists and proposals
    By Albarob in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 01-19-2017, 04:23 PM
  4. Macro to find a word in a cell, create a transparent text zone over it, create a hyperlink
    By martin brandl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2015, 03:24 PM
  5. [SOLVED] Help me fix attached code (create Outlook email then create calendar item)
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2013, 08:15 PM
  6. Vba cmd1 create workbook cmd2 create worksheet depend upon combobox values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2013, 03:20 AM
  7. Replies: 3
    Last Post: 11-12-2012, 10:33 AM

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