Excel VBA quck project

Hi, I have a quick assignment for somebody.

At the moment I have to manually update/remove names in who are on the payroll each month for new joiner, leavers and change of details. Would be good if could build a macro which updates the main spreadsheet from 2 different tabs, new joiners and leavers.

1)So firstly from the "New joiners" tab of [url removed, login to view] spreadsheet it would type over any vacancy row, matching reference number in column. If the reference number is another employee number then insert a new line under the old employee in the correct department (as id can be reported more than once). If there is no reference it means they are not replacing anyone and so a new line is inserted for them under the current department.

When a new line is inserted for new employee (either replacing old employee or brand new), the way to do it is copy and paste/insert the row above and put in their new id number, the formulas will update every other field automatically.

However there is one other thing it needs to do. Based on the new joiners start date and end date it needs to put 1's in column e-g. from the month of start date to the month end date (if no end date all year).

Before doing this paste the data from [url removed, login to view] into the New Joiners Tab and Employee Details Tab( this is what updates the formulas

2)The leavers tab of the [url removed, login to view] is slightly easier. Just look up employee number and and put zeroes the month after the month of leave date.

Also paste the correct columns in the leavers tab of Forecast Spreadsheet



Compétences : Excel

Voir plus : look for employee, assignment, what is vba in excel, what is vba, what is macro in excel, vba for, excel vba or, excel vba and, end vba, vacancy vacancy vacancy, vacancy in up, vacancy current, payroll number, new vacancy, new current vacancy, vba excel macro, vba e, vacancy, project on vba, payroll so, Payroll project, Macro vba, macro excel, macro e, macro + excel

Concernant l'employeur :
( 5 commentaires ) London, United Kingdom

N° du projet : #1656817

Décerné à :


Hi, I can imagine what you need, shall we start?

30 $ USD en 1 jour
(94 Commentaires)

22 freelance font une offre moyenne de $54 pour ce travail


Hello, Excel VBA expert ready to start. Please check PM for details. Thanks!

70 $ USD en 2 jours
(60 Commentaires)

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b Plus

70 $ USD en 2 jours
(48 Commentaires)

Excel / VBA pro - ten years of experience.

60 $ USD en 1 jour
(27 Commentaires)

Automation of the data consolidation is one of our main strengths; also in terms of high standard of user interfaces.

60 $ USD en 1 jour
(21 Commentaires)

Hello, I am an Excel VBA expert and can create this program for you. Please see your PMB for details. Thanks, David

75 $ USD en 1 jour
(8 Commentaires)

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at your PMB

30 $ USD en 2 jours
(44 Commentaires)

HI I am confident to handle this

48 $ USD en 1 jour
(11 Commentaires)

[url removed, login to view]

55 $ USD en 1 jour
(10 Commentaires)

VBA Experts are ready to start immediately.

51 $ USD en 2 jours
(3 Commentaires)

Darren, Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includ Plus

60 $ USD en 3 jours
(3 Commentaires)

hi, i can do this job well

30 $ USD en 0 jours
(6 Commentaires)

I have 10+ years of experience in macro programming and please see my details in PM...

30 $ USD en 1 jour
(1 Commentaire)

Hi, I am interested to do this job. I am expert in Ms word, Excel, Powerpoint, Access etc. So you can give me the task. Tank you to see my bid.

70 $ USD en 7 jours
(0 Commentaires)

Pretty easy job. Associate Member of CPA Australia.

30 $ USD en 1 jour
(0 Commentaires)

Dear Sir, I have 10 year professional experience in relevant field so i deeply request for completion your project by me. There is one another reason, i have professional working team. Kindly i inform you aga Plus

200 $ USD en 25 jours
(0 Commentaires)

Hello sir! I'm very interested in this project. Please pm more infomation . Thanks

35 $ USD en 3 jours
(0 Commentaires)

4 years experience in building Macro's that manages Data Analytics, Reconcilation, Data Entry, Data Validations. Solutions delivered include interaction with 3rd Party tools such as PDFCreator, SQL Server, MS Access, M Plus

55 $ USD en 2 jours
(0 Commentaires)

Hi, I understood the requirement. If interested please reply my personal message

30 $ USD en 2 jours
(0 Commentaires)

Hi, easy work and will be deliver in due time.

30 $ USD en 1 jour
(0 Commentaires)

Sir, I am very much interested in the project that you offer. I ready to work so give me a chance thanks.

30 $ USD en 2 jours
(0 Commentaires)