Forum Discussion
Is Excel the right program for what I seek to achieve?
Imagine, an excel listing of client names and addresses and the sort of information you'd find on a delivery note. Say you've got fifty different sets of info for 50 delivery notes. Imagine a del...
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.