Jayman88
03-26-2009, 05:56 AM
Alright guys,
new here! Hope all is well with you
So i need some help with vba & macros (excuse me but im a little new at this.
Ok so i did a course yesterday and it went over the whole macro thing and coding with vba, got me quite intrested.
So now im trying to create a macro for work purposes to do a rubbish job by simply running the macro!
The first bit i have down. I did this by recording a new macro...and taking the code from it to hopefully add to a bunch of other codes to create one big code(can this actually be done by the way?)
So a little bit about this spreadsheet i work with.
Its an error log, its different every time we get it, Involves alot of copying and pasting to different tabs.
The bit im stuck on is trying to filter out any codes on the ssheet that begin with an "L", can someone help me with a simple code to enable me to do this??
Cheers
J
new here! Hope all is well with you
So i need some help with vba & macros (excuse me but im a little new at this.
Ok so i did a course yesterday and it went over the whole macro thing and coding with vba, got me quite intrested.
So now im trying to create a macro for work purposes to do a rubbish job by simply running the macro!
The first bit i have down. I did this by recording a new macro...and taking the code from it to hopefully add to a bunch of other codes to create one big code(can this actually be done by the way?)
So a little bit about this spreadsheet i work with.
Its an error log, its different every time we get it, Involves alot of copying and pasting to different tabs.
The bit im stuck on is trying to filter out any codes on the ssheet that begin with an "L", can someone help me with a simple code to enable me to do this??
Cheers
J