VBA: cut/paste orders into different files based on common/duplicate IDs

[rubyb]

Hi all,

I am very new to VBAs and macros and am not quite comfortable with them, but a new school project requires their use (I think!). I have looked at many other threads posing similar questions, but none of the solutions seem to fit my needs...

This is the deal: my project requires me to look at raw data and automatically have it sort into different files based on if there is is a duplicate entry in a specific column. This is an example of the raw data (dummy data and titles); assume that it is in a file called "raw data.xlsx":

Order date	Expected delivery	Product	Product code	Price$	Quantity	Total	Buyer ID
14-09-01 <!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody> </tbody>	14-09-07 <!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody> </tbody>	98476	BETAx303	1200	12	12400	123ZXY <!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody> </tbody>
14-09-04	14-09-10	34876	ZETAq4	1000	14	1400	678TUV
14-09-04	14-09-10	34877	WARK3	875	35	30625	678TUV
14-09-10	14-09-15	18983	BETA304	500	47	23500	432LKN
14-09-19	14-09-20	58302	NOVAs21	1500	15	22500	987EWW
14-09-19	14-09-20	58305	ZETAqa <tbody> </tbody>	1000	19	19000	987EWW
14-09-20	14-09-28	20394	BLOMz1	2000	9	18000	567ABC
14-09-21	14-10-01	98477	ZETAq4 <tbody> </tbody> <colgroup><col width="65" style="width:65pt"></colgroup><tbody> </tbody>	1000	25	25000	302WLU

<tbody>
</tbody>

So what I need to do is to have a macro be able to identify if there are any duplicates in Column H/Buyer ID, and then have this row be cut and pasted (NOT simply copied and pasted) into another file, called "Multiple orders.xlsx". Essentially the point of the project is to be able to identify if any buyers are making more than one purchase per order.

I know how to do this manually, i.e.: find duplicates with conditional formatting and then cut/paste manually. However, I want to be able to automate this so that time is saved and the chance of errors is reduced.

Please let me know if something doesn't make sense… Any help would be much appreciated!