A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do extract cells from hundreds of excel files and put in one n



 
 
Thread Tools Display Modes
  #1  
Old November 19th, 2009, 06:59 PM posted to microsoft.public.excel.misc
Chris D[_2_]
external usenet poster
 
Posts: 3
Default How do extract cells from hundreds of excel files and put in one n

I need to extract expense totals from employee expense reports and put in to
one file for import then in to the payroll system fo reimbursement.
  #2  
Old November 19th, 2009, 09:50 PM posted to microsoft.public.excel.misc
JLatham
external usenet poster
 
Posts: 1,896
Default How do extract cells from hundreds of excel files and put in one n

Lots of unanswered, but needed information with this question. Generally
this can be done relatively easily, with a big "IF" - and that IF is whether
all of the files you'd be examining (the employee expense reports) have the
same format, content and layout.

Get in touch with me via email through (remove spaces)
Help From @ jlatham site.com
and we can gather some more information and probably have a solution in your
hands before the weekend is over, if you're willing to work on weekends! Be
sure to remind me in the email of what you need to do, and attaching a sample
employee expense report or two wouldn't be a bad idea - change private info
on it to 'protect the guilty' and help prevent exposure of that data.



"Chris D" wrote:

I need to extract expense totals from employee expense reports and put in to
one file for import then in to the payroll system fo reimbursement.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.