Easy import of Cost Data

$250-750 USD

Ukończony

Opublikowano

ponad 5 lat temu

$250-750 USD

Płatne przy odbiorze

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

Identyfikator projektu: 18371602

Informację o projekcie

38 ofert

Zdalny projekt

Aktywny 5 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@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 button to pick up the file from where the data will be copied. We can select the source file in two ways. First, a pop-up dialog box lets you pick up the file. Second, the source file's path and name are hard-coded, so there's no need to select it. It's up to you what you prefer. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed 270 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $300 and can deliver within one day (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas

$300 USD w 1 dzień

4,9

(241 opinii)

7,5

38 freelancerzy składają oferty o średniej wysokości $399 USD dla tej pracy

@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 me for more discussion.

$500 USD w 10 dni

4,9

(333 opinii)

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 w 10 dni

5,0

(187 opinii)

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 more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """

$400 USD w 10 dni

4,9

(249 opinii)

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 automatically by just pressing a button. Check my reviews, they speak for themselves. Best regards

$400 USD w 7 dni

4,9

(238 opinii)

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 imported data will look like. Fortunately, I can complete a part of your job before you award the project. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Data Processing 2. Data Entry 3. Visual Basic 4. Excel I am passionate about flawless results and I can assure you of a job well done. Please refer to my reviews for more details. Looking forward to discussing the project details with you.

$250 USD w 5 dni

4,9

(52 opinii)

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 interested feel free to message me, I am available to start your project immediately. Looking forward to chat further and work on your project.

$250 USD w 5 dni

5,0

(103 opinii)

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 w 2 dni

4,8

(99 opinii)

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. I am a chartered accountant having seven years of experience in Accounts and finance. I have strong grip on Australia, America, USA, New Zealand, Singapore and all other Europeans states Markets Research. I am expert in: - Making financial statements. - Excel Financial models. - Statistics & Economics. - Statistical analysis ( R, Spss, Excel). - Business plans. - Market Research. - Financial Dashboards. - Financial statements. - Tax and Auditing. - Balance sheets. - Accountancy. - Cost Management. - Accounting. - Mathematics. - Business And management. - Accounting Assignment. - Ratio Analysis. - Linear & Multiple Regression. - Financial Analysis. - Presentations. - Case studies. I can deliver you 100% guareented work, you can check your work before releasing the payment. I am a professional worker and I can not take any project until I can not be assured 100%. In writing services I can deliver you Turn it report as well. Once check my profile and portfolio. Thanks.

$250 USD w 1 dzień

4,7

(73 opinii)

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 Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Large scale application development, Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Having more than 15 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, etc., Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to hear from you soon. Have a great day. Thank you.

$250 USD w 2 dni

4,8

(75 opinii)

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 Windows application. Have more than 15 years of experience on Visual Basic.

$750 USD w 10 dni

5,0

(11 opinii)

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 Flow Projections, Budgeting and various other customized and tailored analysis and computations. I will be happy to discuss in detail.

$250 USD w 1 dzień

4,7

(52 opinii)

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 w 10 dni

5,0

(9 opinii)

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 support offered. Thanks for considering my bid. Bests, Steve

$500 USD w 10 dni

5,0

(16 opinii)

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. Please respond me so that we can discuss it in-detail. Look forward for your response and seeking a chance to work with you. Thanks & Regards Mahi

$250 USD w 10 dni

4,9

(24 opinii)

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 Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time

$250 USD w 2 dni

4,7

(28 opinii)

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 understand the second point of your description, where you precise you want to choose "the sheet where i want to data to be imported into." I noticed all the sheets have different purpose, and I think the import should be allowed in a specific worksheet, with the adapted template. So I think you mean you want to create a new file, based on the template, where the "test" sheets will be added at the end of the workbook. Those sheets will be used as reference to automatically fullfill the others sheets of the workbook. I have some ideas to program it, but I will need first to agree with you on the future behavior of the excel template (what will exactly happened when you click on the "import" button, etc...). So, if you are interested, please contact me to discuss on this last point. Sacha. P.S.: i also speak French.

$500 USD w 2 dni

5,0

(6 opinii)

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 services. I have read your project description and I think that importing the data right into the workbook you analyze it in would be the way to go. It would save you many steps. Data manipulation is what I do and I am sure there is a way to import the data directly where you need it, possibly using ODBC. If you send me a message I will look into the possibility of this for you. Thank you for your time.

$400 USD w 10 dni

5,0

(3 opinii)

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 data, handling filters and pivot tables, VBA programming and development of macros.

$250 USD w 1 dzień

5,0

(3 opinii)

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 high speed. if you want to success, please contact me. Then, I will give you good result to the proposals. hire me.

$500 USD w 10 dni