Adding Rows in a sheet, each row with lookup information from another sheet

**htariq12** · 10-10-2009, 07:52 AM

Please Help

Sheet2 includes only some clients who have email
Column A of Sheet 2 includes client code
Column B of Sheet 2 includes Client Email Address,

Sheet 1 includes all the information of clients except email address.

Column A of Sheet 1 includes the client code

Other columns includes other information
For some clients 2 rows are used and for some clients 4 or 5 rows are used

There are about 10,000 clients.

Is there an easy way to

1) add a row for each client easily
2) the added row picks up information from column B of Sheet2

**royUK** · 10-10-2009, 08:04 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**htariq12** · 10-10-2009, 08:58 AM

Dear Roy,

Thanks for your advice, i have attached the file.

Is it possilbe for a macro to add a new row in Sheet 1 for every customer who have email addresss. This email address to be looked up from Sheet 2

**royUK** · 10-10-2009, 11:17 AM

I would suggest that yo have your data ine one row per name, it would be much easier

**htariq12** · 10-12-2009, 03:47 AM

Dear Roy,

The original file contains lots of columns and priniting size limitations do not allow to add more columns. therefore we want to add 1 row for cutomers who have given additional info.

Please please help!