Got an assignment that I'm having a hard time with.
I have a spreadsheet full of date, in random lenghts etc... The only thing stable on the sheet, is all the data I need has LOCATION03AB in column b on the lines I need.
I.E:
Ticket #, Location, Priority, Date/Time, User
001, LOCATION01CA, 3, 12:00pm, user1
016, LOCATION03AB, 3, 11:03pm, user9
019, LOCATION01CA, 3, 11:08pm, user11
103, LOCATION01CA, 4, 10:03am, user9
110, LOCATION03AB, 2, 07:00am, user3
etc..
what I need is a way to look through the spreadsheet. If it finds LOCATION03AB, it copies the line to a new line on a seperate tab, then goes to the next one. Once it finds another one, it copies it to the next line on the seperate tab. etc....
So on Sheet2, it would only display:
Ticket #, Location, Priority, Date/Time, User
016, LOCATION03AB, 3, 11:03pm, user9
110, LOCATION03AB, 2, 07:00am, user3
Basic layout:
DO until end of page
If b2="LOCATION03AB" then copy and paste, go to next line.
Next.
Hope the description is understandable.
I have a spreadsheet full of date, in random lenghts etc... The only thing stable on the sheet, is all the data I need has LOCATION03AB in column b on the lines I need.
I.E:
Ticket #, Location, Priority, Date/Time, User
001, LOCATION01CA, 3, 12:00pm, user1
016, LOCATION03AB, 3, 11:03pm, user9
019, LOCATION01CA, 3, 11:08pm, user11
103, LOCATION01CA, 4, 10:03am, user9
110, LOCATION03AB, 2, 07:00am, user3
etc..
what I need is a way to look through the spreadsheet. If it finds LOCATION03AB, it copies the line to a new line on a seperate tab, then goes to the next one. Once it finds another one, it copies it to the next line on the seperate tab. etc....
So on Sheet2, it would only display:
Ticket #, Location, Priority, Date/Time, User
016, LOCATION03AB, 3, 11:03pm, user9
110, LOCATION03AB, 2, 07:00am, user3
Basic layout:
DO until end of page
If b2="LOCATION03AB" then copy and paste, go to next line.
Next.
Hope the description is understandable.