In this video you will learn how to transfer customer wise data from one sheet to another without Macro and VBA.
It is setup with simple excel functions - If Function, Vlookup etc.

Important:
There was a mistake in this video. I forgot to fix the cell references inside Small Function used in B2 cell.
The right formula is:
=IFERROR(SMALL($A$2:$A$110,ROWS($B$2:B2)),"")

The file which will be downloaded using link, is correct.

If you find the video valuable please subscribe our channel:
https://youtube.com/c/PowerExbyJitendra

You can download this workbook by clicking on below link:
----------------------------------------------------
https://docs.google.com/spreadsheets/d/1VNLU6PkuJLZ18stJBgUYDKZ6rgaQhvq6/edit?usp=sharing&ouid=113701258532828197942&rtpof=true&sd=true
---------------------------------------------------
Related Videos:
1. IF Function
https://youtu.be/8weMXkWkLY0

2. IF Function with multiple conditions
https://youtu.be/JysD-y_E0MA

3. Vlookup
https://youtu.be/I_33jLRvqmQ

4. Vlookup with Match Function
https://youtu.be/54mWSjpZNdg

Other Videos on Data Transfer
1. Transfer Data From One Sheet to Multiple Sheets Automatically
https://youtu.be/BgSkUpqBun0
2. Transfer Data From One Sheet to Multiple Sheets (Other Way)
https://youtu.be/tDLQBTcHEvs
3. How to Automatically Transfer Data from one sheet to another
https://youtu.be/FQCal17qHZg

Playlists of our top videos:
1. Stock Management System in Excel
https://youtube.com/playlist?list=PLBy4kMPmMt7QWl0YvOQumw4A730f36qAV

2. Advanced Excel Formulas
https://youtube.com/playlist?list=PLBy4kMPmMt7TI0y3zNNVYqc-y0JfFjwgg

-----------------------------------------------------------
Gear I Recommend:
-----------------------------------------------------
1. Mice: https://amzn.to/3I2stPd
2. Mobile Tripod Mount: https://amzn.to/33gR8kh
3. Gurilla Tripod: https://amzn.to/3FqwsmT
4. https://amzn.to/3npWu3C
5. Tripod: https://amzn.to/3I4P3GV
6. Wireless Bluetooth Headphone: https://amzn.to/3K8XUcl


Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.

#excel
#powerxbyjitendra
#datatransfer

Subscribe on Telegram:
https://t.me/powerexbyjitendra

Contact Us:
Instagram: https://instagram.com/kumarjitendra11?igshid=zd7v216sfxr7

Facebook : https://www.facebook.com/PowerEx-by-Jitendra-108422660912839/

Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.

Fair use is a permitted by copyright statute that might otherwise be infringing.

Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks