Posted: 9/20/2014 10:45:02 PM EDT
|
wasnt sure where else to ask this.......
In one workbook, I have a worksheet named ALL. I want to make a new worksheet titled DISPLAY that automatically populates and updates with data from the worksheet titled all WHEN a particular term is used in column A Then another worksheet for a different term from Column A make sense? anyone help with the formula that would do this in the new blank worksheet?? |
|
Not too sure what you are exactly wanting to do. But try this: on your <display> tab/page. go into the cell where you want the data from <all> to be. Enter an "=" without the quotes in the cell on the <display> then flip to what ever cell of data you want form <all>. Then flip back to your <display> and hit enter. It should populate with the formula and link.
Example: I have 2 different sheets book 2 and book 3. In book 2 I have a tab <all>. book 3 has a tab <display> here is what the formula would look like. =[Book2]all!$A$1 This is for cell a1 in book 3 If you have 1 spreadsheet with different tabs it would look like this. =all!A1 Hope that helps if it is crunch time on a project. I am sure there are more savvy Excel operators out there with really cool ways. I hack my way through 
|
|
Quoted:
wasnt sure where else to ask this....... The Forum called >General>Urban Commandos is the software forum. In one workbook, I have a worksheet named ALL. I want to make a new worksheet titled DISPLAY that automatically populates and updates with data from the worksheet titled all Is DISPLAY in the same workbook as ALL? If so, cell A1 in Display can be populated with formula that looks like: =+ALL!A1 Copy and paste this formula into all the other cells of Display which you want to auto-populate. WHEN a particular term is used in column A Which row in which worksheet? Then another worksheet for a different term from Column A Huh? make sense? No, it seems you got lazy describing the situation. anyone help with the formula that would do this in the new blank worksheet?? |