Hi,
I need help writing a macro.
Basically I have about 30 worksheets in each workbook, and in column B of each worksheet there are a bunch of codes listed. Some of the codes are only numbers whereas the other codes are prefixed with 'Bar' as the front...
so some will look like this '23503252' and others will look like this 'Bar93222'
The macro needs to be able to find the codes beginning with 'Bar', copy the entire row, and paste the entire row onto a NEW worksheet called "result" or summary....
I have uploaded a sample workbook with some data in 3 worksheets and a results spreadsheet which I have populated so you can see what the result should look like (but my real workbook will have around 30).
Thanks in advance! please help!
Cheers,
Dexter
Bookmarks