Easy import of Cost Data

已完成 已发布的 5 年前 货到付款
已完成 货到付款

I work as a cost planner and want to find an easy way to Import cost data from an Excel file into an Excel template that we have.

Our Project databank Software is called modelogix. From this Software we can Export data as an Excel file. At this Moment, we manually have to copy the data, and paste it into a specific Excel worksheet within the Excel Template.

Our template compares Projects side by side with each other.

So the process would look like this.

1. We Export the relevant Projects and all their Information from Modelogix into an Excel file, we then save the file, we will call the file ''Test'' for now.

2. I open the template Excel dokument, Chose the sheet where i want to data to be imported into.

3. Now i want to be able to click somewhere, where i have the Option to Import the ''Test'' files Information. The rest of the templates worksheet are all linked to this worksheet. So the Moment this worksheet gets populated with the info, the rest of the template would be filled out automatically. All These links are allready made.

Hope the above makes sense. I have attached a copy of the Template (KGS Vorlage), and a copy/example of the exported data (Vorlage Test).

The last two worksheets in the template are the ones the same as the exported worksheets. Its these worksheets that all the where all the data for the template Comes from. I dont want to manually copy and paste the data anymore. I want to be able to Import it directly into These two worksheets,

Excel Visual Basic

项目ID: #18371602

关于项目

38个方案 远程项目 活跃的5 年前

授予:

paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. According to your brief, you want to open your Excel template, select one of its sheets and then by pressing a bu 更多

$300 USD 在1天内
(241条评论)
7.5

有38名威客正在参与此工作的竞标,均价$399/小时

schoudhary1553

Hello, I have the good knowledge of Easy import of Cost Data. I have more than 5 years of experience in Excel, Visual Basic. I have reviewed your job and can deliver you the job with 100% satisfaction. Please ping 更多

$500 USD 在10天内
(333条评论)
7.9
asin1987

Dear employer, I have checked your job and I will very well do it. Please message to discuss it please. I am an expert. Please check my previous reviews for your kind reference!! :) Thanks and Regards, Ash

$555 USD 在10天内
(187条评论)
7.6
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m 更多

$400 USD 在10天内
(249条评论)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. I can write a code that does the whole process automatica 更多

$400 USD 在7天内
(238条评论)
6.9
dvcontact

Hi, You won’t select the right candidate without knowing what your project on writing Excel macro that will import cost data into Excel sheet and populate other spreadsheet that are linked to the Excel sheet with the 更多

$250 USD 在5天内
(52条评论)
6.4
sloker18

I am proficient with Microsoft excel and macro/VBA development, I have gone through your attached workbooks, I can definitely write the macro to generate the report as depicted in your description. If you are inter 更多

$250 USD 在5天内
(103条评论)
6.2
lightingdavid

Hello. I have good skills in Excel, Visual Basic. I have checked your project description carefully and i can do it. I hope to work with you. Contact me please. Thank you.

$250 USD 在2天内
(99条评论)
5.9
usmanhassan123

With more then seven years of experience as a freelancer. I already done more then 142 successful projects with five stars and also have five years of experience of (WKPM) world largest fourth number Accounting firm. 更多

$250USD 在1天里
(73条评论)
6.2
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Expert in PYTHON,.NET, VB, VBA, MYSQL, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formu 更多

$250 USD 在2天内
(75条评论)
5.9
SPARKtechBD

I can build Excel VBA code (Macro) to import Excel data to the Excel sheet on your instruction. It will import required data and values from import Excel file. Basically I work on Visual Basic to build any kind of Wind 更多

$750 USD 在10天内
(11条评论)
5.6
daniyal3214

I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analysis, Financial Forecasting, Cash 更多

$250USD 在1天里
(52条评论)
5.5
khanjzthanjzt

Greetings, We have read the project description and understand the nature of work, Allow us to complete it with 100% accuracy and perfection within the deadline. Warmest Regards

$722 USD 在10天内
(9条评论)
4.4
expertcoder1vw

Hi, I'm an expert Excel / database / VBA developer and can make an macro for you that will import data exactly into the cell where you click. Can deliver in 10 days or less. Good quality work done, and long term su 更多

$500 USD 在10天内
(16条评论)
4.6
mahisha123

Hi, I’ve gone through your requirement . I am very much interested to work with you on this project. I do have expertise in the specified area. I can start the project right away and can complete as soon as possible. 更多

$250 USD 在10天内
(24条评论)
4.3
akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S 更多

$250 USD 在2天内
(28条评论)
4.4
sachavukic

Hello, I'm making Excel programs for more than 20 years. Your goal is to import some data from modelogix software to an predeterminated Excel File, where all the formulas are already set. I"m not sure I unders 更多

$500 USD 在2天内
(6条评论)
2.7
billpinder82

Good day, my name is William Pinder. I am an Excel specialist with 10 years of professional experience. I currently work as a Data Administrator for a local non-profit organization. I also provide freelance Excel servi 更多

$400 USD 在10天内
(3条评论)
2.6
claudiasofamata

I read your request, I checked the files that you climb and I have the necessary skills to help you. I am a dedicated person with experience in the accurate handling of sensitive data, cleaning tables with duplicate da 更多

$250USD 在1天里
(3条评论)
1.8
ITPyramid85

hello,how are you. i read your bid carefully. i am c/c++, cuda/gpu expert and have full experience for 10 years. c/c++, cuda/gpu is my top skill and i can build your project fully. i can provide most quality and hig 更多

$500 USD 在10天内
(0条评论)
0.0
hlfreelancer

Hi, I am interested in your project for importing excel data into excel template please contact me for further discussion best regards

$650 USD 在10天内
(0条评论)
0.0