Creating a autofill list with custom sorting

[qontrol]

Hello everyone,

I'm having difficulties creating this copy and delete text for my batch program.

I have this sheet:

Data	Data New	Data New NL	Data New FR
X_SUPPLIER_1000057	XEN_SUPPLIER_1000057	XNL_SUPPLIER_1000057	XFR_SUPPLIER_1000057
X_SUPPLIER_1000058	XEN_SUPPLIER_1000058	XNL_SUPPLIER_1000058	XFR_SUPPLIER_1000058

<tbody>
</tbody>

This goes to about 6000 lines

What I want to do is that the data above will automatically fill like this:

copy	X_SUPPLIER_1000057	XEN_SUPPLIER_1000057
copy	X_SUPPLIER_1000057	XNL_SUPPLIER_1000057
copy	X_SUPPLIER_1000057	XFR_SUPPLIER_1000057
del	X_SUPPLIER_1000057

<tbody>
</tbody>

copy	X_SUPPLIER_1000058	XEN_SUPPLIER_1000058
copy	X_SUPPLIER_1000058	XNL_SUPPLIER_1000058
copy	X_SUPPLIER_1000058	XFR_SUPPLIER_1000058
del	X_SUPPLIER_1000058

<tbody>
</tbody>

I know i can create an autofill list for the copy's and del's, but i can't get the numbers to be sorted like that.

Can anyone help me?

Thankss.

 

[VoG]

Cross posted Creating a autofill list with custom sorting

Please read Excelguru Help Site - A message to forum cross posters