Easy import of Cost Data

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

Project ID: #18371602

About the project

38 proposals Remote project Active 5 years ago

Awarded to:

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 More

$300 USD in 1 day
(241 Reviews)
7.5

38 freelancers are bidding on average $399 for this job

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 More

$500 USD in 10 days
(333 Reviews)
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 in 10 days
(187 Reviews)
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 More

$400 USD in 10 days
(249 Reviews)
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 More

$400 USD in 7 days
(238 Reviews)
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 More

$250 USD in 5 days
(52 Reviews)
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 More

$250 USD in 5 days
(103 Reviews)
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 in 2 days
(99 Reviews)
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. More

$250 USD in 1 day
(73 Reviews)
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 More

$250 USD in 2 days
(75 Reviews)
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 More

$750 USD in 10 days
(11 Reviews)
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 More

$250 USD in 1 day
(52 Reviews)
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 in 10 days
(9 Reviews)
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 More

$500 USD in 10 days
(16 Reviews)
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. More

$250 USD in 10 days
(24 Reviews)
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 More

$250 USD in 2 days
(28 Reviews)
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 More

$500 USD in 2 days
(6 Reviews)
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 More

$400 USD in 10 days
(3 Reviews)
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 More

$250 USD in 1 day
(3 Reviews)
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 More

$500 USD in 10 days
(0 Reviews)
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 in 10 days
(0 Reviews)
0.0