Platform Windows 2000 and Excel 2000
I am dealing with an Excel file enclosing following columns:
Part number
Part descriptions
X-Price
Y-Price
Group 1
Group 2
The file has approximately 5000 rows.
Some of the Part numbers consist only of numbers other of numbers and
letters - I need a
VB-code to go through all these the part numbers in the
current flag (let us call it "Products without letters") and move those
enclosing a letter (letters) to another flag (that we can call "Products
with letters").
Of course it is important that all cells belonging to the part number:
description, prices and groups are being moved together with the part number
to other flag.
As described above I need the whole row including: Part number (with
letter/letters), Part description, X-Price, Y-Price, Group 1 and Group 2 to
be deleted from the Excel-flag "Products without letters" and set up in the
new Excel-flag "Products with letters".
Hopefully this is understandable and somebody is able to help me solving
this problem?
JIP