Formula to merge two worksheets

**mrfisherman2010** · 02-27-2011, 08:45 AM

I need help writing a formula. I am trying to update one worksheet based on a matching column from another worksheet.

Worksheet 1: ecEveryoneElse
The NewUserName column in this worksheet contains the new data. There are 98000 records in this worksheet.

+---------------+---------------+
| A             | B             |
+---------------+---------------+
| UserName      | NewUserName   |	
+---------------+---------------+
| 3282384       |2wsUShrwj45h   |				
| 2293848       |38Ssjdjr423s   |						
| 2047765       |2OSIv0s4i348   |
+---------------+---------------+

Worksheet 2: llo_studentsdemo
The myNewID (B) column in this worksheet needs to be updated when id matches UserName from the other worksheet. There are 133000 records in this worksheet. I need to do this for all records in this worksheet. Also, there are several records with matching id values in this worksheet.

+---------------+---------------+---...
| A             | B             | C
+---------------+---------------+---...
| id            | myNewID       | nextColumn
+---------------+---------------+---...
| 3282384       | (value is 2wsUShrwj45h after query runs)
| 2293848       | (value is 38Ssjdjr423s after query runs)
| 2047765       | (value is 2OSIv0s4i348 after query runs)
+---------------+---------------+---...

Here is what I want to do:

if ecEveryoneElse.UserName = llo_studentsdemo.id
set llo_studentsdemo.myNewID = ecEveryoneElse.NewUserName
end

Any help writing this formula would be very much appreciated.

Thank you.

Mike

**davesexcel** · 02-27-2011, 08:47 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!