Đã hoàn thành

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



Kĩ năng: Excel

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) London, United Kingdom

ID dự án: #1656817

Được trao cho:


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

$30 USD trong 1 ngày
(94 Đánh Giá)

22 freelancer đang chào giá trung bình $54 cho công việc này


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

$70 USD trong 2 ngày
(60 Nhận xét)

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 Thêm

$70 USD trong 2 ngày
(48 Nhận xét)

Excel / VBA pro - ten years of experience.

$60 USD trong 1 ngày
(27 Nhận xét)

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

$60 USD trong 1 ngày
(21 Nhận xét)

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

$75 USD trong 1 ngày
(8 Nhận xét)

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 trong 2 ngày
(44 Nhận xét)

HI I am confident to handle this

$48 USD trong 1 ngày
(11 Nhận xét)


$55 USD trong 1 ngày
(10 Nhận xét)

VBA Experts are ready to start immediately.

$51 USD trong 2 ngày
(3 Nhận xét)

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 Thêm

$60 USD trong 3 ngày
(3 Nhận xét)

hi, i can do this job well

$30 USD trong 0 ngày
(6 Nhận xét)

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

$30 USD trong 1 ngày
(1 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)

Pretty easy job. Associate Member of CPA Australia.

$30 USD trong 1 ngày
(0 Nhận xét)

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 Thêm

$200 USD trong 25 ngày
(0 Nhận xét)

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

$35 USD trong 3 ngày
(0 Nhận xét)

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 Thêm

$55 USD trong 2 ngày
(0 Nhận xét)

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

$30 USD trong 2 ngày
(0 Nhận xét)

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

$30 USD trong 1 ngày
(0 Nhận xét)

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

$30 USD trong 2 ngày
(0 Nhận xét)