Kramer,

Don't do it that way: it's a poor design, one that increases your chance of
introducing errors. Use one workbook, and one database, and use data
filters or pivot tables to view summaries or subsets of your data.

You can add additional columns to your database to use as filter keys. When
you want to see a specific view of your data, filter on the key, or other
parameters, such as the 'matching dates' or the column that would match the
value in cell H1. Or use the pivot table to create the summary.

HTH,
Bernie
MS Excel MVP


"KRAMER" wrote in message
...
Hi Guy's,
I have created an intergrated system of tracking for my company. Basically
I
have one Workbook for Daily Sales and another as a Master Record. I want
to
be able to input information into the Master Worksheet and automatically
transfer some of the information to the Daily Worksheet. Columns
A,B,H,J,K,P,Q,T,G on Master are to be transferred to Columns
A,B,C,D,E,I,K,F,L respectively on a daily basis according to matching
dates
in Column S of the Master and Cell H1 of the Daily sheet. An added problem
is
that cell information can regularly be the same and there can be up to 20
different transactions per day.
--
KRAMER