...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'm looking for a full time (40 hours per week) virtual assistant for e commerce data entry. Need to work 8 hours everyday. You must be detail oriented, organized, and able to follow given instruction. Tasks are fairly simple. Familiarity with Google spreadsheets and Amazon website required (no expertise required). Enough English to communicate instructions.
Looking for an high professional who will develop our long term CRM project. Functions: - Multiuser - U...CRM project. Functions: - Multiuser - User groups - Contact management - Staff management - Task management - Document center (PDF Creator and Designer) - Trip planning - Roster This CRM App should run in a Webbrowser and also as a Android App.
I have multiple excel sheets that needs to be formatted and put in a good shape. most of the work is excel sheets and managing few documents. apart from this email handling is also involved to some extent. if you have experience with any admin / assistant job then it will be a plus. looking for someone who can work for long term. Thanks
I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month
I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.
- Google Sheets expenditures tracking and management tool
##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File
...them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followed by the contents of cell A1
Use the script here: [pro zobrazení URL se přihlaste] and extend it to automate the capture of the variables from the 'item posts' sheet here: [pro zobrazení URL se přihlaste] and put them into a new copy of the template here: [pro zobrazení URL se přihlaste] I've already started the modification of the script here: [pro zobrazení URL se přihlaste] but ...
I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", an...
Looking to scrape data from our current site and organize the compiled data into 2 excel sheets. We also require to download all images and match those image in the sheet. Please PM for sample output template and site to pull data from. Thanks
I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.
...DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Or...
Advanced VBA needed in 24hrs
Hello, I have a small Excel VBA project to be completed. Data is not large but needs to just be automated to fill data to a template. Need a good knowledgeable person to help me out. I will send the files later. Need this to be done around this weekend so you need to be available then. Budget -10$. Any bids for excess value will not be considered. Thanks
Hi, if you are an expert with VBA, access and word, this project will be very easy for you. I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it: Functionality Each "client" entry has multiple invoices and each invoice has multiple billing
You need to go to the links found in the upoaded file one by one. There you will ...file one by one. There you will find a list of people. You need to copy for each link the names and all the additional info found, if there are, into an excel sheet. Each link on a different excel sheet. (same file). It should take max 1 hour for a skillful data miner.
We require a ...within that board every 24hrs. See Mondays API here - [pro zobrazení URL se přihlaste] If this cannot be done with Mondays API then this will need to be done using Google Sheets with the same principle that our Custom amazon orders with custom text are imported into a google sheet every 24hrs. I need some insight if this can be done.
I would like to build a tool that will allow us to better manage our user lists and service Providers. Function: I would like an excel to hold the following data: List of all teams List of all users in those teams List of all service providers contracted with those teams and the budgets Contact details at service providers Email text The above data
We habe a little Rental Management System in Excel. Now we need some VBA funktion to Create a Picking list. what is to do ? 1.) Every device has a button whit his special information in it. So we have to develop a function that will save this information. 2.) we have to put with checkbox selected devices to a picking list on a another sheet
We have a set of tools in excel, that uses VBA, we need to fix and optimize some macros in excel
I have an excel sheet which will keep on adding new worksheets or deleting existing one. The current VBA code, creates a table of content, with the page number for each worksheet. However instead of the page number, I need the first page number of the print preview page for each worksheet. Attached is the excel sheet, and in the cover worksheet, I have
Ok I need someone that is highly experienced with Zapier that they will be able to work out how to setup all my Sales transactions to auto add into a Google Sheet. So the flow will go like this: Sale Transaction -> Zapier -> Increase A Specific Google Sheet (Based on date) Cell by +1 And then it will recognise the correct position every time.
Hello, I'm looking for a freelancer that specializes in Google sheets and excels. I have a couple of projects related to this area. I only want professional bidders with portofolios. Data cleansing & organization Conditional formatting Formula writing Custom reports Charts & graphs Dashboard development PDF generation Task automation via Google
- I need someone to work on my Excel VBA project. - Lots of worksheet referencing, saving as PDF, message box, etc. - The excel spreadsheet attached should list everything that needs to be accomplished. Any other questions can be asked upon confirmation.
...Store the valid IDs in an array. 2– Accept employee data input from the user in the order below and at a minimum perform the listed validations. Field Employee ID Last name First name Hourly pay Validation 5 characters, first character must be ‘A’, then a 4-digit number. 2 – 15 characters, no numbers 1 – 15 characters, no numbers a numeric value > ...
I have tried to get th...have tried to get this to work for over 3 hours now. Don't know what I'm doing wrong. Please save me before I die from sleep exhaustion :) I'm just trying to connect to google sheets api from python. Start your bid with the word "oranges" so I can filter out any spammers thanks. You will connect to my computer via teamviewer
I am wanting to create a dashboard for google sheets that allows my company to track our key KPI's for individuals. But I also want it to automate colour scheme based on whether the KPI is high, medium or low.
I need some assistance in creating a windows app in VBA that will calculate the cost of a dish. Need to show at least 20 dishes with ingredients in the drop down list. More information is in the word document named "How to Calculate the Cost of [pro zobrazení URL se přihlaste]". Also included an excel file that is named "[pro zobrazení URL se přihlaste]&q...
There are 535 people in my LinkedIn profile that I connected which suits "restaurant owner" keyword. They are all 1st level connections. You ju...people in my LinkedIn profile that I connected which suits "restaurant owner" keyword. They are all 1st level connections. You just need to import their name, company, email and website to the google sheets.
We would like to get a simple macro if you are familiar with VBA in excel. The base is an excel sheet with a few hundred-thousand building addresses. For each address, a link to a pdf exists. In this pdf, on page 1, multiple data need to be read out and put to the corresponding address line. On page two it should be counted how many "apartments" are