Pasting Into Filtered Data

I don't think you can do what you're suggesting. Maybe with some VBA programming, but that's out of my ability. The filter just displays the cells that meet a given criteria. All the other non-visible rows are still there, just hidden. So, any copy, paste, etc. affects the hidden rows as well.

You could add a column to your spreadsheet that checks each row to see if there is a match for your filtered criteria and then the formula would display "Match" or "1" or something that shows it's a match. Then you could sort on the new column and that would collect all of your desired records together so you could copy/paste etc. without having hidden, intervening records. Kind of a clumsy workaround, but maybe better than nothing.

OK - Attached is a sample spreadsheet that has a list of car make, model and year. There is also a section of the criteria of the cars I am looking for. In this case the Ford Explorer. Using a simple AND formula, the Match Column reports back either TRUE or FALSE if there's a match. As you can see there are two matches. Simply sort the list by the Match Column and the two Ford Explorers will float to the top and you can copy or paste data into the list.

Hope this helps. If this isn't what you were looking for, I suggest you post your spreadsheet to this thread and we can take a closer look.

Unsorting:

1. Use the Undo button (the little curved arrow pointing to the left at the upper left hand corner of the spreadsheet.
2. Hopefully you have previously saved your data to a backup file (if not - that is a good practice to start - otherwise you risk losing 'months of work')
3. How was the data ordered originally? Can you resort the data on that field?

Oh, and one other method to unsort - Just don't save the worksheet. Reopen the sheet you started with today. You've only lost whatever work you did today.

Sure, you can message me.