How to paste data in filtered list of Microsoft Excel
I am trying to copy data from an unfiltered list and paste it into a filtered list. I want the data to be pasted into the filtered rows only but they are pasted into the hidden rows as well. Is there a function I can use to get the data pasted into the filtered rows only?
Re: How to paste data in filtered list of Microsoft Excel
When you paste, the data is pasted in to a contiguous range, even if the sheet is filtered. Perhaps you could use a new column to mark the filtered rows, unfilter, sort on the new column, and paste into the marked rows.
Re: How to paste data in filtered list of Microsoft Excel
I don't think that there's anything more straight forward for doing it manually. If your cell names: designationmateriel, findesignationmateriel, designationrapport I do not exist either. And in fact what is not working exactly. You know you can also make your copy with a Sheets ("rapportjournalier"). Range ("designationrapport"). Value = Sheets ("monitoring equipment"). Range ("designationmateriel"). Value This possibly in a loop. This will prevent selects