🚀 Exciting update! If you're looking to streamline your Excel tasks even further, check out my new video on automating the 'Paste into Visible Cells Only' process using VBA. It's a great way to enhance your skills and save time! Watch it here: kzitem.info/news/bejne/raulqIqPfqCCeqQ. Enjoy and let me know what you think!
@waltershayo5448
Жыл бұрын
How do i copy from filtered range and pasting to filtered range?
@southafricantruecrimes1537
10 ай бұрын
Thanks for such an easy to understand video
@realmehranvahedi
10 ай бұрын
You're very welcome. I'm happy that you found the video useful!
@mudassirahmedi5617
Ай бұрын
I am trying to paste from another sheet and it showing error , the paste area and copy area are not matching
@realmehranvahedi
Ай бұрын
Hello @mudassirahmedi5617, Thanks for reaching out with your question! It sounds like you’re encountering a common issue where the copy and paste areas do not match. I've covered solutions to this problem in my recent videos. Particularly, in my latest video posted two weeks ago, I demonstrate how to handle this using VBA. You can find it here: kzitem.info/news/bejne/raulqIqPfqCCeqQ If you prefer not to use VBA, these two videos should help clarify and provide alternative solutions: Video 1: kzitem.info/news/bejne/yXlnqIVrk6V8iqw Video 2: kzitem.info/news/bejne/pWiurH2emoNmaaw I’m confident these videos will help resolve the error you're experiencing. Please let me know how it goes! And don’t hesitate to post any other questions or comments you might have, whether it's about this issue or any other topic. Your feedback is invaluable and helps improve our community. Cheers, Mehran
@realmehranvahedi
8 ай бұрын
Dear awesome viewers! Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!
@rickstevens1052
7 ай бұрын
I am trying to paste a number of rows to a spreadsheet with hidden rows. How can I paste the copied cells to ONLY those rows that are showing, avoiding anything copying to the hidden rows?
@realmehranvahedi
7 ай бұрын
Hello and thanks for the comment. Perhaps my latest video on this topic will answer your question. Please check it out via the following link and feel free to post any other questions you have on this and/or other topics. kzitem.info/news/bejne/yXlnqIVrk6V8iqwsi=hkfdwaovKnkrk-Pe
@Mcfine2011
6 ай бұрын
It's easy to make them blank when you have about 4 rows, but when have 100 it's difficult. I wish this video showed how to copy values from filtered rows into another column with filtered rows. So basically what you showed but without putting the other values in blank
@realmehranvahedi
6 ай бұрын
Hello and thank you for the comment. I encourage you to watch my two more recent videos on the topic. I believe they contain the answer to your question. Thanks again! kzitem.info/news/bejne/pWiurH2emoNmaaw kzitem.info/news/bejne/yXlnqIVrk6V8iqw
@markjaysonalvarez2568
4 ай бұрын
How to paste on a hidden rows ? When you paste a data on the file with the hidden rows the data will paste on the hidden rows as well and not on the visible cells only
@realmehranvahedi
4 ай бұрын
Hello! Thank you for reaching out and sharing your question. I appreciate your engagement with my content. I'd like to invite you to check out my two more recent videos on "pasting into visible cells only." I believe they contain valuable insights that could help address your question. Many other viewers have found solutions to their queries through these videos. Feel free to watch them in full and don't hesitate to post any further questions or comments. Here are the links: kzitem.info/news/bejne/yXlnqIVrk6V8iqw kzitem.info/news/bejne/pWiurH2emoNmaaw I hope you find the information helpful! Let me know if there's anything else I can assist you with. Warm regards, Mehran
@Louis-gh1ni
Жыл бұрын
What if you have hundreds of rows that you do not want to delete - and you copy the visible cells only - then how can you paste them into only visible rows when you cannot use the skip blanks feature?
@realmehranvahedi
Жыл бұрын
Hello Louis, thank you so much for bringing up this interesting question. I have the solution and I am creating a brand new video to address the issue which you brought up. I will share the link with you by tomorrow this time. Thanks again!
@realmehranvahedi
Жыл бұрын
Hello Louis, as promised I created a new video to address the issue which you brought up. In this video tutorial which I just published (link provided below) I explain how to copy and paste into hidden cells without needing to delete any values and without using the skip blanks feature. This method is particularly useful if you have hundreds, thousands or even more rows. Please check it out and share your thoughts. Let me know if you have any other questions or comments : kzitem.info/news/bejne/pWiurH2emoNmaaw
@Simon_PieMan
2 жыл бұрын
How would I copy A and B over 1 and 7 ?
@realmehranvahedi
Жыл бұрын
Hello Si, thanks for leaving a comment. Hide rows 4,5,6,7 and 8. Then perform the same copy paste procedure that I explain in the video. This way you will successfully replace 1 and 7 with A and B. I hope this answers your questions. Thanks again for leaving a comment. Feel free to leave other comments and ask any questions which you have.
@RahulChauhan-zh9wq
Жыл бұрын
JAISE APNE FIRST STEP MAI HIDE ROWS K DATA KO ABCD WALE DATA MAI PASTE KRKE DIKAHAYA WAISE HI AGAR ABCD DATA KO HIDE ROWS K NUMBER K SIDE MAI PASTE KRNA HO TOH KAISE KRENGE BINA KUCH DLEETE KIYE
Пікірлер: 20