Quick Little Function Help...
 

Hi,

Basically, what I need to accomplish is this:

I have ran a web query with excel 2003, and the site I ran this query
on gave me result like this:

In one row of the workbook, I have:

_PRODUCT_ID_:

0001
Item #:
0002
Item #:
0003 ID:
Item #:

What I need to do is remove the cells that say Item #: and then shift
the cells up so that the item numbers are the only ones in that row and
no spaces between them.

Thanks alot for your help in advance!
-Brian


--
Brian07002
------------------------------------------------------------------------
Brian07002's Profile: http://www.excelforum.com/member.php...o&userid=15915
View this thread: http://www.excelforum.com/showthread...hreadid=385676

Here are 2 ways to do this:

Easiest:
1)Sort the list. (all the "Item #:" will goup together)
2)Select the "Item #:" rows and delete them
Done (but you lose the original order)

OR

DataFilterAutoFilter
Product ID dropdown, select "Item #:"

Then
select the displayed "Item #:" rows (all at once)
EditGoTo[Special...] Visible Cells Only
EditDeleteEntire Row
DataFilterShow All
Done

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=385676

Hi,

Thank you so much! It worked great!

-Brian


--
Brian07002
------------------------------------------------------------------------
Brian07002's Profile: http://www.excelforum.com/member.php...o&userid=15915
View this thread: http://www.excelforum.com/showthread...hreadid=385676