Extract Data From Rec to Summary

**Fili Rojas** · 11-21-2012, 04:33 AM

Need your help with a VBA Code to extract data from file Rec to Summary; New to Excel and VBA (NEED TO EXTRACT DATA HIGHLIGHTED IN YELLOW).
Your help is appreciated,

Will create unknown number of Rec Files.....so they need to go into the Summary in the next Available Row.

Also need help with the following VBA Code, I am using this to filter, copy and paste data into different worksheets, one by one, so I need the VBA Code to run the macro for all worksheets. Worksheets may grow to an unknown number.

Please Login or Register  to view this content.

Moderator's Edit: Use code tags when posting code. To do so in future, select the code and click on the # icon at the top of your post window.

**arlu1201** · 11-21-2012, 08:09 AM

Are these 2 different codes that you require?

**Fili Rojas** · 11-21-2012, 02:04 PM

Hello Arlette,
Yes, they are two codes. One is for extracting data from the RecXX File to a Summary with the highlighted items; second one is the partial code I attached which is working fine for just one worksheet, and needed to filter, copy and paste data into different worksheets.
Thank you for your reply.
Cheers,
Fili