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