stanleds
10-07-2013, 01:24 PM
Hi,
Can somebody please help. I have searched the internet for this issue and there are loads of posts about it but I am unable to find a resolution to my particular problem. part of the problem is my inability to adapt code that others have posted to suit my problem. I am unable to post my code at this time because I am at home now without my other laptop. Basically, this is what I am trying to do;
1. Open all Excel files (.xls, one at a time) in a network drive path that is specified in a cell. Lets say the cell is H3 on a worksheet called "Sheet 1".
2. When each file is open, I need to be able to apply the autofilter, filter two columns, lets say columns 3 and 5 an then select all records in columns a to t for all records that exist and then copy them.
3. I then need to be able to select the workbook that contains the code (this file) and then paste the data to the next available row on worksheet that is specified in a cell. Lets say the cell is H4 on a worksheet called "Sheet 2".
4. After each file has been opened and the data pasted to this file, each file can be closed without saving the changes.
I would be very grateful if anybody could offer any help.
many thanks. :(
Can somebody please help. I have searched the internet for this issue and there are loads of posts about it but I am unable to find a resolution to my particular problem. part of the problem is my inability to adapt code that others have posted to suit my problem. I am unable to post my code at this time because I am at home now without my other laptop. Basically, this is what I am trying to do;
1. Open all Excel files (.xls, one at a time) in a network drive path that is specified in a cell. Lets say the cell is H3 on a worksheet called "Sheet 1".
2. When each file is open, I need to be able to apply the autofilter, filter two columns, lets say columns 3 and 5 an then select all records in columns a to t for all records that exist and then copy them.
3. I then need to be able to select the workbook that contains the code (this file) and then paste the data to the next available row on worksheet that is specified in a cell. Lets say the cell is H4 on a worksheet called "Sheet 2".
4. After each file has been opened and the data pasted to this file, each file can be closed without saving the changes.
I would be very grateful if anybody could offer any help.
many thanks. :(