Need Macro to Move 2nd Duplicate Product to Sheet2

[brooke.nguyen]

I have a spreadsheet with 2 columns. Column A being the product number and Column B being a checkin/checkout time. How do I move a product's checkout time to sheet2? Example below:

Currently Sheet1
Product..... Time
0001........ 20121119081512 (Checkin)
0002........ 20121119081530 (Checkin)
0003........ 20121119081602 (Checkin)
0004........ 20121119081645 (Checkin)
0005........ 20121119081708 (Checkin)
0001........ 20121119081600 (Checkout)
0002........ 20121119082001 (Checkout)


After Macro:
Sheet1 (Product Check In):
0001........ 20121119081512
0002........ 20121119081530
0003........ 20121119081602
0004........ 20121119081645
0005........ 20121119081708

Sheet2 (Product Check Out):
0001........ 20121119081600
0002........ 20121119082001

[rylo]

Hi

Are all the items going to be beautifully organised like your example where all the check outs will be at the end of all the checkins, or are you going to have checkins and checkouts scattered through out the range? If so, then when an item is moved to Sheet2, what do you want to do with the resulting blank cells? Delete just the 2 cells, or the entire row?

rylo

[xladept]

Here's a little trick that I got from Alphafrog on a recent post - try it:

Please Login or Register  to view this content.