Can I jump in, so overall for such task, you have to make something called absolute cell or worksheet so that the formula can refer to that particualr area?? Sorry for such stupid question as I'm just starting to learn Excel in my course here, I mean the formula like =3Dif and vlookup etc. So I'm learning over here too.[ =20 The everlasting dilemma is, if you choke a smurf, what colour does it turned? Best and regards, Thomas Nathan Chan Webpage: http://www.heartwarmers4u.com/members/?thomas ICQ: 70375853 MSN Messager: thomasnathan2001@xxxxxxxxxxx -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Linda F. Johnson Sent: Monday, September 02, 2002 7:57 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: linking spreadsheets in Excel Yes Beth....you can open one workbook and put a formula in any cell that says something like this Lets say you have one file named Joe with a sheet named Sam You have a second file named Bob and in this file you want to have the information that is in the Joe file, the Sam sheet in cell A1 to be automatically updated in the Bob file in cell B1 Go into the Bob file and enter this formula in B1: =3D[Joe.xls]Sam!$A$1 An easy way to do this is to just open both files at the same time, then click in cell B1 in Bob and type an equal sign....then go to the Window menu and select Joe and click in cell A1 on the Sam sheet and hit the enter key....this will bring you back to the Bob file with the formula above already inserted. I hope this is clear....you might want to actually make these sample files I mentioned so you can see how this works. Hope this explains it. Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm =20 -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of ECarmona@xxxxxxx Sent: Sunday, September 01, 2002 4:40 PM To: mso@xxxxxxxxxxxxx Subject: [mso] linking spreadsheets in Excel Hi Linda and group I am working on a budget using Excel for several different people and=20 part of the information I am putting in is the same for all of the other people. Is there a way I can link all these sheets together while working on=20 them then insert the information in one sheet and have it entered=20 automatically into the other sheets at the same time, instead of going from=20 one to the next? =20 Thank you in advance,=20 Beth ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to=20 mso-request@xxxxxxxxxxxxx?Subject=3Dunsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************