D
D Jannu
I am not an expert in Excel....!,
I encountered a situation where in I had to get data from 14 excel separate sheets having same structure (differing in values).
After playing aroung with excel for few minutes, I found "Import External Data" under Data. Manually I imported all the 14 sheets and in my main sheet wrote a small formula which would give a consolidated information.
With this you also have a feature which refreshes data (at specified time / or when opened).
There might be a different & faster way to do it, which I am not aware of!!!. Anyway this worked for me.....!
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
I encountered a situation where in I had to get data from 14 excel separate sheets having same structure (differing in values).
After playing aroung with excel for few minutes, I found "Import External Data" under Data. Manually I imported all the 14 sheets and in my main sheet wrote a small formula which would give a consolidated information.
With this you also have a feature which refreshes data (at specified time / or when opened).
There might be a different & faster way to do it, which I am not aware of!!!. Anyway this worked for me.....!
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com