ExcelBanter - View Single Post

Byron720

Check your e-mails

"Don Guillett" wrote:

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Byron720" wrote in message
...
Very close. Lets say I have this info on my master database:

Date
Order #
Customer #
Part #
Qty
Tracking #

Lets say my shipping template looks like a sales invoice template (excel).
I
just want to go to my sales invoice, type the date, the cust # and
everything
that was shipped on that date to that customer appears in the body of my
sales invoice (Order #, part #, qty, tracking #, etc)

"Don Guillett" wrote:

Hard to tell without seeing but datafilterautofilter would probably be
of
help.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Byron720" wrote in message
...
I have a big database with, among other things, customer ids, tracking
#s,
parts shipped, etc. I also have a blank shipping template (in excel as
well).
This is what I need to do on the shipping template:

1. Type Date
2. Type Customer ID
3. Excel extracts and pastes all information regarding shipping on that
date
for that customer from my master database into the shipping template.

The template has fields like:
Part # - Qty - Order # - Tracking #

I think it is something like a mail merge