Hi All, I just got myself a wide format printer/cutter and would like a Excel document to quote on Jobs Not being all that great with excel and its formulas, I thought I would ask if anyone would mind sharing their excel skills with me. Constructing a excel sheet would take me forever Basically I would like the functionality this website offers in a excel Sheet or something similar http://www.dgtal.com/quote_request_large_format.html Can anyone please help Thankyou & Regards SnaZZZ
Most of us acquired our Excel skills by doing, not having it done for us. The site you point to is nothing more than some cell, row and column formatting along with "select from" cells. The selection cells can be created using Data Validation dropdown lists. Debra Dalgleish has much info and instruction on DV lists. http://www.contextures.on.ca/xlDataVal01.html The large comment box at the bottom could be replicated by using a TextBox from the Forms Toolbar. The Send Request button would have VBA code attached to send an email. For help on the email part see Ron de Bruin's site. http://www.rondebruin.nl/sendmail.htm Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 10:38:26 GMT, "SnaZZZ" <Snazytec(remove_me)@hotmail.com> wrote: >Hi All, >I just got myself a wide format printer/cutter and would like a Excel >document to quote on Jobs >Not being all that great with excel and its formulas, I thought I would ask >if anyone would mind sharing their excel skills with me. >Constructing a excel sheet would take me forever >Basically I would like the functionality this website offers in a excel >Sheet or something similar >http://www.dgtal.com/quote_request_large_format.html >Can anyone please help > >Thankyou & Regards > >SnaZZZ