Carry Forward New YTD Values On A Reconciliation

[picton2000]

Hello,

On the attached file, I have employee base detail highlighted in grey on the New Period sheet.
I want this base detail copied to the "New YTD" sheet, showing new values for each wage type.
The new value will be the value on the "YTD" sheet added to the value on the "New Period" sheet.

The base detail has to be taken from the "New Period" sheet because it has our most up to date list of employees with their current location, pay section etc.
The number of rows on New Period and YTD will be variable on each payroll.

Can someone advise some marco code that will create the "New YTD" sheet with the new values for each wage type.

Just so you can see the end result I am looking for, I have created a sheet called "Outcome" which would be the successful end result based on the attached example file.

Thanks for any help you can give me.

Jonathan.

[PCI]

Thank you for the file attached it is very clear
Is the "Employee number" enough to search for an employee
When an employee exists in "YTD" but nor anymore in "New Period" do you want to copy this record in "New YTD"

[picton2000]

Yes I would want them copied forward.

New employees in New Period always get added in, but employees leaving the company do not get taken off as it is a reconciliation of the whole tax year.

We only start with a completely new population of employees in period 1 of a new tax year.

[PCI]

A first run, please comment
Tab "New YTD" is deleted each time the macro is run

Please Login or Register  to view this content.

[PCI]

See here another run with copy of the records from YTD when not seen in New Period

Please Login or Register  to view this content.

[picton2000]

Hello PCI.

The code you have given is excellent and does exactly what I require.

I have added a positive comment on your "Add Rputation".
This has saved me a great deal of time.

Thank you very much
Jonathan Williams

[PCI]

Thank you Jonathan for the information back, the real achievement when helping people is to see that we have done is not lost and it helps.
Patrick