If you want to copy filtered sheet data and paste to another filtered sheet, it is not possible to paste exactly as we want to paste in our another data sheet, so in the below video i have explained the solution to copy paste filtered sheet date to another sheet by merging the cells and apply Vlookup formula on the basis of helper column, watch the video to learn properly and download the practice file from the download button given below.
Formula i have applied:
=VLOOKUP(A2,Sheet1!A:E,5,0)
Video Tutorial
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
