...měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dokumentace, kt...
I would like to have someone who is proficient in excel and VBA to build a simple calendar scheduler and student enrollment forecast in my excel with the data set i have. On top of that, i need someone who is good with formulas such as index-match to assist as well.
Standalone VBA macro that will compare any two csv files based on a key column (in this case 3rd one) and create a new csv with differences (could be changes to existing rows or new rows). Needs ability to define the delimited (comma or semi-column) and ability to convert date fields into numbers
Does anyone know how to write a small VBA code to automate a process of pulling data from a website into a spreadsheet please .. Has to be through VBA so if you don't know how to write a VBA doe please don't apply for the job ..
...via all three output methods below: 1. To google sheets 2. To CSV Text 3. In JSON Code/script/app hosting/execution: I would like advice on how to automate this on a daily scheduled basis with existing hosted providers, such as Integromat, Zapier, Apify, Google app script, Google sheets or similar, that provide free access for private hobbyists
I have an excel vba solution that produces a text file from a spreadsheet. This text file is currently imported into MYOB AccountRight Time Sheet module and the Payroll is then prepared in AccountRight. I need a VBA programmer that will take the text file and send it into MYOB AccountRight In The cloud. So no need to do the importing. please see http://developer
...of this needs to be: For Employees: - input their availability for multiple locations by day and time up to 4 weeks in advance or setup permanent availability - View their roster by week, day, time and location - allow them to swap shifts with someone else - Allow them to enter/confirm their attendance for their allocated shift For Manager - View availability
I'll explain what I need. I have a folder in google drive with many google spreadsheets files inside. Every file is shared with a specific user and is named with a code associated at that user. Example: file 123456 is shared with user 123456. Furthermore, on my website there is a Mysql table called "all_orders" that collect every order related to al the users. Example: user |...
Hi Milan S. You did a few projects for me a while back and they were great. I have another, if you're interested. Here's the project description: I need an Excel VBA macro that, when a button called "Midnights" (placed on a sheet called " Operator Sheet") is pressed: * It deletes the contents of cells B3 through BT on a sheet called "Shift Lead S...
Hi there, I'm currently working on a VBA code which aims at extracting the data of a particular searched address(like area, zestimate, rental zestimate, tax & year of tax). I'd like you to develop code within the next 10-12 hours. The code if accepted may lead to various other project proposals by the client. Only serious bidders required
Hi, I am using an excel documents that has a few input sheet and based on various formulas, several output files are generated. These output sheets has a few charts. The initial coding is done, however I need someone to finish it. Should be a 15-30 min job if you are efficient in vba coding.
We have approximately 2,946 English reviews on TripAdvisor. We would like to copy/paste the Subject of the review and the Review itself into a google spreadsheet. I will send the link to the page as well as the spreadsheet so the project can start. We need this complete within the next 10 days.
We need a VBA developer that can interface the Excel engine with our Access database so we can run reports for our clients. We would most likely need only a few hours of work every month. Someone with applied mathematical skills and knowledge of Bloomberg would be a plus.
...Imports" I want VBA Code to upload each of them. When they are uploaded, I want to add the Date the information was uploaded added to the second to last column and to add the UserID to the last column (in each of the three tables). The code shouldn't run all three uploads - I want code for each. I am assuming you don't need the excel sheets and you can
Need to build a module for my mobile app to display content from google sheets to my self-built mobile app (android + IOS). Whenever content from google sheets changes it would display on my app accordingly.
- I have created an Google Sheets/Excel document with data in multiple tabs - I want a button on the Google Sheets which we can click in order to generate a Google Slides/Powerpoint - This GSheets/Excel document will be used for reporting of many events, so we can't manually link the GSheets/Excel data to the GSlides every time or for every document
Our company has quote sheets that are made in excel format with jpeg photos. Our staff creates 2-3 different styles on their own. I need to have the quote sheets updated with new logo, date and address to make our quote sheets look the same. The details on the info must be moved into its designated cells. Attention to details such as matching fonts
Hello, I have a lot of email addresses in excel. I need an excel VBA to send emails with a pdf attachment automatically. The text of every email is a template, but the VBA must chose the salutation correctly. Thanks for your help.
I need to attach images from a folder from my PC (I want it to be prompted while running the macro regarding which folder to select) basis multiple Option Numbers (please refer file). The macro should look for images from the folder and insert it on the left side of the column (Specified for image) and the rows should auto adjust basis image height and width.
Research basic information about all of the hotels in TWO Midwest US cities- Temple, Texas and Longview, Texas. Information will be found online and/or by calling the hotel. See the attached spreadsheet.
...for the e-mail and a button and make sure the script sends that e-mail to a fixed e-mail-address. 2. Excel-VBA: Again - I only want the code - I will install it and tweak it myself. The program should fetch the Google Forms data and put it in Excel. The data to be fetched is filtered by the e-mail the user of the Google-form has given. In your code
I need a VBA script written that can insert row data into MS Word and MS Powerpoint and then add an entry into MS Access. The script should prompt the user for the row's primary key (number) and then retrieve that data from the table and insert it into the word or powerpoint document at a specified bookmark location. Simultaneously, a new entry in another
Develop a macro enabled excel file that has the following functionality: 1. Reset all sheets 2. Reset individual worksheets 3. Import a HTML file 3.1 Import 2 tables into a sheet 4. Export / save the file – name based on several Inputs
to create a utility using vba, functionality of the tool - open and parse a source file (PO file, attached), PO syntax can be found from [pro zobrazení URL se přihlaste] - for each message to be translated, ie. the message after "msgid "/"msgid_plural", call a function convert(msg) -> just return msg in this function