Import data from a particular cell in different excel sheets

S

Sri Harsha

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If logic for text 3
Values imported from one workbook to another 1
Macros 1
Lookup 3 columns and return a result from another column 4
combining data from multiple worksheets 2
pareto chart in Excel 2007? 1
Adding values from two different worksheets from workbook 2
Summing exported data from 2 tables into 1 table 2

Top