Coping data to multiple worksheets

[SSummers]

Using Excel 2003, created a workbook with multiple worksheets. I have
master worksheet, that we are keying into, in the master worksheet
have 4 companies.
Company A has data in columns K,L,T,U,V,W,AJ,AK,AL,AM
Company B has data in columns M,N,X,Y,Z,AN,AO,AP,AQ
Company C has data in columns O,P,AB,AC,AD,AR,AS,AT,AU
Company D has data in columns Q,R,AF,AG,AH,AV,AW

I have created 4 worksheets that have the columns listed above for eac
company. What I want to do is when something is typed in all th
columns that make up Company A that these cells would be copied to th
corresponding worksheet.

Is this possible and if so, can someone point me in the righ
direction. I will not lie, I'm clueless.

Thanks.

Susan Summer

 

[clane]

hello

all you have to do is go through the page where you want the data t
automatically populate and fill in the first row with links the firs
row of the colum it is going to be linked to so

go to the cell type = then go to the cell you want it to link to an
clink on it once then hit enter

do this across the whole first row in the page you want to populat
then highlight all of that row (click and drag) then go to the botto
right corner of the highlight with your mouse. the mouse should chang
to a cross then click and drag the cross down as far as you need


hope this helps

chuc

 

[SSummers]

Thanks, Chuck, I'll give it try.

Susa