looping through and deleting rows

**Ricardo9211** · 09-03-2009, 04:44 PM

I have a spreadsheet that has Column A (Name) column B (login information) column C (Date) Column D (Time)
example:
john doe Login 9/2/09 10:30am
John doe coach 9/2/09 12:00pm
john doe end shift 9/2/09 5:00pm

the spreadsheet has several names and login information what i need to do is go through the sheet and find login for that day and end shift for that day and delete all other rows for each person on the spread sheet.

Can this be done first off, i believe i would need to loop through but i cannot come up with a way to look at each name and then delete the other rows
need some serious help here

**JBeaucaire** · 09-03-2009, 05:53 PM

You can loop through the column and delete rows based on the value of column B. Like so:

Please Login or Register  to view this content.

**Ricardo9211** · 09-03-2009, 06:11 PM

Thanks for the loop but i tried and it did not work, I dont know why, there were no error messages but it just would not delete.. any other ideas

**Palmetto** · 09-03-2009, 06:28 PM

Code slightly amended and runs fine during testing. I assumed you have a header row you may want to keep so I adjusted to code to not delete row1.

Please Login or Register  to view this content.

**Ricardo9211** · 09-03-2009, 06:28 PM

Ok I think i have something working but it is working the opposite of what I need. I need to keep all rows that have "Login/Not Entered" or "End_Of_Shift" and delete all others but it is deleting all rows with the information above.

Please Login or Register  to view this content.

**JBeaucaire** · 09-03-2009, 06:39 PM

Yeah, you reversed the logic when you edited it. Here, I'll switch it back:

Please Login or Register  to view this content.

It's smarter to leave in the LCase() stuff since it makes your macro NOT be case sensitive, it would match LOGIN and Login and login and LOGin all equally.

**Ricardo9211** · 09-03-2009, 07:22 PM

Thanks it looks like its doing what it needs to do, now all i have to do is create more macros to finish it off, trying them now if I have any problems i know where to get the answers

Thanks alot

**JBeaucaire** · 09-03-2009, 08:18 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)