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 -