Are the data 'normalized' or can the data be 'normalized', meaning
it's way better if for each record there is only one row, i.e., you
would have columns:
Consignee
Address
G.O.#
Date of Arrival
Date of Entry into G.O.
Disposition (sold,entry#)
Description of Goods
Disposition Date

What i couldn't figure if the data are already like that or there
would be actually multiple rows for as if 'the same entry'.
What you're asking for can easily be done with a VBA or maybe even
with a formula but before I could help you out i need to understand if
the data are 'normalized' or can be 'normalized' without ruining
something else that you do with those.
Post back and will proceed from there.


On Jul 17, 5:26*pm, Nycki wrote:
Ok I'll try to keep this simple, I think I was complicating it more before. *
I put multiple entries comprised of the below info on one worksheet, each is
unique, the consignee will be different in A2 than A6, GO# in C1 will be
different than C5 and so on. *Some of this information needs to be loaded
into another worksheet that is a letter. *I cannot figure out how to do this
without doing and = for each sheet to the other. *The letter does not have to
be a worksheet for each entry but the master worksheet has to have all
entries.

CONSIGNEE, ADDRESS * *G.O. # * *2009-XXX-J632-0002 * * *Date of Arrival 01/03/09
abc * * * * * * * * * * * * AWB / BOL 123-22248888 * * *Date of Entry into G.O.02/12/09
123 main street * * QTY 690 Cartons * * Disposition * (sold,entry#)
city, state, zip * * * * * *Description of Goods Quilts Disposition *Date * * *

"AB" wrote:
Maybe provide some more details:
- where do you enter the data?
- where do they need to end up in?
- does it need to happen always or based on certain condidtions?

On 17 July, 16:59, Nycki wrote:
No and I was looking at some posts tyring to figure them out.

"AB" wrote:
Any familiarity with VBA/macros?

On 17 July, 16:21, Nycki wrote:
This may not be possible but I thought I would ask just in case.
I am trying to input data that will copy data into two different worksheets
as one is all combinded main data and the other is a letter. *I know to use =
but I wanted to know if there is a way so I did not have to create 100 plus
worksheets, everytime I had a new entry.- Hide quoted text -

- Show quoted text -