Re: Auto Filter out text or blank rows

Heres the deal, one of my suppliers emails me my order I've placed with them
over the phone. The only file they can send to me which has my costs in it
is an Excel version of the order....designed to be printed just like thier
paper order...with headings (where column A is blank and accounts for about
20 rows of data) and categories (which always have text in column A). I'm
attempting to create a complex macro which gets rid of all the junk (rows
with headings & categories) to get to a comma delimited text file for
importing into an inventory management database.

The total number of rows in any given order is variable, therefore, I'm
trying to set a macro to get rid of the junk and keep the important data.
Does this help?

"Dave Peterson" wrote:

> I'm not quite sure what you mean. Do you want to show the rows where the value
> in column A begins with a letter (or column A is empty)?
>
> You could use a column of helper cells with formulas like:
>
> =OR(AND(CODE(UPPER(A2&"A"))<=90,CODE(UPPER(A2&"A"))>=65))
>
> Then filter to show only the Trues.
>
> D Hafer - TFE wrote:
> >
> > What would I put into an autofilter parameter to show only rows which begin
> > with text or are blank?
>
> --
>
> Dave Peterson
>
.

Relevant Pages

  • Re: Auto Filter out text or blank rows
    ... "Dave Peterson" wrote: ... >> attempting to create a complex macro which gets rid of all the junk (rows ... >> trying to set a macro to get rid of the junk and keep the important data. ...
    (microsoft.public.excel.misc)
  • Re: Auto Filter out text or blank rows
    ... Sub testme() ... > trying to set a macro to get rid of the junk and keep the important data. ... >> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: Crashes etc.
    ... the junk. ... Simply way is just reformat which would basically get rid of everything. ... destory & then ad-aware and run weekly check to keep your junk down to a ... > My computer constantly crashes and when I click some icons on my desktop ...
    (microsoft.public.windowsxp.general)
  • Re: SPAM
    ... Can the moderators or others associated with setting up and ... administrating this list please take some action to get rid of this junk? ...
    (sci.physics.electromag)
  • Re: various
    ... I'm trying to get rid of all the junk ... and quote handling and I can't remember having to reflow a quote ... so I would not classify it as "junk". ... the benefit of OE-quotefix can be seen on the homepage, ...
    (rec.audio.pro)
Loading