linking

I have 52 spreadsheets - named "SalesWeek1", "SalesWeek2", "SalesWeek3"......"SalesWeek52" These spreadsheets capture the sales data for my business. The format/structure of each spreadsheet is the same i.e. Cell A1 contains Sunday Sales and does so in each of the spreadsheets. I want to...

Is there a FORMULA which will tell what external reference a cell is linked to? Say cell A1 on workbook1 is linked to cell A1 on workbook2: =[Book2]Sheet1!$A$1 In cell A2 on Workbook1, I want a formula which returns the name and location of the link, NOT the value. Cell A2 needs to return...

Hi all, I have an Excel file with names of people I have to divide into groups. On separate paper files they all wrote the names of people they'd like to be in the group with. The situation is a youth movement holiday with different groups of friends, so we can assume that if person A chose B...

I have two spreadsheets being used as logs for activites. On each is a summary tab, shoing a table of activities under each category. Category A-F are listed on Spreadsheet A, Category G-J are on Spreadsheet B. I'm trying to link the two to allow the user to go into either spreadsheet and...

Hi, in need of some assistance. I have a pivot table that displays information on servers, which has been pulled from a worksheet. Lets call it this worksheet SERVER INFO Location code, OS, server role, etc In another worksheet I have location information. Lets call this LOCATION INFO...

Hi, I was wondering whether there is a smart text option in powerpoint (or named something else) where you can link a heading in one slide to auto-update to text in another slide, liek in excel when you can set a cell to =a1 etc. Thanks

I have a master spreadsheet and want to create multiple separate spreadsheets with just some of the columns from the master. The master is a growing spreadsheet. I need the separate spreadsheets to update information if it changes in the master. I have kind of managed to do it by copying and...

I have an excel file embedded in a power point. (Both are 2007 for Windows running under XP). A VBA program extracts certain data and inserts it into text in the Power Point. This is working. I am trying to do something simpler which is to display a block of cells by linking them. If I use...

For example if the number 412 appears on sheet 2 somewhere in column A and 412 is also somewhere in column A on sheet one. How do I make a big bold X to appear in sheet one in the column J in the same row as the number 412? Help would be appreciated, I am struggling on excel!:confused:Thanks a...

Hi! I've created my first PowerPivot workbook. I created 11 tables from a single MySQL database, and linked them based on primary/foreign key pairs. I created a Pivot Table from the results, and dragged two columns into the row section; one from the "main" data table, and the other from a...

Hi All, Bar those who don't believe/celebrate in Christmas, Hope you all had a good Christmas and New Year celebrations. I have two sets of data, lets call them 2013 and 2014. I have a Spreadsheet already set up in excel, but currently I just past this information into a tab in excel (which...

I'm not sure if this can be done, I've been looking into linking workbooks, connections, etc. Any help would be much appreciated. Here's what I want to happen: Several users complete an excel form (Form) where only certain cells are unlocked for them to enter data. One of these cells is a...

Hi, I'm trying to link merged cells with unmerged cells and am having some problems. I have merged 4 cells vertically, when I try to drag down the link to the unmerged cells it skips to every 4th cell. e.g the link skips C2,C6,C10,C14,C22. Is there any way of linking the merged cells to...

Hello! First time posting here, though have come often searching for help. This time I couldn't find it just using the search engine. I hope someone can help. I have one master excel spreadsheet displaying jobs daily. Every day has a new tab. I have 5 other files that are distributed to...

MS 2003 Sheet 1 has condition: (Cell BK) <tbody> =IF(BJ7=TRUE,B7,0) </tbody> QUESTIONS: 1.) Values in B7 are the NAMES OF STUDENTS, if it happens to be false, is it possible to empty cell instead of zero? How? 2.) How am I going to "list" all the results in BK on sheet 2? Thanks in advance! :D

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hi, I have a work book that has about 20 pages in it. Each page has the same kind of data on about different products I want to sum them up in a final worksheet that groups them all together in one table. If on the final worksheet I link to the first sheet cell A9, i.e. Sheet1!A9 is there a...

Hey folks. Looking to make a very basic macro, but my VBA skills are below basic! Essentially, I want a macro that when used will set the currently selected cell to reference to the cell I most recently edited. So for example, after I complete the sum in C9, I want to go to cell A1, run my...

I have searched for this and have not come up with anything. I have 2 workbooks, 1 named "Main Workbook" and another called "Public Workbook" is there code that can be but into sheet 1 of the "Public Workbook" that will do the same as a formula such as this ='[main book.xls]Sheet1'!$A:$N

Good afternoon I have 2 work books called book 1 and book 2, cell A1 (in sheet 1) in book 2 is linked to cell A1 in book 1 by the simple formula ='[book1.xlsx]sheet1'!$A$1. However i regularly have to save and rename book 1 as ABC123, if i do this whilst book 2 is open then the link in book 2...