...excel workbook that I need some help with. It has 3 worksheets with the front worksheet being a "form" template and the other 2 worksheets containing data. I need some help with VLOOKUP's or a Macro that will fill in some of the cells on the front worksheet using data from the other worksheets. I've tried with my basic VLOOKUP knowledge and think
...will write a Macro for Office that will work on an Apple Mac. It must work on Apple computers with Office for Mac Version 16.16.1 We have an Excel workbook with multiple worksheets. Each worksheet contains several formatted sections. The Macro needs to do the following: 1) Select the worksheet (by worksheet tab name) 2) Select the first individual
...few medium to complex excel macro (depending on your level of Excel Expertise) that needs to be created or modified based on our existing macro. Background: We have two worksheets in a given workbook file. We need to have various "column transpose" and lookups from sheet2 to sheet1. This is an ongoing progject meaning, if we need to add functionality
...have a sheet for payments: person paid, date of payment and ammount.. WHAT I NEED: I want a formula, macro, or other solution to do the following: Go over all events worksheets, check the name of the artist, sum the rate that is set in the event worksheet and then subtract all payments that are made to that person (registered in the payment sheet)
Hello , I want you to split my excel data to individual files(macro or something) Example: lets say there are 100.000 lines in my excel, I want splite them to 10.000 x10 files. But the first lines on each excel will be a specific value.
...details of item and customer in the dialog box at the end of the process. Check 3: New Customers - If a customer in the import data is not yet defined in CUST and Shortname worksheets, it should simply be added to a new column and highlighted in red. Details should show in the dialog box at the end of the process. Successful Import: At the end of the
I already have a spreadsheet with dashboard and user forms and worksheets for Stock In, stock Out, Returns etc but need to get more customization to dashboard, userforms and create extra reports and invoicing based on current spreadsheet. New reports will (1)create a report for stock levels on a certain date which can be selected and name the sheet
We are seeking to engage a talented illustrator to design a range of teaching aids to teach music to primary age children, specifically 4-6 years old. We prefer a style that is unique, (not so computer animated) possibly hand drawn or painted. There will be some graphic design in creating the overall style of the resources, plus illustrating the characters
Non-profit business needs spreadsheet to track weekly contributions that will link to Annual total page for each parishioner. Also, spreadsheet needs Master worksheet th...link to Annual total page for each parishioner. Also, spreadsheet needs Master worksheet that allows the addition of names that will automatically update each subsequent worksheets.
...Converse with our fulfillment company in Chinese on feedback from customer service as well as follow up on delivery status of incoming inventory. Tools used are: - excel worksheets (google excel) - our inventory system - [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] for communications Training
...infrastructure for the whole process and documentation along side with me. From Sourcing design ideas to Design to Uploading and Writing seo Descriptions. The process should be documented in Standard operation Procedures And should be accompanied with worksheets for our freelancers to work in. We will be using Google Docs for all written documentation
have taugh...for over 2 years and have experience tutoring at the college level from College Algebra through Calculus. As a teacher, I have experience writing and editing mathematics worksheets, tests, and quizzes. I love math and have a great attention to detail. It is a matter of personal pride that all of my work is done to very best of my ability.
...need to be: 1) Good at making eyecatching powerpoint ppts 2) Willing to learn and understand the video content and make a ppt from it. 3) Have ability to create handouts, worksheets and activities from the video content 4) Have excellent English verbal and written skills As you look at the material we expect you to put the key points on the slides and
We have a video ...need to be: 1) Good at making eyecatching powerpoint ppts 2) Willing to learn and understand the video content and make a ppt from it. 3) Have ability to create handouts, worksheets and activities from the video content 4) Have excellent English verbal and written skills We look forward to your bids and working with you soon. Thanks
I am a Civil Engineering graduate. Mostly Iam used with spreadsheets worksheets to do estimations of construction projects. Here Iam submitting that kind of file which i did for block panchayath building.
...course. There will be handouts and worksheets for the course. I have all of the content but need help in making them look more appealing and professional. I have branding guidelines for you but you will be given creative freedom. There are 7 docs in total, one of which is 4/5 pages and will require a front cover design. And for each document, I want to
...historical data to a designated Excel worksheet. The current REST API application and Excel Macros presently posts real time account and exchange rate data to designated Excel worksheets, as well as automates order placement and trade execution through Excel. This project will expand the current system by adding instrument historical data to be used for
...sample)? What variables have been measured or manipulated? 4. Results: This section needs to be based on the analysis completed during the relevant workshop. The analysis worksheets explain what should be included in the results section. You need to present and label all graphs and figures appropriately 5. Discussion: Briefly summarise the results. What