Extract data from specific range of cells in multiple worksheet in multiple files.

Posted by Michele on Super User See other posts from Super User or by Michele
Published on 2010-04-08T23:38:05Z Indexed on 2010/04/08 23:43 UTC
Read the original article Hit count: 433

Filed under:

formula

|

extract

|

data

|

excel-2003

Extract data from specific range of cells(always the same cells) in multiple worksheet in multiple files. 1 file=1 day. I have 6 technicians each day of the week, Monday thru Friday. So, 5 files with 6 worksheets. I have entered specific info in specific cells of every work sheet. The range is constant(the same address in EVERY worksheet in every file.) So, I need a formula to extract and calculate the data in the given range and dump it into another spreadsheet. I can forward an example a file if it will help anyone to answer my question. Or more explanation if necessary is available upon request. JUST PLEASE SOMEBODY HELP ME!!!!! Thank you all in advance. Regards, Michele

© Super User or respective owner

Related posts about formula

Excel formula - sometimes array formula, sometimes not

as seen on Super User - Search for 'Super User'
I want to write some data to an Excel file, and I want the first page to show a summary of the data that are spread all over the sheets. The individual data items on a sheet can be included or excluded, and I want the summary to be calculated only on the included values. Thus, I thought I'd use a… >>> More
Store a formula in a table and use the formula in a javascript/PHP function

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I have a MySql database where part of it handles instrument's depth of water. Each instrument has its own formula of calculation how depth the water when the operator collect the reading I stored the formula for each instrument in database/MySql. Example formula: [55-57] this is the simple minus… >>> More
Extract information from conditional formula

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to write an R function that accepts a formula as its first argument, similar to lm() or glm() and friends. In this case, it's a function that takes a data frame and writes out a file in SVMLight format, which has this general form: <line> .=. <target> <feature>:<value>… >>> More
Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Experience formula with javascript

as seen on Game Development - Search for 'Game Development'
I'm having trouble working out a formula using this experience curve to get the total exp after each level. I bet its easy and im just over thinking it. maxlvl = 10; increment = 28; baseexp = 100; function calc(){ for (i = 0;i<(maxlvl*increment);i+=increment){ expperlvl = baseexp +… >>> More

Related posts about extract

Extract archive here, autodetect subfolder

as seen on Super User - Search for 'Super User'
I use 7-Zip under Windows 7 to extract all kind of archives. The ever-running problem is that there is not a single way to handle subfolders. Some people create their archives like this (let's call it type A): . +-- subfolder ¦ +-- file 1 ¦ +-- file 2 ¦ +-- ... "Extract Here" will extract… >>> More
Retrieve Performance Data from SOA Infrastructure Database

as seen on Oracle Blogs - Search for 'Oracle Blogs'
My earlier blog posting shows how to enable, retrieve and interpret BPEL engine performance statistics to aid performance troubleshooting. The strength of BPEL engine statistics at EM is its break down per request. But there are some limitations with the BPEL performance statistics mentioned… >>> More
What command do I need to unzip/extract a .tar.gz file?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I received a huge .tar.gz file from a client that contains about 800 mb of image files (when uncompressed.) Our hosting company's ftp is seriously slow, so extracting all the files locally and sending them up via ftp isn't practical. I was able to ftp the .tar.gz file to our hosting site, but when… >>> More
Extract High Quality Icons from Files Using a Free Tool

as seen on How to geek - Search for 'How to geek'
If you need to extract an icon from a program file or other type of file (such as .dll files), there are many free tools available that make the task easy. However, very few will extract high quality icon images from the files. Most free icon extraction tools will extract smaller icon image sizes… >>> More
??GoldenGate?LAG???

as seen on Oracle Blogs - Search for 'Oracle Blogs'
GGSCI????LAG?? ????????????????Oracle?redo????online redo logfile? ? Replicat????????????????? ???????? ????,?????????????????LAG; ????????????????REPLICAT??apply???????????? OGG????RANGE??????????,????????REPLICATE??APPLY? OGG??MAXTRANSOPS???????? LAG?????????: ?Extract… >>> More