I would like to link multiple cells to multiple cells in different
worksheets

sheet 1 -I have inputs from three different columns and would like them
to go into one master column in sheet 2

I dont want any spaces so I dont know how to link the two sheets

Also everytime i input something in one of the three columns of sheet 1
I would like them to transfer to the master column in sheet 2, so copy
and paste isnt an option

Please help

I really appreciate all that everyone does to help

Thanks


--
jpoltor
------------------------------------------------------------------------
jpoltor's Profile: http://www.excelforum.com/member.php...o&userid=32596
View this thread: http://www.excelforum.com/showthread...hreadid=525104

jpoltor,

if I have understood your post correctly, what you want is a union of
three different lists into a single one, and you want this dynamic,
regardless of the lengths of the lists, which might vary. My solution
is general enough that it allows the input columns to be anywhere. It
assumes that, in each column, your data starts from row 1.

In preparing, you will need a small table with auxiliary information.
Let us say this table starts at J1.

In J1, J2, J3 enter the letters of the columns that contain your data.
For the formula I am suggesting a single letter is enough (e.g. A, C,
E)

In K1 enter the following formula and copy through K3:
=COUNTA(INDIRECT(J1&":"&J1))

In L1 enter 1. Then in L2 enter the following formula, and copy to L3:
=L1+K1

In M1 enter the following formula and copy through M3:
=COLUMN(INDIRECT(J1&1))-COLUMN(INDIRECT($J$1&1))

You are now ready to join the data, with the following formula, which
should be placed in row 1:
=OFFSET('Sheet1'!$A$1,ROW()-VLOOKUP(ROW(),L:L,1),VLOOKUP(ROW(),L:M,2))

I am assuming that the auxiliary table and the output data are in the
same sheet, which is different from the input sheet, which is called
Sheet1. Replace the name within the single quotes to suit.

HTH
Kostis Vezerides

Can you try to explain that better. Im not very good with computers and
you know what I want to do.

I want the expenses that I put in i14:I50 & e14:e50 & a14:a50 to go to
a worksheet labeled checkingacct in A15:A150

I want them to input one after the other when information is entered,
regardless of the three columns that I input in.

Please help

Thanks

JP


--
jpoltor
------------------------------------------------------------------------
jpoltor's Profile: http://www.excelforum.com/member.php...o&userid=32596
View this thread: http://www.excelforum.com/showthread...hreadid=525104