Pasting to a filtered list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of data which is a sub-set of a larger data set in a separate workbook. I would like to paste into the main dataset a set of values from this sub-set. I filter the main data set to get the sub-set and click copy on the sub-set and then go to the workbook with the filtered list in and click paste ... I only get the first line? Any solutions?
 
Be careful.

What do you see if you show all your data in that filtered range.

I think xl will paste into those hidden rows, too. Might not be what you had in
mind.
 
Back
Top