Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import data from a particular cell in different excel sheets
Hi,
I have an excel sheet named "Defect Log" in various folders that captures defects for the document in that folder. This log calculates the Defect Density using a formula. My question is that at the end of the month, i have to get the defect densities from each of these defect log, collate them and make a graph... so, is there a way that we can import the value of a particular cell or a range of cells to a new worksheet? Thanks and Regards, Sri Harsha Kiran.P |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import data from a particular cell in different excel sheets
Ron de Bruin has tons of examples he
http://www.rondebruin.nl/tips.htm Look at the "Copy/Paste/Merge examples" section. Sri Harsha wrote: Hi, I have an excel sheet named "Defect Log" in various folders that captures defects for the document in that folder. This log calculates the Defect Density using a formula. My question is that at the end of the month, i have to get the defect densities from each of these defect log, collate them and make a graph... so, is there a way that we can import the value of a particular cell or a range of cells to a new worksheet? Thanks and Regards, Sri Harsha Kiran.P -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Txt file over several excel sheets | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import Cell Data | Excel Worksheet Functions | |||
how do i use import to consolidate data from multiple sheets | Excel Worksheet Functions | |||
in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) |