Excel Spreadsheet Assistance
$30-250 USD
Paiement à la livraison
I had an excel spreadsheet created a few years ago to help keep track of individual expenses on a project. There are 3 tabs (summary, costs, and budget costs). The summary page summarizes the actual costs compared to the budgeted cost and shows the variance (spreadsheet attached). The spreadsheet worked great; however, it took a long time to input individual transactions. I now use an online software for employees to upload receipts and it allows to be create a csv file quickly. I need help formatting the data exported from the online software to properly (and easily) be inputted into the "cost details" tab on my original spreadsheet.
Attached are the original "Budget Summary" spreadsheet and an example of the data exported from the online software. I have also attached an "Example Budget Summary" that shows how the spreadsheet has been working for me when manually inputting each transaction. I like how on "Job Summary" page I am able to double click on the actual cost or budget cost cell and it takes me to a page that shows the entries that make up the total listed on the summary page.
Nº du projet : #23963953
À propos du projet
Décerné à:
Hi there! Edit: Seems like a PivotTable with a little bit of vba can solve your problems Will show you a preview of what you want before you award project. Cheers!
Greetings! Thanks for detailed diescription and files. I have reviewed the files and requirements. I can add a "IMPORT" button in "COST DETAILS" Worksheet. Clicking on the button would help select the CSV file (data e Plus
51 freelances font une offre moyenne de 146 $ pour ce travail
Hello, I can help you with your project - Excel Spreadsheet Assistance I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed se Plus
I read and understood your requirements - Excel Spreadsheet Assistance and would like to discuss more about the project on final output. So i hope you would open a PM to discuss about the work . Regards, Ponsi
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, Keen to work on this project. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done goo Plus
I can perfectly help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform automati Plus
Hi There, Need to know more about the complete job description. I have good experience in all type of backend work and spreadsheet task. Let's discuss and work together. Thanks Prakash
I am full time freelancer with postgraduate having more than 6 years of experience in advanced excel based tools, VBA automation, dynamic dashboards, web application, web dashboards, google spreadsheets, google scrip Plus
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets Plus
I WOULD LIKE TO PLACE MY BID FOR YOUR PROJECT NAMED Excel Spreadsheet Assistance Need a lot of data entry work done? Stop relying on luck to get quality freelancers and hire me! I provide high-quality Virtual Assistan Plus
Hi, I checked the files you uploaded and i have a few doubts. From my understanding of the description, you need to have the contents copied from the software exported csv file to the Cost Details tab in the spreadsh Plus
Hi, I am well experienced in creating Excel VBA macros to facilitate work with XL. I can create the tools you need to load the data from the CSV file into the cost details. Pls see reviews in my profile. regards Reuben
Hello, I am happy to inform you that I have read your current project description and understood all of your required requirements. I'd like to help you with confidence and satisfying results. I have professional work Plus
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.
Hi I have 5 years of experience working in bank as a financial analyst, dealing with VBA macros on a daily basis. I will be able to assist you on this project. Please contact me for more information. Thank you!
Hello there, As a Data Scientist I have huge experience working with several tools / techniques like: - Web Scraping - Python Programming - Vba Code (Macros, Graphs and Dashboards) - Machine Learning (Models, Data Plus
i will make it happen for you on time, if you gave this project to me, its mine pleasure to surve you. Relevant Skills and Experience I have good experience of data entry and data processing , finely able to handle ms Plus
I'm completed diploma in computer engineering and I have good knowledge about MS-Office, excel and also good typist