linking a column in one spreadsheet to another spreadsheet

N

N Richard

Hi, I'm trying to link all cells in a column in one spreadsheet to an
identical column in a separate (but identical) spreadsheet. I can do it
for one cell (type = in destination file and click in corresponding cell
in source file), but I cannot make it fill down to capture the rest of the
cells in the column. Thanks, Nikki
 
C

CLR

Look at the cell reference in your link......if it's like $A$1, change it to
A1 and then it will copy down......

Vaya con Dios,
Chuck, CABGx3
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Column widths in Excel 2013 16
Need to separate column data into headers 5
Locating Info In New Excel Spreadsheet When Compared To Old One 4
Excel 2 into 1 6
Macro to only run in one column of one worksheet? 7
Tranfering data from one spreadsheet to another Automatically 2
linking to a downloaded spreadsheet 3

Top