$$Excel-Macros$$ Re: Adding columns value from multiple files from a folder

2009-10-01 Thread kunal
H Kris, What i needed was to sum a range let say D2:D11 from all xl files to one file. That means : i need to get value of D2 as 10 in the master sheet where the cell D2 has 3 & 7 in two individual files. Regards, Kunal On Sep 29, 7:33 pm, Kris wrote: > Hi Kunal, > > See this thread. Adopt th

$$Excel-Macros$$ Re: Adding columns value from multiple files from a folder

2009-09-29 Thread Kris
Hi Kunal, See this thread. Adopt the code to suit you. http://groups.google.com/group/excel-macros/browse_thread/thread/61b820c5df194b14# Kris On Sep 26, 4:09 pm, kunal wrote: > Hi, > > I am stuck at this point. I need to add a range from a particular column > from all excel sheet present in