Sep 28 2022 02:55 AM
I want to copy values from a particular column in an excel file and paste it in another file in a particular column where I have excluded some rows by means of filtering. However when I paste the values, the values get pasted in the rows that are hidden. I checked extensively in the net to find a solution for it, but I didn't get any direct solution but only work arounds. I understand that there is a third party vendor (Kutools) who has solution for it, but I am looking for a solution from Microsoft.
Sep 28 2022 04:17 AM
See this reply for a macro that will do what you want.
Oct 09 2022 03:32 AM
Oct 09 2022 03:56 AM
I suspect that you haven't actually tried that macro. I have tested it and it does exactly what you want.
Oct 09 2022 06:28 AM
Oct 09 2022 06:48 AM
Oct 09 2022 06:51 AM
From within Excel: select File > Feedback and click Send a Suggestion.
And you could add your vote to Ability to paste to filtered (visible) cells on the Excel Feedback Portal.
Oct 09 2022 07:10 AM
Oct 09 2022 07:34 AM
Oct 09 2022 07:43 AM
You might store the macro in a module in your Personal Macro Workbook PERSONAL.XLSB.
It will then be available in all workbooks.