MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking columns between different sheets

Posted by Bret Peresich on January 31, 2002 4:06 PM

I would like to know if there is a way to link columns of data from one sheet with a column on another sheet. I have multiple different sheets and the column headers don't match up and want to be able to easily link between the different columns so that if the information on one of the sheets is changed, it is automatically updated on the "Master Sheet". Is this possible?

Posted by Paul on January 31, 2002 5:12 PM

Use something like =Sheet1!A1 (NT)