Forum Discussion
Is Excel the right program for what I seek to achieve?
Hi,
Assuming I understand what you are after, yes this is quite doable.
What do you do you need to do with the delivery notes when they are filled in? Print? Save as .pdf? Save as a separate Excel file?
Can you post a sanitized/generic version of what you'd be after for the delivery note as well as how your client list with the addresses and such is formatted (Or are you looking to pull that info right out of Outlook? That is a fair bit trickier than if we have an existing list with all of the client info)
I will post a pdf of a note. It's very straightforward on the note. In the main we deliver gaming machines on timed delivery, so it's address, date, client and time.
It's just that our client sends an excel listing with a lot at a time on and we just cut and paste which is slow and laborious.
THis will be tomorrow now.
Keith
If you send us an example of the delivery note, we can arrange a perfectly doable thing.
I imagine a table with the list of the client AND all other info, then another sheet with a good graphic, comments, detail etc and blank cells that auto-fills with the client you're looking for.
It's a VLOOKUP thing, you just have to be patient in setting the blank "mask". Then is a lullaby.
They are printed.
