Easy import of Cost Data

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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

Identifikační číslo projektu: #18371602

O projektu

38 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

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 Další

$300 USD za 1 den
(241 recenzí)
7.5

38 Freelnceři na tento projekt zveřejňují nabídky v průměru $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 Další

$500 USD za 10 dní
(333 Recenzí)
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 za 10 dní
(187 Recenzí)
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 Další

$400 USD za 10 dní
(249 Recenzí)
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 Další

$400 USD za 7 dní
(238 Recenzí)
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 Další

$250 USD za 5 dní
(52 Recenzí)
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 Další

$250 USD za 5 dní
(103 Recenzí)
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 za 2 dní
(99 Recenzí)
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. Další

$250 USD za 1 den
(73 Recenzí)
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 Další

$250 USD za 2 dní
(75 Recenzí)
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 Další

$750 USD za 10 dní
(11 Recenzí)
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 Další

$250 USD za 1 den
(52 Recenzí)
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 za 10 dní
(9 Recenzí)
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 Další

$500 USD za 10 dní
(16 Recenzí)
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. Další

$250 USD za 10 dní
(24 Recenzí)
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 Další

$250 USD za 2 dní
(28 Recenzí)
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 Další

$500 USD za 2 dní
(6 Recenzí)
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 Další

$400 USD za 10 dní
(3 Recenzí)
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 Další

$250 USD za 1 den
(3 Recenzí)
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 Další

$500 USD za 10 dní
(0 Recenzí)
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 za 10 dní
(0 Recenzí)
0.0