Excel Spreadsheet Assistance

完了済み 投稿 4年前 着払い
完了済み 着払い

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.

エクセル データ入力 情報処理 ビジュアルベーシック

プロジェクトID: #23963953

プロジェクトについて

51個の提案 リモートプロジェクト アクティブ 4年前

アワード:

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 1日以内
(13レビュー)
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 もっと

$50 USD 2日以内
(228レビュー)
7.1

51人のフリーランサーが、平均$146 で、この仕事に入札しています。

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 もっと

$250 USD 3日以内
(211件のレビュー)
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 もっと

$220 USD 4日以内
(446件のレビュー)
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 7日以内
(438件のレビュー)
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 3日以内
(482件のレビュー)
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 もっと

$150 USD 4日以内
(146件のレビュー)
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 もっと

$60 USD 1日以内
(119件のレビュー)
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 7日以内
(77件のレビュー)
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 もっと

$150 USD 1日以内
(51件のレビュー)
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 もっと

$250 USD 3日以内
(121件のレビュー)
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 もっと

$150 USD 7日以内
(24件のレビュー)
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 もっと

$100 USD 2日以内
(24件のレビュー)
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 もっと

$116 USD 5日以内
(37件のレビュー)
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 3日以内
(20件のレビュー)
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 もっと

$100 USD 3日以内
(7件のレビュー)
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 1日以内
(25件のレビュー)
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 3日以内
(11件のレビュー)
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 もっと

$55 USD 7日以内
(2件のレビュー)
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 もっと

$162 USD 5日以内
(0件のレビュー)
0.0
Yourservice143

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

$45 USD 20日以内
(0件のレビュー)
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 2日以内
(0件のレビュー)
0.0