I have been trying to link a dependent worksheet to a main source
worksheet. I have columns A-L and rows 1-55 on a spreadsheet. I don't
won't to see all the information on the second worksheet. How do I
link columns that I want to see in the second worksheet and have it
change when I edit the source worksheet. I know how to link cells but
I am confused about linking columns (or rows for that matter). Help
would be greatly appreciated.

Wrote:
I have been trying to link a dependent worksheet to a main source
worksheet. I have columns A-L and rows 1-55 on a spreadsheet. I
don't
won't to see all the information on the second worksheet. How do I
link columns that I want to see in the second worksheet and have it
change when I edit the source worksheet. I know how to link cells but
I am confused about linking columns (or rows for that matter). Help
would be greatly appreciated.

Hi canthonica

Link the first cell in the column, remove the $ signs and drag down


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=482410

Paul, thanks for your help.