Macro to move rows, row by row, based upon specific criteria.

**luke8182** · 02-19-2012, 01:24 PM

Macro to move rows, row by row, from one worksheet to another worksheet based upon specific criteria.

I need a macro that I can apply (to a rectangle click) to match and move rows from one work sheet to the corresponding row in another worksheet.

Conditions:
-Column A "Location" = Values are Unique
-All other Columns = Values are NOT unique
-A list of Contents is added to the worksheet "PullSheet"
-The "Get Pull Sheet" rectangle is clicked

1. The first, only the first, matching contents row in the worksheet "MasterLog" is moved (copied and then deleted, so it cannot be pulled again, from "MasterLog") to the corresponding row in worksheet "PullSheet".
2. If the MasterLog's "On Hold" column's value is "True", it does not recognize this row as an option to be moved to PullSheet.
3. Then goes row by row (Item by Item) doing the same thing.

The top 3 criteria are very important to me. If it is possible the next 2 would be very helpful as well, but not necessary.

4. If the Contents row in "PullSheet" does not have a match in "MasterLog" it should be highlighted Red.
5. If the Contents Row in "PullSheet" matches a (Location) that is a "Z?????" it should be highlighted Green after being moved to "PullSheet"

I have attached a sample workbook to see more clearly what I am referring to. Thank You All.

**Charles** · 02-19-2012, 04:21 PM

luke8182,

Welcome to the forum.
Would it be possible for you repost the workbook with an after code example. In your current workbook you have several "Contents" listed multiple times.

**luke8182** · 02-19-2012, 05:57 PM

Thanks for your quick reply. I am semi-versed in macros and I know this one may be a bit of a challenge.

Here is another workbook with the first two lines of the PullList filled in. The idea behind the workbook is that there are several of the same items in different locations, and locations are not item specific. When an order comes though, I need to create a pull list that pulls those items out of the MasterLog and onto the PullList. Then they can be located and pulled. I run into problems with a macro because it seems to try and pull an item out of the same location for each time it is on the PullList.

Thanks again.

**Charles** · 02-19-2012, 08:07 PM

Hi,

Just looked at your new book. And I'm still not sure about it. If you are "Pulling" "A3343I". In your example you show the "Location" as "A0112", but when you look at the "Master sheet for "A0112"
It has "A4456P" as it's content. Is this correct?

**luke8182** · 02-19-2012, 10:56 PM

Sorry for the confusion Charles,

A0212 has the contents code A4456P. A0112 should not be appearing on the MasterLog. The location numbers should not appear on the MasterLog unless they have a package. The numbers in the location column, although similar, will not ever be the same as the numbers in the contents column either. Each number in the location column refers to a shelf. The ZA numbers in the location column are at a different warehouse. Each number in the package column refers to a specific shipment ID. Each number in the contents column is the actual item on that shelf. This is just a small sample of coded material that's about 15,000 items.

I've attached an easier to understand book. It has the locations the same, but I condensed the other numbers into a much easier to understand format.

Thanks again for your patience.