How to paste filtered cell in excel
Hi,
Des anyone know how to paste in excel to the column where filter is active ? I try to paste but the data seems not matching
Des anyone know how to paste in excel to the column where filter is active ? I try to paste but the data seems not matching
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
1) Do you want to manually paste data to a filtered column ?
2) Do you want to paste data via VBA
In case of 1) Why would you want to paste data in a column where the filter is active ??? it is not common practice as you may mess some other data that you don't see and that is hidden best would be to clear the filter paste your data where you want.
In case of 2) you will need to supply more details as to what need to be pasted and where and it can be done safely thru VBA.
gowflow