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