nick99
07-23-2007, 10:51 AM
In the attached excel file you will see 3 work sheets.
Sheet 2 has data that I need to sort with respect to what's in Column D
The data in column D has three type of peculiar words:
WK
SRT
XK
I need to sort this data in such a way that all the WK?s and SRT?s are copied onto the WK Sheet
And only the XK?s into the XK sheet.
EXTRA ? This is not required urgently, it?s just for convenience. If the previous step is solved I can work on the problem below.
If possible can I have a message box to sort the column the way I want to with respect to either WK, SRT, XK or the liter type of the engine?
And then paste it into new sheet with an Input box asking me to name the new sheet?
Sheet 2 has data that I need to sort with respect to what's in Column D
The data in column D has three type of peculiar words:
WK
SRT
XK
I need to sort this data in such a way that all the WK?s and SRT?s are copied onto the WK Sheet
And only the XK?s into the XK sheet.
EXTRA ? This is not required urgently, it?s just for convenience. If the previous step is solved I can work on the problem below.
If possible can I have a message box to sort the column the way I want to with respect to either WK, SRT, XK or the liter type of the engine?
And then paste it into new sheet with an Input box asking me to name the new sheet?