I would like to create a summary report from individual files saved in 1 folder.
We have about 20 staffs who file the time sheet on a monthly basis. Indvidual time sheet contains 4 sheets, I would like to copy only files form sheet 2 and sheet 3 to the master file.
I need help as am very new to VB.
Any help would be really appreciated.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks Mehmetcik
Really appreciated your help in this matter. I did some work on the indvidual time sheets. Attached are 4 sample timessheets (4 STAFFS) I have input test datas in those and alos attached is a consolidated version in whcih I want to extract indvidual information.
I would like to Copy data from :
1: Timesheet Summary Sheet
2: Timesheet Detailed Sheet
3: Advice and Assistance Sheet
Thanks for your help again.
trying to upload files its not uploading
Is there anyother way to sent files
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks