software

I have a co-worker that would like to make a feature in EXCELL that would
select a non-contiguous series of rows based on a specific character (like a
!) in column. Then he would need to copy that into a new worksheet in the
same spreadsheet.. I am used to MS ACCESS, which is a snap due to tables and
queries that can work inside Access. Worst case scenario, it can be done in
Access and read from the Excel worksheet. But I’d like to see how it can be
done in EXCELL. Any Ideas? Since I am not well-versed in EXCELL, you may need
to be specific. I do understand some things though. Thanks in advance.

If row 1 and row 10 met your criteria, would you want the copy to appear in
row 1 and row 10 of the destination sheet or row 1 and 2 of the destination
sheet?
--
Gary''s Studentquot;jacklequot; wrote:

gt; I have a co-worker that would like to make a feature in EXCELL that would
gt; select a non-contiguous series of rows based on a specific character (like a
gt; !) in column. Then he would need to copy that into a new worksheet in the
gt; same spreadsheet.. I am used to MS ACCESS, which is a snap due to tables and
gt; queries that can work inside Access. Worst case scenario, it can be done in
gt; Access and read from the Excel worksheet. But I’d like to see how it can be
gt; done in EXCELL. Any Ideas? Since I am not well-versed in EXCELL, you may need
gt; to be specific. I do understand some things though. Thanks in advance.

i would like old rows 1 amp; 10, etc, to be new rows 1 amp; 2, etc. Hope that
helps, thanks.

quot;Gary''s Studentquot; wrote:

gt; If row 1 and row 10 met your criteria, would you want the copy to appear in
gt; row 1 and row 10 of the destination sheet or row 1 and 2 of the destination
gt; sheet?
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;jacklequot; wrote:
gt;
gt; gt; I have a co-worker that would like to make a feature in EXCELL that would
gt; gt; select a non-contiguous series of rows based on a specific character (like a
gt; gt; !) in column. Then he would need to copy that into a new worksheet in the
gt; gt; same spreadsheet.. I am used to MS ACCESS, which is a snap due to tables and
gt; gt; queries that can work inside Access. Worst case scenario, it can be done in
gt; gt; Access and read from the Excel worksheet. But I’d like to see how it can be
gt; gt; done in EXCELL. Any Ideas? Since I am not well-versed in EXCELL, you may need
gt; gt; to be specific. I do understand some things though. Thanks in advance.

Let's say the column is column A and you want only the rows with a ! in
column A:1. sort the worksheet by column A
This will gather all the rows starting with ! together and still preserve
their relative order.

2. select the row-set of rows starting with ! and copy them. (only a single
copy is needed after you have done the selection)

3. go to the new worksheet and select A1. Then paste.--
Gary''s Studentquot;jacklequot; wrote:

gt; i would like old rows 1 amp; 10, etc, to be new rows 1 amp; 2, etc. Hope that
gt; helps, thanks.
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; If row 1 and row 10 met your criteria, would you want the copy to appear in
gt; gt; row 1 and row 10 of the destination sheet or row 1 and 2 of the destination
gt; gt; sheet?
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; gt;
gt; gt; quot;jacklequot; wrote:
gt; gt;
gt; gt; gt; I have a co-worker that would like to make a feature in EXCELL that would
gt; gt; gt; select a non-contiguous series of rows based on a specific character (like a
gt; gt; gt; !) in column. Then he would need to copy that into a new worksheet in the
gt; gt; gt; same spreadsheet.. I am used to MS ACCESS, which is a snap due to tables and
gt; gt; gt; queries that can work inside Access. Worst case scenario, it can be done in
gt; gt; gt; Access and read from the Excel worksheet. But I’d like to see how it can be
gt; gt; gt; done in EXCELL. Any Ideas? Since I am not well-versed in EXCELL, you may need
gt; gt; gt; to be specific. I do understand some things though. Thanks in advance.