link cells

Hi, I have a master workbook that contains links to a bunch of other workbooks. Primarily, I am just linking to the data themselves, which are numeric. My links currently look like =[source_file.xls]sheetname!A5 I would like to do a few different things here: 1) incorporate replacing in this...

Hi guys, I need some help linking two cells in the same work sheet. I want to be able to click on a cell and it take the viewer to the related cell elsewhere in the spreadsheet... I can do this with a hyperlink but my issue comes when I move the linked cell to a new location. The link then goes...

I am trying to create a dropdown list that when an item is selected in the dropdown, the cells to the right autofill with data related to that selected item. For example. If I click on a dropdown and choose "Wednesday" in Cell A, then in Cell B, C, and D, autofill with "work", "gym", and...

I have 4 little daily report and 1 master report; I am trying to link them together so that when someone enters a total on the little report it will change the master report, any advice… <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> thx

I have several cells that are linked to a word document and they work great as long as I don't add row or columns or change the original location of the cell. Is there a way that I can add a row or a column in the excel worksheet without throwing off all my linked cells? Eg. I have cell D129...

Using Excel 2007, and want to link to another work book in existing document to return a value or the result of the formula. I tried entering an = sign and then linking to the cell and I received a "value" error. Thanks for any help.

I have 52 tabs that i want to link to a summary tab. each tab has a different date, by week (7 day increments) i have 14 different columns for 14 different 'districts'. i have already linked the first column (52 rows for each week of the year) to the summary page. Question - how to i copy and...

I am trying to add inspection data to a master worksheet. The data is associated with various colors we scan with a spectrometer in our incoming inspection operation. Color numbers range from 1 to 90 (1 is red, 2 charcoal, etc.). Each row contains, the color number, date, and associated data...

Hello everyone I am just wondering if any of you can help me. I have made drop down menu in excel ( say in Column b and there is a list of expenses say 40 expenses), I have Written same expenses one by one in column , c , d, e , f, g, h and so on. what i want is , if some write and amount in...

It must be easy to do, but I could not do it. I need to link cells in sheet one to same cells in sheet two. I can do it one by one but there are over 200 that I need to link to. So if I click cell A1 on sheet one, it should take me to cell A1 on sheet two. Thanks

I apologize if this has already been posted. I am trying to dynamically link two cells, and I don't think equations will do. Essentially, I am trying to acheive the following When I enter a value in Sheet1!A1, I want it to reflect in Sheet2!A1 When I enter a value in Sheet2!A1, I want it to...