Paste with hidden rows

[krodriguez]

Any trick to paste data only on visible cells where there are hidden rows and don't want to override existing data on the hidden ones.

Example: Sheet 1, you have 10 rows and applied a filter and now only visible rows are 5 and 8, on sheet 2 I copied the original values of rows 5 and 8 and change them now I need to go back and update sheet 1, how do I take these new values and paste them into sheet 1 with the applied filter so my other rows (1,2,3,4,6 and 7) don't change and only rows 5 and 8 get updated. I hope this makes sense

 

[Akuini]

Please check out this article:
Excel VBA: easy way to paste to visible cells

And you can put the code in PERSONAL.xlsb and assign a toolbar button to it. The benefit of doing it this way:
The macro is available on any open workbook & easy to access (i.e. via a toolbar button)
You don’t need to put the macro on all your workbooks, just on PERSONAL.xlsb.

 

[My Aswer Is This]

Please check out this article:
Excel VBA: easy way to paste to visible cells

And you can put the code in PERSONAL.xlsb and assign a toolbar button to it. The benefit of doing it this way:
The macro is available on any open workbook & easy to access (i.e. via a toolbar button)
You don’t need to put the macro on all your workbooks, just on PERSONAL.xlsb.

I agree great ideal. I use the Personal.xlsb often and then assign the script to the Quick assess tool bar QAT. That way the same action can be used on any open workbook.