View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Tom Ogilvy or somebody else, please help

Your problem statement said you had good or bad in column G, but you want to
copy good rows to G14 and below. At the same time, you actually said Cut,
so if one was looping, one would need to also manage the good/bad indicators
in column G and in that case, G14 would be a moving target. Also, if the
original data extends beyond 13 rows, the good rows would overwrite the
good/bad indicators.

Also, you say between A:F, does that mean copy B:E or is it inclusive (A:F,
with A and F included).

Also, your description about between two values is unclear. It could be
interpreted that one wants to find the first two Good values in column G and
copy the rows between to G14 - however you say A:F, (column designations),
so it really isn't very clear what you want to do.

If your are just trying to separate the good and the bad into two separate
groups, then
Personally, I would copy all the data to another location, then delete all
the bad at the new location and delete all the good at the original
location.

Perhaps you can give a clearer explanation of what you are trying to do.

--
Regards,
Tom Ogilvy


"gaba" wrote in message
...
Hi Tom, I'm sorry to bother you but If you can at least give me an idea on
how to start or how to approach the solution I would greatly appreciate

it.

I've post a question few hours ago:
Find two values and select data in between.
I don't want to duplicate the question but I'm stuck and I need this to be
done today... I'm going in circles

Thank you so much
--
gaba :)