Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have designed a template for cost sheets, quotations, orders etc that is
all linked in one file. One tab in the file contains the clients address. Every time I do a new quotation this must be filled in. the file is then 'saved as...' something rather than overwrite my template. Is there a way to create a seperate file that would automatically add this address to build up a database? Please Note I have no idea how to use macro etc. I just use formulae. Eg. Adress Tab: A B C D E 16 For the attention of:- (cell is merged horizontally) 17 Ste Jones 18 1 Wood Street 19 Durham 20 County Durham 21 DH1 1AA This must then add on to a database in the same fashion. Next time I do a quote the next clients address is inserted below this one, with maybe a line to seperate them. I would appreciate any help. Regards, Jonathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Separate address column to Five columns | Excel Worksheet Functions | |||
Links to External Database | Excel Discussion (Misc queries) | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
How do i export a Excel database a Outlook address book? | Excel Discussion (Misc queries) |