LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pop up to flag an entry Andrew Mogg[_2_] Excel Discussion (Misc queries) 4 December 14th 09 05:18 PM
Pop up to flag an entry Andrew Mogg Excel Discussion (Misc queries) 1 December 2nd 09 11:11 AM
Flag Help Dan the Man[_2_] Excel Discussion (Misc queries) 2 August 19th 08 02:35 AM
Excel flag Max_power Excel Discussion (Misc queries) 3 March 8th 06 03:04 PM
flag cells M.A. New Users to Excel 1 December 5th 05 08:57 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"