Re: Deleting unwanted data by macro or...

Tech-Archive recommends: Speed Up your PC by fixing your registry

Leibtek <Leibtek.2cghz7_1155435310.7569@xxxxxxxxxxxxxxxxxxxxx> wrote:

I have a list of items in column A. In the coming columns (B,C,D..)
there is the price for the item's common sizes (Small, Large,
X-Large...). Not all the items come in all sizes, some items have a
"cutoff" size meaning that the item is only available "up" to a certain
size. I want to be able to specify in a column (after the sizes), the
item's greatest size, and a macro should automatically delete all the
prices for that item that are greater than the specified size.

I'm having difficulty visualizing the problem...

Don <www.donwiss.com> (e-mail link at home page bottom).
.

Relevant Pages

  • Deleting unwanted data by macro or...
    ... there is the price for the item's common sizes (Small, Large, ... I want to be able to specify in a column, ... Leibtek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32287 ...
    (microsoft.public.excel.programming)
  • Re: Gear rack sources for small quantities?
    ... I get a bit squirrelly when dealing with places that have no price ... information available until you specify everything and get a quote (how ... can I make cost dependent engineering choices to specify things without ...
    (rec.crafts.metalworking)
  • Re: Nimbus now selling CD-Rs
    ... Regarding Arkiv making the fact known to their customers, I have to disagree in one instance - if you submit a title on Amazon that you are looking for and specify a price, if an Amazon marketplace seller gets it in and is willing to sell at at the price you specified, it is sent to you automatically. ...
    (rec.music.classical.recordings)
  • Re: Ladbokes Bet
    ... > Unless they specify that bets laid in error "at the wrong price" ... > are void, they have no alternative but to pay, or face objections ... pay out even though the bet was accepted. ... general rule that they are not responsible for price errors whether made by ...
    (uk.sport.horseracing)
  • Re: Brochure and website prices
    ... the UK it would be illegal for anyone to specify a price at which ... goods or services must be sold. ... we just had a Supreme Court ruling on this exact ... report I heard didn't specify. ...
    (rec.travel.cruises)