Excel help needed

dowex

New Member
Joined
Sep 14, 2009
Messages
5
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
 
Last edited:

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,212,934
Messages
6,110,760
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top