MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking Sheets


Posted by Joe Mede on January 19, 2002 2:43 PM

I have a workbook that has 2 sheets. One sheet is a detailed log of projects and another sheet is a summary. All fields are text only. The first 10 columns are exactly the same. How can I enter into the "detail" sheet and have it auto update the "summary" sheet in those first 10 columns.

Thanks in advance for any help,
Joe


Posted by Chris D on January 19, 2002 3:05 PM

Hi Joe,

if the rows are exact too, just go to cell A1 in sheet 2 and enter the following :

=+Sheet1!A1

or

=+Sheetname!A1 (where sheetname is the name of your first sheet)

then drag the formula over your other 9 columns and drag it down as far as is required.

(by dragging, I mean position your mouse pointer on the black box at the bottom right of cell a1, the pointer should turn into a "+" then left click and drag over/down as far as you want.

is this what you had in mind ?
Chris

Posted by Joe Mede on January 19, 2002 4:04 PM

Thanks Chris,

It works but it loses the format of the cells (like shading and wrap text). Is there any way to do it so it copies everything, including the format?

Posted by Joe Mede on January 19, 2002 4:21 PM

Thanks Chris,

It works but it loses the format of the cells (like shading and wrap text). Is there any way to do it so it copies everything, including the format?

Posted by Mudface on January 19, 2002 4:35 PM

Aladin -

I used your code and it gives me an error. Says something about a circular reference. Please help again.


Posted by Mudface on January 19, 2002 4:45 PM

My reply seems to have got tangled up in another thread so here goes again-

Select the cells you want to link, copy them and paste special- paste link to where you want them to be. Paste special again and choose the 'Formats' option- this should preserve your formatting from the original sheet, although in my experience, word-wrap is a law unto itself :).