Hi

I have a file that I filter. Having found the required records, is there a
way to copy one of the columns data into a new column but ensuring the data
gets copied into the same row as the filtered records.

Normally I highlight the column of data for the filtered records
Use GoTo visible cells only
Copy
Select first cell in next column
Paste

The data is pasted from that cell down but doesn't get copied into the
filtered record rows.

Hope this makes sense.

Help!!

When you paste into a filtered range, the pasted data fills up both the visible
cells and the hidden cells.

I try to sort my data so that it's contiguous (based on some key???) and then
paste into that contiguous range. I don't even need to use the filtering. Then
if I need to, I'll resort the data back to its original order.

teach1 wrote:

Hi

I have a file that I filter. Having found the required records, is there a
way to copy one of the columns data into a new column but ensuring the data
gets copied into the same row as the filtered records.

Normally I highlight the column of data for the filtered records
Use GoTo visible cells only
Copy
Select first cell in next column
Paste

The data is pasted from that cell down but doesn't get copied into the
filtered record rows.

Hope this makes sense.

Help!!

--

Dave Peterson

Adding to what Dave Peterson said: if you don't have a column of data that
allows you to get it back into original order easily such as dates or serial
number or some other sequential series, just add a 'helper' column before
sorting and fill it a number series 1,2,3...999. Include that column when
you sort to group, then later you can sort using that column as the 'key' to
get it back into original order.

"teach1" wrote:

Hi

I have a file that I filter. Having found the required records, is there a
way to copy one of the columns data into a new column but ensuring the data
gets copied into the same row as the filtered records.

Normally I highlight the column of data for the filtered records
Use GoTo visible cells only
Copy
Select first cell in next column
Paste

The data is pasted from that cell down but doesn't get copied into the
filtered record rows.

Hope this makes sense.

Help!!

Thanks for your answer. It helps to know that there is no quick fix.



"JLatham" wrote:

Adding to what Dave Peterson said: if you don't have a column of data that
allows you to get it back into original order easily such as dates or serial
number or some other sequential series, just add a 'helper' column before
sorting and fill it a number series 1,2,3...999. Include that column when
you sort to group, then later you can sort using that column as the 'key' to
get it back into original order.

"teach1" wrote:

Hi

I have a file that I filter. Having found the required records, is there a
way to copy one of the columns data into a new column but ensuring the data
gets copied into the same row as the filtered records.

Normally I highlight the column of data for the filtered records
Use GoTo visible cells only
Copy
Select first cell in next column
Paste

The data is pasted from that cell down but doesn't get copied into the
filtered record rows.

Hope this makes sense.

Help!!

Sometimes things fall under the "good and fast" rule:
You can have it good, or you can have it fast, but you cannot have both at
the same time.

"teach1" wrote:

Thanks for your answer. It helps to know that there is no quick fix.



"JLatham" wrote:

Adding to what Dave Peterson said: if you don't have a column of data that
allows you to get it back into original order easily such as dates or serial
number or some other sequential series, just add a 'helper' column before
sorting and fill it a number series 1,2,3...999. Include that column when
you sort to group, then later you can sort using that column as the 'key' to
get it back into original order.

"teach1" wrote:

Hi

I have a file that I filter. Having found the required records, is there a
way to copy one of the columns data into a new column but ensuring the data
gets copied into the same row as the filtered records.

Normally I highlight the column of data for the filtered records
Use GoTo visible cells only
Copy
Select first cell in next column
Paste

The data is pasted from that cell down but doesn't get copied into the
filtered record rows.

Hope this makes sense.

Help!!