ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I build a Construction Schedule of Values in Excel? (https://www.excelbanter.com/excel-worksheet-functions/122039-how-do-i-build-construction-schedule-values-excel.html)

Caleb Howze

How do I build a Construction Schedule of Values in Excel?
 
I need to create a simple Excel Spreadsheet that can be used as a
Construction Schedule of Values. Then in the same Excel document I need to
have the data from the schedule of values transfer over to a standard
Construction Invoice.

Martin Fishlock

How do I build a Construction Schedule of Values in Excel?
 
Caleb:

1. Make an entry form with the columns for the information for entry
2. Link the data on to the invoice. This may be with VBA macros of links to
the original form
3. Develop a mechanium for recording invoice numbers etc.
4. Test it and get user acceptance.

Have fun with your little project.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Caleb Howze" wrote:

I need to create a simple Excel Spreadsheet that can be used as a
Construction Schedule of Values. Then in the same Excel document I need to
have the data from the schedule of values transfer over to a standard
Construction Invoice.



All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com