Hi,
I have a several files that contains multiple worksheets with different names, but Data forms in those worksheets are the same. See attached example.
I need to retrieve from given data in all worksheets information in following order:
Date ID Overall work hours Code Details (if column is not blank)
Please help me with some advise how to do it in non manual mode!
It will be good if you upload a sample output file showing how you want the output to look like.
Also, are the files all stored in 1 folder?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Output is sheet "Results from sheet 12" - this is how info should be retrieved from sheet named "12".
And yes, files are stored in 1 folder.
There is no sheet named "Results from sheet 12".
Sorry,
maybe some mistake, I added a new one.
Dear members is there no suggestions for solution?
So if i understand your output sheet correctly, only those IDs where Overall work hours are populated are included, right?
How do you get data in columns D & E? Which columns in sheet (12) are filtered?
Yes, you're right about first one.
About columns D&E in output sheet - I filtered by columns G&L which are below merged cell "Details". Main thing is if user has filled "overall work hours" there must be details about his work. Then i just manually took code information and job details.
Do you first filter on G for non-blanks and then filter on L?
Yes, I filter first on G for non blanks and then one by one till L, cause details are not always the same for all workers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks