Hi,
I've been looking at this fourm for a while now getting little hints and tips on how to do alot of my work, however, i now need help that i cant find in the fourm.
I am able to generate reports to excell as raw data which i need to import into access, however, i need to remove alot of the useless info that i dont need as well as split some of the fields to import to access properrly. I need a macro/VBA code that can run and find X in column A and if it does not appear in column A, then delete the entire row. Just to make it a little harder, I need access to automatically do this for me as new reports will be generated weekly and replace the exsisting report.
The main thing I need is to remove the useless data. (i.e. the rows that don't have X in column A)
Thanks in advance
I've been looking at this fourm for a while now getting little hints and tips on how to do alot of my work, however, i now need help that i cant find in the fourm.
I am able to generate reports to excell as raw data which i need to import into access, however, i need to remove alot of the useless info that i dont need as well as split some of the fields to import to access properrly. I need a macro/VBA code that can run and find X in column A and if it does not appear in column A, then delete the entire row. Just to make it a little harder, I need access to automatically do this for me as new reports will be generated weekly and replace the exsisting report.
The main thing I need is to remove the useless data. (i.e. the rows that don't have X in column A)
Thanks in advance
