How to Search and Copy rows in excel | VBA | English

Показать описание

This video shows how to search and copy data from one sheet to another using VBA based on a particular criteria.

Helpful video :

Buttons in Excel :

Hints for coding :

k = 5 ; Row number on Sheet 2 from where we start to paste the copied data.

i = 3 to 22 ; Row numbers on Sheet 1 where data is present.

x ; Reads the customer id on cells ( variable row from loop , column 2 ).

k = k + 1 ; To increment the row on Sheet 2

********************************************************************

Learn the techniques to work faster 🏃‍♂️without having to remember 🧠 formulas, with the use of macros! - ABSOLUTELY FREE !

Join my Excel Automation Bootcamp to:
✅ Make your excel sheets more *attractive and interactive*
✅ Get results on a *single button click*?
✅ Reduce your time spent on excel sheets by *70%*

Join the Excel Automation Bootcamp :