automate data collection in excel

I am trying copy and paste data from an many excel files in a folder. The steps I am using to get data are as follows:

1. I have a file called Summary.xls to collect all information from many excel files (File1.xls, File2.xls...) in a folder.

2. Need to copy Entire rows in each excel file on the folder to Summary.xls, starting from Row35 (other files can have 100 rows below R35) and only if Column I has a value of "ADD", "DELETE", or "MODIFY". else move to next file.

3. Need to add 1 blank row to seperate each file after copied to Summary.xls


Managed to get a macro to run to parse the .xls files in a folder (from another forum)

But cannot do the copy and pasting part. hoping someone can help me. Thanks in advance.


================

Please Login or Register  to view this content.

==================

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time, but read the Forum Rules before posting again

Maybe something like this

Please Login or Register  to view this content.

Are the sheet references correct?

Hi,

Yes the sheet references are correct, but still it is not getting the info i need.

I have uploaded a sample template for you to have an idea which information i need.

Basically, in this template i need to copy the rows 37 - 40 which has Column I value of ADD, DELETE or MODIFY.

Some templates have more that 15 entries, so i need all of them, to copy in my Summary.xls.

Thank you for helping me.

See if this works

Please Login or Register  to view this content.