I cannot begin to thank you enough for this. I had THOUSANDS of filtered cells I needed to copy and paste for work. This would have taken me FOREVER! Your instructions and video were very clear and easy to follow. i appreciate you r skills!
I have been searching the answer to this question for so long. all the rest videos are showing how to paste in a new sheet. I am so frustrated, until I finally find this video, which gives us a great trick on how to paste in a filtered column. This is great! This is so helpful! Thank you very much for your knowledge and thank you so much for sharing!!!!
Hello. I just downloaded the trail version of Paste Buddy....and I copied a sequential column of 255 visible cells located on one tab of my workbook --- and then I pasted this sequential data into another tab within my same workbook, into 255 filtered, but visible blank cells using the Paste Buddy Add-in....and it appeared that my Excel Program locked-up and crashed, but after about 30 seconds, my required data appeared in the 255 filtered, but visible cells! Wow! What a relief! Great Job with this handy Excel add-in!
Thanks alot. I have used the first trick of Ctrl and Enter to populate the visible cells then removed the filter and copied the whole column with formulas and pasted only values all over the same column and it worked fine!
If you have an issue "pasting" in a visible range from another sheet when you have hidden rows, this is the easiest solution I've found: See if you can remove the filter and instead, sort your data in a way that you see the cells you want to see on the top of the page; then also sort your source sheet similar to the first sheet. Now you don't need to paste in the visible range. You just paste in the sorted area where needed.
Does that work on a diff sheet? Instead of copy and paste on the same sheet, I want to copy only visible cells and paste to only visible cells on another sheet.
Try to copy& paste the data from the other xls to seperate sheet of your excel file where wanna operate ... now copy the data in sheet and paste in the required cells.
Great video! Is there a way to do this without downloading the macro? Not sure if I'm allowed to download anything at work, unfortunately. Also, any tips for autofill with hidden rows? For example I filter what I need to have and want to put in 999 into the first viewable cell. Dragging down to autofill that same number 999 into the below viewable cells. When I unfiltered and unhide the table, the numbers are pasted into the previous hidden cells. Thanks again.
Hi, not sure if you still need the answer or not. I have just tested your question. it works as below: 1. filter as you want. 2. select the cells that you want to enter 999, make it visible only selecting with the alt+; 3. enter now with your keyboard 999 or anything you want . 4. now, press ctr+enter you get all the selected visible cells with 999
Hey Jon. Thank you very much for this procedure. I was really getting confused. But, I resolved my concern by helping on some areas of this video. Thank You.. :)
Hi Jon - I'm on a Mac and i'm trying to copy a column that's using a filter and pasting the information into another workbook. The new workbook has the same rows but with a filter that's hiding some rows of data. It doesn't seem to work on a mac.
But when I tried to remove content from source column then our target column get 0 value. Can you guide me how to keep target value as it is? Here target column and source column filtered. I want to do in filtered column.
Instead of purchasing paste buddy, you could use the cell reference ctrl + enter solution shown first, then copy the entire column where your paste destination is, and then use a special paste to paste the values over the cell references. Kind of confusing because you are copying and pasting over the same column, making sure to paste values.
I tried the formula option, but it doesn't work in a Table. It automatically added the formula to all the cells in the column. Do you know if there's a way to work around that with Tables?
Great question Chris! YES, you can paste over the range you want to copy. And you can choose "Values" from the Paste Type drop-down menu to just paste the values. For those that aren't familiar with the term "hard code filtered formula data", this means that Chris wants to take a range of cells that contains hidden rows, and replace the formulas in the cells with the result of the formula (values). This would be the same as copying and pasting values, and the Paste Visible add-in allows you to do this on a range that contains hidden rows or columns. Thanks Chris!
2021, I need to copy data ( updated report ) from one sheet to the main sheet while having the filter on in both the sheets. Is there a way I can do in this age without installing any addon. Ms office 2016
Does the add-in not work for excel for Mac? I downloaded it and tried to install it but I get a "microsoft visual basic" error - and when I search the Add-in on the store it does not show up. Pls help - this would make my job so much easier! Thanks :)
Hi Jon, I appreciate your support, thank you. I have an other question: How do we Copy visible values only. Lets say I have formatted the cell just to see two decimal places. When I use it in CONCATENATE function it pulls the whole number. I just want it to be collected with two decimals. Thank you..
I cannot begin to thank you enough for this. I had THOUSANDS of filtered cells I needed to copy and paste for work. This would have taken me FOREVER! Your instructions and video were very clear and easy to follow. i appreciate you r skills!
I have been searching the answer to this question for so long. all the rest videos are showing how to paste in a new sheet. I am so frustrated, until I finally find this video, which gives us a great trick on how to paste in a filtered column. This is great! This is so helpful! Thank you very much for your knowledge and thank you so much for sharing!!!!
Glad it was helpful, Fiona! 😀
Paste buddy is a life saver. I had data running into 1800 values which I needed to copy into filtered cells. Thank you.
Brilliant - absolultely brilliant! I have been trying to get this for ages and no other video to date has helped, thank you so much for sharing this
Thank you for your feedback, Alistair! 😀
Hello. I just downloaded the trail version of Paste Buddy....and I copied a sequential column of 255 visible cells located on one tab of my workbook --- and then I pasted this sequential data into another tab within my same workbook, into 255 filtered, but visible blank cells using the Paste Buddy Add-in....and it appeared that my Excel Program locked-up and crashed, but after about 30 seconds, my required data appeared in the 255 filtered, but visible cells! Wow! What a relief! Great Job with this handy Excel add-in!
I was looking exactly for this in the last 5 hours. Thanks a lot.
If visible cell trick not working try this trick its 100% working th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
BHAI BHAI .....EK NUMBER.... SOLVED MY PROBLEM
finally, i found this video who trully needed the most. ty sir
Dude - You are THE MAN! Thanks for sharing this.
Of all the videos I looked for for this issue, this was is simply the best !! Thanks so much :)
I will try it tmr. I have been working for 5yrs but every time I struggle with this issue. Hope paste buddy can save my time.
Thanks for Paste buddy, you are a life saver
Thank you so much. You are the saviour.
YOU ARE A LIFESAVER!! THANKS SO MUCH
What are we accountant going to do without guys like you who makes our job super fast!
You are on my christmas card list i have been trying to do this for ages thanks
your video is so helpful for people
It saved me a lot of time. Thank you 🙏
Glad it helped, V P! 😀
2023 and I’m still looking for this. Thank you 🙏
Thank you so so much sir ! You made my life easy. More power to you :)
Happy to help! 😀
This is super useful and it worked for me , thank you
Glad it helped 😀
Fantastic. You made my job easy.
Thank you so much for sharing. This makes my life much easier
Thanks a lot very helpful 👍
wow this has really really helped! thanks for the excel tool mate. Keep up the great work
Thank you so much - this has totally made my life easy!
great 👍 and thanks for your help.
Thanks alot. I have used the first trick of Ctrl and Enter to populate the visible cells then removed the filter and copied the whole column with formulas and pasted only values all over the same column and it worked fine!
If visible cell trick not working try this trick its 100% working th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
If you have an issue "pasting" in a visible range from another sheet when you have hidden rows, this is the easiest solution I've found:
See if you can remove the filter and instead, sort your data in a way that you see the cells you want to see on the top of the page; then also sort your source sheet similar to the first sheet.
Now you don't need to paste in the visible range. You just paste in the sorted area where needed.
Try this trick its really helps u and thanks me later
th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
Yes! Good suggestion, exactly what I do. Why has MSoft never offer a better solution like ctrl-paste maybe...
great! demo version perfectly worked! thank you. guess i ll pay this to have forever.
Only feedback here, that d've been a bit faster though.. It takes long time on pasting..
good tips, thank you so much =))
Thank you so much !! Your trick helped me save countless hours of work
If visible cell trick not working try this trick its 100% working th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
Exactly solved my problem !!
Super Jon thanks a million!
Very helpful indeed.
still a helpful video on 2020! Thank you!
Does that work on a diff sheet? Instead of copy and paste on the same sheet, I want to copy only visible cells and paste to only visible cells on another sheet.
Try to copy& paste the data from the other xls to seperate sheet of your excel file where wanna operate ... now copy the data in sheet and paste in the required cells.
Try this tutorial
th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
Lifesaver, thanks man!
Finally, great solution thanks
Awesome tricks that save time. Thanks for the tips.
Thomas Garcia Thanks Thomas!
THANK YOU SO MUCH
GREAT SIR!!!
Thanks Gan.. Working !!
You saved my lifeeeeee
Great video !!
Thanks Mike!
Thanks Jon It safe my life , Super!
Jon, how can I do the opposite, i.e. copying from a non filtered row to a filtered, visible row of cells? I have been looking EVERYWHERE and nothing.
2Deeelite4 nice question. I will definitely try to find out answer of your question. Please me give some time.
I need this as well, have you found anything to help?
Exactly. This is a key MISSING function in excel.
I need this feature, too - how do I do this??
Did you find anything on this? I need to do the same and haven't been able to find anything online
Very nice.. Thank you! :-)
Great video Jon. Very useful.
Thanks Christopher!
Great video! Is there a way to do this without downloading the macro? Not sure if I'm allowed to download anything at work, unfortunately.
Also, any tips for autofill with hidden rows? For example I filter what I need to have and want to put in 999 into the first viewable cell. Dragging down to autofill that same number 999 into the below viewable cells. When I unfiltered and unhide the table, the numbers are pasted into the previous hidden cells.
Thanks again.
Hi, not sure if you still need the answer or not. I have just tested your question. it works as below:
1. filter as you want.
2. select the cells that you want to enter 999, make it visible only selecting with the alt+;
3. enter now with your keyboard 999 or anything you want .
4. now, press ctr+enter
you get all the selected visible cells with 999
Hey Jon. Thank you very much for this procedure. I was really getting confused. But, I resolved my concern by helping on some areas of this video. Thank You.. :)
If visible cell trick not working try this trick its 100% working th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
Does this work also on MAC?
Very nice and useful video
Wow nice 👍
Hi Jon - I'm on a Mac and i'm trying to copy a column that's using a filter and pasting the information into another workbook. The new workbook has the same rows but with a filter that's hiding some rows of data. It doesn't seem to work on a mac.
I was looking for this. Very helpful. Thank you
Awesome.....fabulous tips. keep up the good work.
Thankyou so much sir
Thanks a lot !
THANK U VERY MUCH SIR.
Super, Thank you very much...
Thanks a lot bro
Very helpful and insightful. Thank you Jon 😊
is there anyway I can paste in filtered cells without download anything
Nopeeee... It's a easy and convenient way what he suggested... It worked for me.. saved my time... Try it
Thanks a lot.
it works
Thank you VERY much!!!
Good solution. I think Paste, Special, Skip blanks would be another effective solution too. You have to select the right number of destination cells.
Hi, I am on a work computer so I cannot download add ins. Any other solution you can provide as opposed to pasting one by one?
Thanks a lot.. this really works
Thank you VERY much, it saved me lots of trouble!
Thank you so much!!!
I love you for this
Can I just purchase paste buddy separately? I don't need the whole suite.
Thumbs up for the Atl + ; shortcut
thanks for the video!
it works, how do I pay and install the full version? Thanks
faaaantastic! Thank you!
Awesome!!! Useful and thankyou!!!
But when I tried to remove content from source column then our target column get 0 value. Can you guide me how to keep target value as it is? Here target column and source column filtered. I want to do in filtered column.
Thanks :) great time saver
wonderful .. very helpful
Fantastic!
Instead of purchasing paste buddy, you could use the cell reference ctrl + enter solution shown first, then copy the entire column where your paste destination is, and then use a special paste to paste the values over the cell references. Kind of confusing because you are copying and pasting over the same column, making sure to paste values.
thank you so much
Excellent... Sir
I tried the formula option, but it doesn't work in a Table. It automatically added the formula to all the cells in the column. Do you know if there's a way to work around that with Tables?
Yes! In this tutorial have way to doing the same please watch and thanks me later
th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
Can you paste on top of what you are copying? I often want to hard code filtered formula data on the fly. Very cool feature add!
Great question Chris! YES, you can paste over the range you want to copy. And you can choose "Values" from the Paste Type drop-down menu to just paste the values. For those that aren't familiar with the term "hard code filtered formula data", this means that Chris wants to take a range of cells that contains hidden rows, and replace the formulas in the cells with the result of the formula (values). This would be the same as copying and pasting values, and the Paste Visible add-in allows you to do this on a range that contains hidden rows or columns. Thanks Chris!
Dear,
Your video is cool.
But I dont know how to take paste visible item?
Could you please help to instruct me?
Thank you
Perfect! Thanks, bro
Great Master, Thank you Very Much, I love you
Yaseen Mohammed Thanks Yaseen!
Thanks.. what if I had to paste from notepad
How about the reverse step ? Please help
2021, I need to copy data ( updated report ) from one sheet to the main sheet while having the filter on in both the sheets. Is there a way I can do in this age without installing any addon. Ms office 2016
Genius! Thx!!
Question, do u know if u can pasta new data overtop a formula within excel
Meaning if cell 1/row 1 is blank copy paste cell2/ row2 if not do nothing
Try this tutorial and thanks me later
th-cam.com/video/3yyoXWh6JbU/w-d-xo.html
Thanksssssss alotttt man
thank you man!
Does the add-in not work for excel for Mac? I downloaded it and tried to install it but I get a "microsoft visual basic" error - and when I search the Add-in on the store it does not show up. Pls help - this would make my job so much easier! Thanks :)
Hi Jon, I appreciate your support, thank you.
I have an other question: How do we Copy visible values only. Lets say I have formatted the cell just to see two decimal places. When I use it in CONCATENATE function it pulls the whole number. I just want it to be collected with two decimals.
Thank you..
you can format the destination cells in a way that they reflect decimal value.
@@snjpverma That makes sense, thank you bro
But you know that is not a number anymore I presume a text, so that would not function. I will check it anyway
I tried to copy cells from a different workbook sheet and it didn't work. It works only why you copy from the same sheet.