linking columns

  • Thread starter Thread starter canthonica
  • Start date Start date
C

canthonica

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.
 
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.
Click to expand...

Hi canthonica

Link the first cell in the column, remove the $ signs and drag down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
linking two worksheets in the same workbook 6
Excel VBA 1
keeping rows together during column sorts of linked worksheets 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Hide columns based on row values 2
Re my question on sorting 1
data in 2nd column associated with =MAX(H1:H100) from another colu 2

Back
Top