Copy Selection

J

jackle

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.
 
G

Gary''s Student

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?
 
J

jackle

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

Gary''s Student

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.
 
Top