Excel help needed

[dowex]

need a detail instruction on a quickway to update or merge 2 sheet

i have a nominal roll of pensioner(10969) which is the old information and i also have a new sheet which contains some new modification to the previous info in the nominal roll . i need to modify and update the old nominal roll . Wat tricks or quick way about it can i go . please help is urgently needed

 

[VoG]

Hello and welcome to MrExcel.

You can use VLOOKUP to look up the data from the new sheet. See http://www.contextures.com/xlFunctions02.html

 

[dowex]

will try that thanks mr excel

 

[dowex]

still didnt help below is wat am tlking about. the nominal roll and an example modification dat needs to b modified on the nominal roll

 

[wsjackman]

Can you give a sample of your current data, the new data and what you want done with it?

 

[dowex]

i can do that am uploadin it now will post the link soon

 

[dowex]

http://www.mediafire.com/?0kqtrtmbmm2

dis is d link of the excel dat i need solution on d first sheet named nominal is d old one dat needs to b updated while the oda sheets are d new data altered dat needs to b updated in d old nominal roll

 

[wsjackman]

first I assume that the employee numbers are unique each individual has just one employee number and that each employee number refers to just one individual


there are many ways to do the update

this is what I would do

go to the nominal sheet in ab2 enter 1 and copy down to the bottom of the data
in each adjacent sheet got to ab2 and enter 2 in the first sheet 3 in the second sheet 4 in the next sheet etc and on each sheet copy this number down to the bottom of the data.

then copy all the data on the second sheet and paste it on the nominal sheet under the last row with data
repeat with the third sheet, fourth sheet etc until all the data is on the nominal sheet

sort the nominal sheet using column B for the first sort criteria and column AB for the second criteria

I woul dthern look to see if there were more than one update for any given employee number

goto AC2 and enter

=countif(B:B,b2)
copy and paste down to the bottom of the data.
look for anything greater than 2 and resolve which data needs to be the current

after this is resolved

in AC2 enter
=if(or(b1=B2,b2=b3),1,"")
copy to end of data
filter AC:AC and select 1

I would look at each pair of rows and verify they were truely duplicates except for the data you want updated.

I would then further filter both AB:AC for 1 in both columns
delete visible rows


you should now have an updated nominal sheet.