Thread
:
Automatic Copy and Paste
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Automatic Copy and Paste
Answered with a worksheet_change event to call an autofiltercopy paste
macro.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Byron720" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett