En cours

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

Thanks

Darren

Compétences : Excel

Voir plus : look employee, vba for, end vba, vacancy current, payroll number, new current vacancy, vba excel macro, vba e, vacancy, payroll so, macro vba, macro excel, macro e, insert brand, forecast, excel vba macro, excel macro vba, excel formulas, copy paste names excel, vba excel copy, quick excel, vba update excel, insert macro excel, excel row column, excel macro row

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

N° du projet : #1656817

Décerné à :

danielgpratidya

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

30 $ USD en 1 jour
(94 Commentaires)
6.0

22 freelance ont fait une offre moyenne de 54 $ pour ce travail

bharanisrihari

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

70 $ USD en 2 jours
(60 Commentaires)
6.3
nagybatonyi

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)
5.7
vbexcel

Excel / VBA pro - ten years of experience.

60 $ USD en 1 jour
(27 Commentaires)
5.4
Krusche

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)
5.2
ExcelGurus

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)
4.7
expertatwork

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)
4.6
coolbuddy19

HI I am confident to handle this

48 $ USD en 1 jour
(11 Commentaires)
4.4
Rahul2012

http://www.freelancer.com/users/feedback_1490871.html

55 $ USD en 1 jour
(10 Commentaires)
4.2
shagoon2u

VBA Experts are ready to start immediately.

51 $ USD en 2 jours
(3 Commentaires)
2.9
sumshank

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)
2.4
decato0110

hi, i can do this job well

30 $ USD en 0 jours
(6 Commentaires)
2.1
amaldavid16

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

30 $ USD en 1 jour
(1 Commentaire)
1.0
Debrajmitra

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)
0.0
knizami

Pretty easy job. Associate Member of CPA Australia.

30 $ USD en 1 jour
(0 Commentaires)
0.0
rizwananwar

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)
0.0
linhdt

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

35 $ USD en 3 jours
(0 Commentaires)
0.0
djmiths

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)
0.0
mahircorp

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

30 $ USD en 2 jours
(0 Commentaires)
0.0
OlivierK

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

30 $ USD en 1 jour
(0 Commentaires)
0.0
farjanaparvin

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)
0.0