Excel Spreadsheet Assistance

Terminé Publié le il y a 4 ans Paiement à la livraison
Terminé 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.

Excel Saisie de Données Traitement de Données Visual Basic

Nº du projet : #23963953

À propos du projet

51 propositions Projet à distance Actif il y a 4 ans

Décerné à:

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!

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(13 Commentaires)
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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(228 Commentaires)
7.1

51 freelances font une offre moyenne de 146 $ pour ce travail

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 Plus

$250 USD en 3 jours
(211 Commentaires)
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 Plus

$220 USD en 4 jours
(446 Commentaires)
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 en 7 jours
(438 Commentaires)
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 en 3 jours
(482 Commentaires)
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 Plus

$150 USD en 4 jours
(146 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(119 Commentaires)
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 en 7 jours
(77 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(51 Commentaires)
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 Plus

$250 USD en 3 jours
(121 Commentaires)
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 Plus

$150 USD en 7 jours
(24 Commentaires)
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 Plus

$100 USD en 2 jours
(24 Commentaires)
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 Plus

$116 USD en 5 jours
(37 Commentaires)
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 en 3 jours
(20 Commentaires)
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 Plus

$100 USD en 3 jours
(7 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(25 Commentaires)
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 en 3 jours
(11 Commentaires)
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 Plus

$55 USD en 7 jours
(2 Commentaires)
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 Plus

$162 USD en 5 jours
(0 Commentaires)
0.0
Yourservice143

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

$45 USD en 20 jours
(0 Commentaires)
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 en 2 jours
(0 Commentaires)
0.0