Shazam
06-07-2006, 08:47 AM
Hopefully this could be possible in vba. In my attachment below in worksheet tab “Download” start by looking in column C with the given part numbers you want to be able to count the number of instance of that part # appears with in that column, with that count in mind now look at the "Orders" worksheet and by looking in column B, again count the number of times with in that column by part # then take the difference of the number of counts found in worksheet “Download” and the counts from “Orders” use that number and insert that amount of rows after the last entries of that particular part # in “Orders”.
Example:
Worksheet “Download” in column C
Shazam
Shazam
Shazam
Shazam
Shazam
Worksheet “Orders” in column B
Shazam
Shazam
Take the difference ( Basic Math )
(“Download”)-(“Order Results”) =3
5 - 2 = 3
Now take that difference that will be 3 and insert 3 rows in worksheet “Orders”. Example:
Shazam
Shazam
Insert row….
Insert row….
Insert row….
There is a worksheet tab named "Orders Result" that gives a example how it should look after running the code.
Example:
Worksheet “Download” in column C
Shazam
Shazam
Shazam
Shazam
Shazam
Worksheet “Orders” in column B
Shazam
Shazam
Take the difference ( Basic Math )
(“Download”)-(“Order Results”) =3
5 - 2 = 3
Now take that difference that will be 3 and insert 3 rows in worksheet “Orders”. Example:
Shazam
Shazam
Insert row….
Insert row….
Insert row….
There is a worksheet tab named "Orders Result" that gives a example how it should look after running the code.