Easy import of Cost Data

Slutfört Publicerat 5 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

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

Projekt-id: #18371602

About the project

38 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

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 Mer

$300 USD inom 1 dag
(241 omdömen)
7.5

38 frilansare har lagt bud på i genomsnitt $399 för det här jobbet

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 Mer

$500 USD inom 10 dagar
(333 omdömen)
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 inom 10 dagar
(187 omdömen)
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 Mer

$400 USD inom 10 dagar
(249 omdömen)
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 Mer

$400 USD inom 7 dagar
(238 omdömen)
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 Mer

$250 USD inom 5 dagar
(52 omdömen)
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 Mer

$250 USD inom 5 dagar
(103 omdömen)
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 inom 2 dagar
(99 omdömen)
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. Mer

$250 USD inom 1 dag
(73 omdömen)
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 Mer

$250 USD inom 2 dagar
(75 omdömen)
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 Mer

$750 USD inom 10 dagar
(11 omdömen)
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 Mer

$250 USD inom 1 dag
(52 omdömen)
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 inom 10 dagar
(9 omdömen)
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 Mer

$500 USD inom 10 dagar
(16 omdömen)
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. Mer

$250 USD inom 10 dagar
(24 omdömen)
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 Mer

$250 USD inom 2 dagar
(28 omdömen)
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 Mer

$500 USD inom 2 dagar
(6 omdömen)
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 Mer

$400 USD inom 10 dagar
(3 omdömen)
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 Mer

$250 USD inom 1 dag
(3 omdömen)
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 Mer

$500 USD inom 10 dagar
(0 omdömen)
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 inom 10 dagar
(0 omdömen)
0.0