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
22 freelance font une offre moyenne de $54 pour ce travail
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
Automation of the data consolidation is one of our main strengths; also in terms of high standard of user interfaces.
Hello, I am an Excel VBA expert and can create this program for you. Please see your PMB for details. Thanks, David
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
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
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.
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
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
Sir, I am very much interested in the project that you offer. I ready to work so give me a chance thanks.