Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Select data from a tabular file format

0

Hello:

May I know how to extract data from a tabular file format as attached ?

Output Format 1   Employee No. / Work Hrs 0006677G 20 0014577Z 34 0214911C 56 Output Format 2 (Work Hrs based on 15-07-2016)   Employee No. / Work Hrs         0006677G 20         0014577Z 0         0214911C 24 Always take the first match record.

Have a nice day.

Answer
Discuss

Discussion

Can you describe the issue in more detail? It's not entirely clear what you are trying to ask. (edit your original question to do this)
don (rep: 1989) Sep 1, '16 at 4:25 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login