Excel data formatting macro jobs
Please Sign Up or Login to see details.
I have a current company and we use the following excel sheet file for our clients, I want to redesign and make it as my own and copy the core essence of the program but with my own twist. I want to mix some files into it and make it more interactive. It is based on the book "Barefoot investor" therefore we will go back and change the equations" The file original file is locked so only two files/tap below are open. Therefore once we unlocked the file under Cashflow analysis "unlock property roadmap" then 2 new tabs will open (this is the attached file- the unlocked version). I want you to able to recreate the original file. Add Kiwisaver calculator in the planner. Make it more interactive, visually, by thinking investments picture, money growing, funds, e...
I need you to create one single cvs file of the attached files, having mobile numbers of customers with 91 as the prefix before the number starting from the first column of the first row! delete all other information, as I only need mobile numbers with country prefix (91) for whats app bulk messaging requirement !
I am designing a system and need a programmer to write it. I believe we can use Python. The system will also require Microsoft excel and Adobe. This person needs to be familiar with Cyber security.
Support in building an interactive cost dashboard
I need to make some major changes to an existing Adobe InDesign document. It is an educational question booklet and I need some questions removed and text moved around and the rest of the document condensed into lesser pages. I don't think it requires a lot of experience, but it could be be quite tedious and will require quite a it of back and forth communication. If this project is done well, I have more InDesign work that could follow. *Need ability to follow instructions*
I'm looking for a screenwriter who can write a 10 Min screenplay for an animated short. I'll provide a one-page story outline covering the entire plot. You will be responsible for developing the details and formatting. You should strictly adhere to the "Show, Don't Tell" rule. Genre: Action, Thriller Language: English
PART-2 of Extract Hindi fields from PDF and convert it to excel
...company in Thailand, and am looking for VAs to join our team! Initially you'll be involved in a variety of tasks such as web searching, basic research and data entry. The workload will vary from day to day, and your hours of work can be flexible. Once the company is up and running we'll be building a small team of FULL-TIME VAs. If we love your work and you love working with us, one of these full-time roles could be yours if you're interested! REQUIREMENTS: ? Fuent Thai (spoken & written) ? Fluent English (spoken & written) ? Experience - You'll need some general work experience & the ability to use MS Word, Powerpoint and Excel. If you know your way around social media that would be very useful. Specific experience as a VA isn't...
I have some documents in pdf format that need to be translated from Spanish into English. Most of the work is on the formatting. Access to OCR tools is a must. Thank you.
Max 10 hours project. I’m looking for ACF tutor will teach me how to setup a database in Wordpress. I have all the database definitions in a excel file. More info in pmb
Looking for someone that collect contact data from WhatsApp and input data into excel.
I have webscraped basketball results from a website into an excel spreadsheet and the data needs to be organised for analysis. There are 110 colums and 3,658 rows. I have an excel data template which shows how the data should be re-organised. Attached is an example of the data and the template.
Are you able to create a script in Python that through KuCoin API a) Updates the Price of BTC, ETH, LTC in an Excel File b) Updates in an Excel file the Quantity of BTC, ETH, LTC I own in the account c) Buys and Sells the Quantity of BTC, ETH, LTC I mention in an Excel file?
...A2, A3 folders and some folders may have missing images that is images present in A1 may not be present in A2 or A3 and vice versa. I need a GUI that shows images from three folders with folder and sub folder names on top of 3 images. The input image name to GUI is given using an excel sheet that I will provide. Next there should be two columns of checking boxes on the side I will enable the one of the box from each column when I see image on GUI and click next. Once all images are reviewed , I need a new excel sheet with image name and check in options I enabled during review. ...
Looking for someone that collect contact data from WhatsApp and input data into excel.
I need a word document formatted please. No data entry, just formatting. - i need numbers checked, columns lined up and headers and footers added Attention to detail is required
Build a functionality form in excel
Wonder if you guys can convert 1 year pdf bank statement into excel? How much will it cost?
please do my excel project. income statement, pivot table, breakeven analysis and lookup&countif
Hello, There is a need for a simple program that can check a Date column in Excel, then pick all rows from a particular date to another date, and create another Excel worksheet or workbook with the extracted rows. The date column has date of event for each row, e.g. from April 1st to April 30 and I want this program (which could be an Excel script too) to for instance, pick all rows with date from April 15 to April 30 and insert them in a new worksheet/workbook. Here is the date format: 2022-03-17T16:29:16+00:00 I will send sample Excel document to interested bidders
Hello I need a commissions template for a dual OPEX and CAPEX model business.
I need a routine to remove a # that is in one field from the end of a string in another field if that # exists. Example is below MfgID Debit Memo 1345 AHR352618 2984 CAT351311 832 CAT351519 832 CAT351520 287 CF042622BB287 832 CF042622BB832
Hi, I want 20 different invoice Templates in excel which is only function to calculate the total bill. All style/ designs I need are different from each other. If someone have already available then Great. please let me know if you interested with time and budget. if you have any sample then also show me. Thank you
1. The ratio analysis will have to be in line with the company’s business. 2. Five years financial statements will have to be used for analysis. 3. Data should be obtained only from published source of the company and not from other financial analysis websites such as 4. The final work should contain three excel sheets. The first sheet should be the five year Balance Sheet data. The second sheet should be the Income Statement and the cash flow statement for the same five years. The third sheet should indicate all the analysis. 5. Interpretation of the analysis can be either presented in the third excel sheet along with the ratios or as a separate word/pdf document.
Hi Aqib M., This is the verification project that I told you about. If you have a chance tell me the amount of the amount from March that I have to add to the excel spreadsheet. Thank you, Ada
Re-create excel template with ability to create chart based off the data
Looking to take an existing excel timecard template and make it so all the functions we need it to do.
I need a person experienced with excel to update a project financial report. I worked with Khurram Sattar last April 2021 to do the first project and it would be best to work again with Khurram if he is available - since he has the original files that need to be updated. I need to complete the project in the next 5-7 days.
I will provide you a set of formulae you need to add in excel sheet for various concrete design elements
I have a set of numbers - Eg - K9, H3, Y5, and so on. In one row of excel, I need K in each cell one after the other K9 in every 9 times repeated, then H3 3 times, the Y5 5 times. This loop will go on till the time the name ends.
I need an excel financial model creating formulas combining opex+ capex+ COGs+ labour and formulating profits depending jobs. I have 2 files to combine as a starting point .
I need to Extract Hindi fields from PDF and convert it to excel in specified format
I PREPARE ALL COMADS AND TASK OF AUTOCAD BY USING EXEL LIKE AUTOMATIC LAYOUT PRINT,MOVING DRAWING,AND ETC JUST CONTACT ME I WILL SHARE MY PRODUCTS.
create a new data set that has the columns ID, DATE, START, STOP, DUR_s, DMI_kg. When the time between entries (bunk visits) is less than 1 minute, they should be collapsed in to a single entry, containing the new stop time and summing the DUR and DMI_kg columns to account for the increased length of visit, as we as the associated date and ID. This will be done by ID by day for all entries in the data set. What I DON'T want is just a summary of duration and DMI_kg by day, I only want to summarize if the time between visits in less than 1 minute. New data described above.
Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, Director's Report. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions) if provided in Excel sheet. Preparation & Filing of Annual Returns Form AOC 04 (Financials Related Annual Return). Preparation & Filing of Annual Returns Form MGT 07 (Management Related Annual Return). Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. Preparation & Filing of Income Tax Returns (Company). FY(2022-2023) Preparation of Share Certificates (For All Share Holders). Preparat...
I need to conduct a path analysis by using one of the following [AMOS, LISREL, SMARTPLS]. I have data in excel sheet. I need your SPSS and your selected files, you must share them and I check them before releasing the milestone. Tables - [AMOS, LISREL, SMARTPLS] - must be exported to excel and then format. I need the results report according to APA guide, Word doc, well format. I have the suggested model.
I need an Excel to perform conveyance function with statement of adjustments and other functions.
This job consists in deep web search and hand-collection of data. It will involve searching for, reading, and interpreting information on the year in which a list of business schools received accreditation, recording the data in a spreadsheet, and providing links to the information found during the search. The project will be managed through several milestones. Requirements: - Attention to detail and patience - Experience with deep web search and hand-collection of data - Experience with reading and interpreting information contained in websites or documents - Experience with data entry on excel sheet Goal: Collect data on the exact year in which 803 international business schools received AMBA or EQUIS accreditation between 1998 and 2018. Th...
Hello, I have a table in excel for which I require a PowerBI dashboard to be created The table columns need to be dynamic. Basically there are 6 events that occur each year (there is a unique column in the table which identifies the even # and year). The table needs to show how many events did an employee pass each year and how many. failed. This needs to be completed today
Hi, you have done some work for me in the past on access. Maybe you can help me with a new project. I have a microsoft access database. It included a table, some queries and reports and a form to open the reports with predefined data filters. It also has a macro to import data from a website. I would like to see this database with all its functions converted to a standalone vb.net application. Is this something you can do?
I am looking for 50 recruitment leads in a niche sector. I will need the leads to have the following format on an Excel spreadsheet Company name Contact name Position in company Email address Job Title It will most likely become an on going project. Some experience with lead generation is required. Before I accept you I will require you to submit 2 example leads in the above format from this link; Please ensure that none of the leads are for recruitment companies it must be the direct client.
Project Merchant site idtflr demo_mod Use the current welcome page It is cell phone compatible, It can bee seen as a column on a cell phone. Three colums Member services My Account Private Messages Latin Latin Latin Change to THESE HEADERS Do not use a table keep the CSS formatting Member services Administrator Today’s Messages IDTFLR sent to WPID New MEM’s From WebPicID IDTFLR reply from WPID Duties External Secure Message KYC Items Internal Safe Purchase AML Items VIDOTN Micro Payment Account balance NEW Services VIDOTN Wire information Reports Fee Structure Set MEM Access
Add missing data to cells from duplicates in Excel Rows 2 to 1925 are related to our current database. We have new records, from row 1786 (the company name column value is Thunkable) to row 4633 which is the end of the sheet. There are duplicates regarding the company name. We want to add records that are not duplicated to our current database (below row 1925) and fill out empty cells in our current database with related data in duplicated records if there are any. To do so, here are the steps: Start from row 1925. Check the company name. If there is a record with the same value in rows 2-1925, check which cells are empty in that row. Then for each empty cell check if there is any data in duplicated row and copy it to the cell. Else, If the company name is no...
I need a spread sheet made on an easy to update platform of all the Was thinking on camping: could you prioritize fleshing out the spreadsheet and collecting all available campsites/glamping/state/national parks in with in a two hours drive or less of Bernal heights California Hey I need spreadsheet and collecting all available campsites/camping grounds for all these types of camping types avai...parks in with in a two hours drive or less of Bernal heights California Hey I need spreadsheet and collecting all available campsites/camping grounds for all these types of camping types available with descriptions or key points of each campsite listed spreadsheet and collecting all available [login to view URL] [login to view URL] [login to view URL] [login to view URL] parks Preferably not ...
Search for accommodation to find pricess. Location: Nottinghamshire. Near the University of Nottingham. Postcode NG7 2RD (5-mile radius max) Dates: 1st June to 1 July 2022 Use: Google Search Air BnB Search Expedia Search Local Hotels Search List results in an easy to read Excel format and columns Location Address Type (Hotel, BnB, Airbnb) Prices Sharing with other people? Y/N Number of bedrooms Additional details Relevant links
15 pages of data from Ministry of Interior website to excel: %D8%AF%D8%A7%D9%8A%D8%B1%D8%A9-%D8%A8%D9%8A%D8%B1%D9%88%D8%AA-%D8%A7%D9%84%D8%AB%D8%A7%D9%86%D9%8A%D8%
This job consists in deep web search and hand-collection of data. It will involve searching for, reading, and interpreting information on the year in which a list of business schools received accreditation, recording the data in a spreadsheet, and providing links to the information found during the search. The project will be managed through several milestones. Requirements: - Attention to detail and patience - Experience with deep web search and hand-collection of data - Experience with reading and interpreting information contained in websites or documents - Experience with data entry on excel sheet Goal: Collect data on the exact year in which 803 international business schools received AMBA or EQUIS accreditation between 1998 and 2018. Th...