Last seen: Jan 24, 2014 8:44 AM EST
Hire Me!
Rate: $30.00 USD/hour
Follow Invite to Project


advanced VBA programming

Username: Krusche

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has not verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: Munchen, Ukraine

Member since: January 2011



(37 reviews)

[see more]

No user has recommended this freelancer.

My projects:

  • $30 USD
    Profile image for Seller SJOps


    Jul 9, 2013

    As always, a pleasure to deal with!

    Project Description:Please see attached zip package containing the workscope and latest versions of the Master Log and spreadsheet.
  • €30 EUR
    Profile image for Seller Strapatzen


    Jan 3, 2013

    Thanks for helping us out with this issue.

    Project Description:The job which converts the onix/xml update files unnecessarily increases the database size when an update file is imported. The increase is mysterious and far larger than the size of the update file:...
  • £300 GBP
    Profile image for Seller SJOps


    Dec 14, 2012

    Krusche have been an exceptional company to work with and have helped us develop an Excel system which has benefitted our company immensely. They are prompt, react quickly to issues that we encounter during testing and have helped us troubleshoot where it has been 'user error' too. I'm sure we'll be working with them again soon!

    Project Description:Thank you for completing Operational Log 4. Please see project details for Operational Log 5 in the attachment. Kind Regards Kirsty
  • £95 GBP
    Profile image for Seller frizbee


    Dec 11, 2012

    Excellent, we will be working with this freelancer again in the new year to expand our project. Delivered on time and fully completed, because of this they will be our first port of call when we require the next part of our ongoing data projects.

    Project Description:I have a series of excel spread sheets that contain all of our product information. For example one has the sku and the pricing, one has the sku and sizes, one has the sku and colours etc They are...
  • £100 GBP
    Profile image for Seller SJOps


    Nov 29, 2012

    Krusche carried out our project ensuring they met all our needs of the project. They have understood our requirements and delivered us an end product that will make our business operations more efficient. The communication between ourselves and Krusche has always been good and throughout this project has been good. We would use Krusche again for future projects as we have a good relationship with them and feel they have an exceptional knowledge in their field of expertise.

    Project Description:Format changes to Operations Log, please see attached documents, hopefully the changes are visible. If you need to contact me my email is This is something we are looking...
  • $120 USD
    Profile image for Seller nystocktrader


    Nov 28, 2012

    Krusche - Comminication was fantastic, solved issues before I had realized they would be issues. Will gladly use and reccomend to any and all. Many thanks.

    Project Description:Excel - VBA - Email range of data on schedule. I have a spreadsheet that will have data on tab “A”. The data changes every minute. The range size will change often. I need to have the data emailed to...
  • £200 GBP
    Profile image for Seller SJOps


    Nov 21, 2012

    Excellent job again! Now commencing work on our 5th project with Krusche.

    Project Description:*Private project for Krusche* Please see below for a detailed description of Operational Log (4): Please make changes to the attached spreadsheet, Master Operational Log. 1) WEATHER LOG You will...
  • $32 USD
    Profile image for Seller ammolab


    Nov 21, 2012

    Great Job. Nothing more to say about! Understood my requirements from the first moment and delivered in time. Great Freelancer, will definetly hire him again!

    Project Description:Hello, I need somebody how can create me a little Excelsheet or/and Access-Database, which should be able to handle the following: 1) I upload a CSV-file in which there is one coloumn with string-texts i.e...
  • $150 AUD
    Profile image for Seller exoticcandy


    Oct 19, 2012

    Good communication, had own suggestions on how to make it better also which was great.

    Project Description:We are after a order form that is self calculating. The one for Exotic Filled candy & Licorice is our current one and needs redoing to make it more professional, needs to have another column which totals the amount of boxes ordered...
  • £450 GBP
    Profile image for Seller SJOps


    Oct 16, 2012

    Another well delivered project by Krusche. They have already started work on our next project and have been fantastic in helping us with tight deadlines.

    Project Description:*Private project for Krusche* Operations Log (3) 1. Running totals In the Daily Reports (template attached) the user has to input running totals for some items such as the Safety section. We would...
    Krusche has not completed any projects.
  • $90 USD In Progress

    Hi, I am in need of some visual basic to extract footnotes from word documents along with the sentence (or two) which proceeds each footnote reference in the body of the document itself. The extracted data will be imported into a FileMaker database so I could take it in a delimited format.

  • [Sealed] In Progress

    We prepare accounts for 12 doctors. To report to them, we generate a monthly report in Excel. The file has evolved to be 12MB! The report is generated from data extracted and compiled from our Access database and other spreadsheets. The report shows monthly work done, billing histories, accounts paid and so on. Different doctors do different amounts of work each month. Thus the report might show 5 transactions for one doctor and 100 for another doctor. In total, last month"s report included 398 new transactions and tracked a number of historical transactions. The report is used to calculate the amount we charge each month. I am interested in having the spreadsheet reviewed to ensure it is operating correctly and seeing what can be done to make it work more effectively (and less time consuming to generate each month). It is highly important that there be safeguards in place for the security of data (there is an amount of confidential patient information in the report).

  • $30 USD Jun 11, 2013

    i am a hard worker , my typing speed 30wpm and u send me any report i solve it

  • $180 AUD Dec 25, 2012

    I require an Excel spreadsheet to update historical news announcements from the webiress platform.You may be required to obtain a trial account to access the platform, located here: that the user has already logged in to the platform, I require a macro that will:- Takes the ASX tick code from a cell reference in Excel, such as A1 = "AGK.ASX";- Pastes this ASX tick code into the "Reports" tab of the "Security Info" sub-menu (located under the "Security" drop-down menu);- Requests the results; and - Copies (right click on the results) then pastes the results back into the spreadsheet.I have attached a pdf to more clearly demonstrate these actions.

  • $240 USD Nov 8, 2012

    Hi,I want an excel workbook with macros to show sheets depending on password input.The idea is that when someone opens the workbook it would ask for a password. 15 different people are goint to be working with this workbook, but I want them to be able to see and modify only the sheet associated with their password.I have a very basic knowled of macros, but i want to be able to modify it in case i have to add a sheet later on. I also want to be able to modify the passwords.

  • $180 USD Nov 5, 2012

    I need help in excel. I will provide more details in PMB.I need help in excel. I will provide more details in PMB.Thanks

  • $100 USD Oct 18, 2012

    Hey there i have a farily small VBA project that requires you to enter in Ten Pin Bowling data and sort it accordingly. it shouldnt take you too long. If intrested, i will send you the project. Thanks

  • $30 USD/hr Sep 26, 2012

    typing job

  • $250 CAD Sep 17, 2012

    The scope of the project consists of entering data into Jonas Construction excel templates that will be uploaded into our new system. The data is currently in excel as it will be exported from quickbooks and then re-formatted to comply with the Jonas upload template. The re-formatting can be done any way that you"d like. It can be manually entered if you"d like, but simply cutting and pasting might make the most sense. The template cannot be changed however in order for the newly formatted data to be uploaded properly. I"ve included a sample of the templates as attachments.

  • £100 GBP Sep 10, 2012

    We have a workbook with two sheets.Sheet #1 contains a table & Sheet #2 picks up a csv from the C:\ drive that is refreshed each time it is opened.The CSV grabs information from a database and is updated each night.The data comes from a restaurant.The restaurant has 8 screens in the kitchen which help automate orders. Each of these screens belong to a particular station in the kitchen ie. Grill, Bar, Pizza etc.The CSV data contains information on what transactions came on which screens, the time it took to cook (in seconds) and the actual time stamp.Time Stamp Kitchen Screen Time Transaction2012-09-04 23:38:42.440Main Bar 12860366592012-09-04 23:01:25.330Cutlery 37450366592012-09-04 23:01:25.330Desserts 271 036659What we need is to basically create a report - in excel.The data needs to be arranged bya. Meal Period (using time stamps) and to actually display that meal period. For example, breakfast would be between 4am to 11:59am, lunch will be 12:00pm to 6:00pm etc.b. The individual kitchen screens.The above will mean we will have 8 rows of kitchen screens for breakfast, followed by another 8 rows of kitchen screens for lunch etc.For each of the above, the average "cook time" will need to be calculated based on the data, along with the amount of transactions.Here are the steps to the report - 1 User enters a date or date range in the top cells (maybe a date picker?)2 The fields below will be populated with data for that specified date.3 IF the user inputs a range, then the fields below will be cloned below the previous set and the data will be put into there for each day.

  • €500 EUR Jul 31, 2012

    Hallo,das Projekt stellt eine Anwendung zur Kostenverfolgung von Kundenprojekten im Anlagenbau dar. Es können Angebotskalkulationen, mitlaufende Projektkalkulationen, Ressourcenplanungen sowie Ein-/Ausgaben-Planungen (Cash Flow-Planungen) erstellt werden). Ebenso kann die Anwendung zur Visualisierung des Cash Flows für das gesamte Unternehmen verwendet werden. Es dient als Planungsgrundlage für Umsatzplanung, Liquiditätsplanung sowie Berichterstellung gegenüber Stakeholdern.DieAnwendung ist von mir entwickelt worden und stellt einen Prototyp dar. Die Grundfunktion ist zwar gegeben, es werden aber keinerlei Fehler abgefangen und die Bedienfreundlichkeit und Optik ist auch noch nicht optimiert. Ebenso brauche ich Beratung für die Themen Schutz des Programmcodes, Lizenzierung und Wartung. Vielleicht ist es sogar sinnvoll, die Anwendung auf eine andere Plattform zu portieren.Es würde mich freuen, wenn wir hier zusammenarbeiten könnten, evtl. auch im Vertrieb des Produkts.mfg Stefan Breuer

  • $300 AUD Jul 25, 2012

    We require a simple task in excel : To build a database by macros, to enable a user to enter contact info into a form to populate an excel database and automatically generate a PDF or word document with those contact details added.* The user accesses the excel database from server located at our office (we can set this all up) and when a completed form arrives from the client the user inputs the data from the form into the excel database* This then automatically populates a spreadsheet (it is important that this user can not change anything in the spreadsheet directly bu we here in the office can) * When certain options on the form are ticked a pdf/word document is generated and saved into a folder in a server* We then here in the office print out that PDF/word document and post it to the clientAttached is the layout for the fields which need to be built to populate the excel spreadsheet.[removed by admin]

  • $750 USD Jul 13, 2012

    1) Student Information System:Basic info, Guardian info, Medical Info, Attendance2) Student Grade System: I will send an Excel sheetA database that allows students to keep track of their course grades, test scores, number of credits, and calculates overall GPA. 3) Monthly Tuition Payment Control

  • $30 CAD Jun 21, 2012

    I just need you to create a simple VBA prgramme for excel. contact me immediate to discuss further.

  • $15 USD/hr May 26, 2012

    reply to discuss further

  • $150 AUD May 15, 2012

    We have a Microsoft Access file that we use for basic CRM purposes that we need to be reversed engineered from MDE to MDB

  • $120 USD Apr 2, 2012

    Hello,I have a small game project in Java as a class assignment with class and sequence diagram. Most of it must be done by Thursday. If you are interested, pls contact me ASAP.

  • $120 USD Apr 2, 2012

    Hello,I have a small game project in Java as a class assignment. Most of it must be done by Thursday. If you are interested, pls contact me.

  • $720 USD Mar 29, 2012

    Design an excel spreadsheet and write a report based on the Guidelines for Marking.pdf for the criteria for individual project for the excel spreadsheet and the report. The project is to demonstrate the use of financial analysis model test depending on the grid you have chosen (examples: Sensitivity Analysis, Scenario Analysis, Monte Carlo Simulation, etc), to demonstrate the use of various function in excel and the use of VBA and to show in your model the model diagram identifying what are your inputs with sufficient use of form controls. You need to split your one page model into inputs, logic and output block into several worksheets showing your inputs.Samples are attached for your reference. Sample of Individual Project.xlsm and Sample of Individual.pdf are examples that one student is able to demonstrate to meet the requirement of the project.

  • $720 USD Feb 3, 2012

    I would like to have an In-House Dining Reservations/Banquet Room Reservation book created that can be shared by multiple users at the same time. It should also track all changes, noting the user make the change and update immediately for all users through Excel"s Shared Workbook feature.A template for one day is attached - ideally the user would peruse a calendar, then click on the date desired to go to that date. Should also have the capability to "Flip" through pages. Should cover the next 4 years. (2012 - 2016)

  • $250 AUD Jan 30, 2012

    I have a completed spreadsheet and merge document but the data just wont merge properly in one field. A fairly simple job for anyone with a bit more than basic Excel ability

  • $240 AUD Jan 6, 2012

    Repair macro"s for simple data entry on the attached spreadsheet and create 2 other similar workbooks.

    Krusche does not have any open projects.
    Krusche does not have any work in progress.
[see more]


[see more]



MS Office solutions with VBA

Jan 2011 - Present (3 years)


Complex and simpler projects at Please check the Feedbacks.



Rheinisch-Westfälische Technische Hochschule Aachen



Certified Software Tester