A
andibevan
Hi All,
I regularly run a number of reports which need to be combined into on
report and would like to try and automate the process.
I can put all the files in a seperate directory on their own to mak
the process easier. The required data is only contained within colum
A. I need to do the following:-
1) Combine all data from all files in the designated directory
2) remove any rows where column A is blank
3) remove any rows where the entry is "Journal Report" as opposed t
the data (Journal Report is the standard header put at the top of eac
page)
Alternatively for 2 & 3 I could merely remove the first 3 lines fro
each file before they are merged.
Any help with this would be gladly recieved. Hope I have been clear.
Thank
Andi :confused
I regularly run a number of reports which need to be combined into on
report and would like to try and automate the process.
I can put all the files in a seperate directory on their own to mak
the process easier. The required data is only contained within colum
A. I need to do the following:-
1) Combine all data from all files in the designated directory
2) remove any rows where column A is blank
3) remove any rows where the entry is "Journal Report" as opposed t
the data (Journal Report is the standard header put at the top of eac
page)
Alternatively for 2 & 3 I could merely remove the first 3 lines fro
each file before they are merged.
Any help with this would be gladly recieved. Hope I have been clear.
Thank
Andi :confused