Thread: How to copy information from one worksheet to other dynamically

Hi

There is some data in Sheet1 such as: Name, Mobile No., E-Mail..etc. I want those information of one or more columns to be copied into Sheet2 such a way that, whenever a new row is created in Sheet1, it will automatically reflect in Sheet2. Also, number of rows with data in those in Sheet1 should reflect in Sheet2. The rows in Sheet2 should be dynamic, i.e., whenever it finds a blank cell, it will stop creating new row.

I want to do this preferably without using macro (if it is possible).

I have attached a file for your perusal.

Your help in this regard would be much appreciated.

Thanks in advance,

Sharful.