Excel Spreadsheet Assistance

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

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.

Excel Data Entry Data Processing Visual Basic

Project ID: #23963953

About the project

51 proposals Remote project Active 4 years ago

Awarded to:

jaelahoe

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!

$190 USD in 1 day
(13 Reviews)
4.3
ksriniravi

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 More

$50 USD in 2 days
(228 Reviews)
7.1

51 freelancers are bidding on average $146 for this job

Eagles90

Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in l More

$250 USD in 3 days
(211 Reviews)
8.3
schoudhary1553

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 More

$220 USD in 4 days
(446 Reviews)
8.3
ponnarasiBabu

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

$200 USD in 7 days
(438 Reviews)
7.8
P0L

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.

$150 USD in 3 days
(482 Reviews)
8.0
finecodervw

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 More

$150 USD in 4 days
(146 Reviews)
6.6
daniyal3214

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 More

$60 USD in 1 day
(119 Reviews)
6.7
pm9887

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

$100 USD in 7 days
(77 Reviews)
6.1
bhupendrayadav

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 More

$150 USD in 1 day
(51 Reviews)
5.9
vsprybhanu

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 More

$250 USD in 3 days
(121 Reviews)
6.0
ARTICLEYOUWANT

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 More

$150 USD in 7 days
(24 Reviews)
5.4
amwazeindia

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 More

$100 USD in 2 days
(24 Reviews)
5.3
IgeS

Hi there, Need to have additional macro that will automate the reformatting and appending of the raw data from the csv into the job summary? Please message this we can discuss some of the improvements I found as I r More

$116 USD in 5 days
(37 Reviews)
5.3
reubengi

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

$99 USD in 3 days
(20 Reviews)
5.0
Servicehour24

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 More

$100 USD in 3 days
(7 Reviews)
4.6
MonisZafar

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.

$80 USD in 1 day
(25 Reviews)
4.9
yhleow

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!

$150 USD in 3 days
(11 Reviews)
4.2
jbayton2492

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 More

$55 USD in 7 days
(2 Reviews)
2.2
satyendrasingh96

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 More

$162 USD in 5 days
(0 Reviews)
0.0
Yourservice143

Hello! Iam intrested in our project to do that work. Give the work I will do my job.

$45 USD in 20 days
(0 Reviews)
0.0
atishdawane

I'm completed diploma in computer engineering and I have good knowledge about MS-Office, excel and also good typist

$30 USD in 2 days
(0 Reviews)
0.0