View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jip jip is offline
external usenet poster
 
Posts: 8
Default Rows to be moved from one flag to another flag

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