Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display data from multiple worksheets' cells in one worksheet
How do I display data from multiple worksheets for the same template fields
in one place without physically linking each worksheet's cell to the one place for each worksheet and cell? I attempted to do this by first putting the path names to the worksheets in a column. Then I concatenated that cell's text with the cell position I wanted (ex. $A$3). However, I can't get Excel to evaluate the contents to display the value in the worksheet's cell (that is, to link to the value) rather than the path name followed by the cell name. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display data from multiple worksheets' cells in one worksheet
Hi J!
You can try this macro that create the formula links for you http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "J!" wrote in message ... How do I display data from multiple worksheets for the same template fields in one place without physically linking each worksheet's cell to the one place for each worksheet and cell? I attempted to do this by first putting the path names to the worksheets in a column. Then I concatenated that cell's text with the cell position I wanted (ex. $A$3). However, I can't get Excel to evaluate the contents to display the value in the worksheet's cell (that is, to link to the value) rather than the path name followed by the cell name. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |