If you apply an autofilter, then filter the rows required copy paste the
result to another sheet, that might do it? Most of the code to do this can
be recorded in a macro, then adjust the code to allow for the different
length of rows showing in the filtered sheet.
--
Cheers
Nigel
"Randy Brown" <(E-Mail Removed)> wrote in message
news:76AB19BB-558A-40EE-9B8D-(E-Mail Removed)...
>I have a spreadsheet with a long list of data.
>
> I would like to extract a subset of that data, based on criteria in other
> columns. The results should go to another part of the spreadsheet, and
> need
> to be "printable".
>
> I can insert a macro that looks at the field and then copies the data, if
> the criteria is met, but then I have a big gap in the results and the
> printed
> report doesn't look good. I also have a problem if/when new entries are
> made
> to the data.
>
> I need a macro that can copy only the qualified data to the portion of the
> sheet, with no gaps.
>
> Data
> xxxxxxxxxxxxxxxxxxxx aaa
> xxxxxxxxxxxxxxxxxxxx aaa
> xxxxxxxxxxxxxxxxxxxx aaa
> xxxxxxxxxxxxxxxxxxxx bbb
> xxxxxxxxxxxxxxxxxxxx aaa
> xxxxxxxxxxxxxxxxxxxx cccc
> xxxxxxxxxxxxxxxxxxxx bbb
>
> Results should be
>
> xxxxxxxxxxxxxxxxxxxx bbb
> xxxxxxxxxxxxxxxxxxxx bbb
>
> Am I explaining this right?
|
Similar Threads
