Need a WFA to P...Pull data from google sheets and push into any database. there needs to be a config setting where the user can specify the URL of the spreadsheet, google credentials, the sheet they want to import and then the SQL server details, should not matter if it is cloud or local. the user will specify the table in the import. Read Less
Fill out Columns E to J of Google Sheet. Columns include: Rental Demand Average Daily Rate Occupancy Rate Revenue/Month Active Rentals Rental Growth Rate (2011-2018) All data can be gathered via free trial on a website that will be provided.
Create a one page A4 pdf product sheet for the BetterLiving Mobile Shower Commode as per the attached brief using same template as the Ultra compact wheeled walker. Please also find attached the BetterLiving Mobile Shower Commode User Guide for reference.
...need an excel file to filter tables in an interactive way (working with macros/vba etc.) What i need is showing different locations (tables). After clicking on an item, there appears a list of different items. And when you click on a specific item, you see few data numbers (results). See this link about vba [login to view URL]
...which should allows users to Add more times and when submitting the form data to database, multiple rows of data with same values should be added with only difference in Times.. Example: Column 1, 2 and 3 data should be repeated and inserted in 5 rows IF there are 5 add more Time value filled in.....
...cells in the main database with minor manipulation. Looking for an expert excel/VBA freelancer to assist . Sheets DQ-45, DQ-46, DQ-47 & DQ-48 are identical. However they represent 4 different people who move to various locations . On each location various activities take place Sheet 5 represents the various activities that need to monitored. Data will
EASY JOB! Have to create a Table where there are 3 Questions where you have to insert an X into that table. There have to be 92000 Rows. Just add the X and Scroll until this number. Or you have a script for this.
I need and expert in Visual Basic for Applications to create Macros in order to automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information. We take the financial statements for ten banks
I need data exported into a set format that will be provided. The contact list needs to be kept confidential at all times. The client list is the template to be used to insert all data. Data needs to be taken from the emails the end of the email address will have the contacts company name. Please use the first name to add into the contact name i.e johnli@[login to view URL] will go under con...
we have a database in Microsoft Access and we want relied this a management planning for our drivers. please disc...Microsoft Access and we want relied this a management planning for our drivers. please discuss in private for more details not need you share with me your other skills, I want only VBA developer and if you share other skills I not reply
I need a VBA script that will use the spreadsheet and create outlook emails that will send to each individual recipient listed. Example email body: Hello, I see that PO# (value from spreadsheet) was not picked up yesterday. Can you please advise if this freight is ready for pickup today?
Hello! I have several hundred facebook friends who aren't really friends, but busine...of years. Facebook doesn't have a simple "export friends list" feature, so I need someone who can go through my list of friends, and enter all their information into an excel sheet that I can import into my CRM. If this is a fit for you, please let me know. Thanks!!
Build Web Based or Google Sheet based Reporting Tool , data to be pulled from daily email in which excel report is an attachment. Reporting has to happen as per data in excel sheet and applying some more formulas. Reports should be historically available and on applying appropriate filters, weekly, monthly, yearly views can be presented. If it is a
This project is to prepare the attached material as a professional A4 handout. The company is Red Nose ([login to view URL]) - please refer to their website to get a feel for style and use their logo. Thank you.
Need someone expert in Excel. I have an excel file and i want to translate it in English. Also it downloads data from web, and i need to have it online, so i need to transform it into a googlesheet file.
hello there, I need to prepare a document how to distribute the tips among employees. So it's simple document( if you know ho to use excel of course;) Total amount must be distributed among 50 people and 20 will be on fix amount and 30 on a tip point ( so ex-0,5 its 50% of a full tip point 100%). Total amount must be equal the amount I will insert
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a
I Have a excel sheet in which there are about 20-30.000 serial number, you have to copy 30 number then paste it into my software which i will give you. then submit it, again copy another 30 column paste it. only copy paste. it may take some hours or one day.
Hi, I have a VBA code written in excel file (macro). It performs the calculations. I will provide you the code and I need someone to provide detailed description for each line of the code. (eg. how code works, what each line does, what each line means etc.)
Hi Guys does anybody have the knowledge of perdisco. Just need someone who can put the Adjusting entries information in the balance sheet, sale and purchase Journal, cash receipt Journal, cash payment journal, ledger. Using the following information, you will record end of month adjustments: Perdisco’s Manual Accounting Practice Set. This VirtualTutor
I just need a form where I can enter details and that should be added to my access database, it's very simple. You should only use VBA code in MS Access, no other language or inbuilt feature of MS Access. I will give you all the table related information
I need you to fill in a spreadsheet with data.
Need VBA to sum numbers. First, the VBA looks into column B to identify product category. After it looks into column D. In column E it creates the sums with a MAX value of 800. As you can see on the picture we have many sums within the same product category.
Hi there! I have been working on an excel vba macro that transfers data from one workbook to another. The part that I am stuck on is how to transfer several rows of data from one workbook to another and at the same time setting things up so the next time data is transferred, it will go under the previously transferred data. The majority of the macro
We want to create a selection program in Excel that sends dimensional parameters to dwg files to modify drawings according the Excel output parameters. In the attached example, we might want to change four dimensions, currently "800 Channel", 1080 (vertical dimension, middle of drawing), "1067 (25% BLINDED)", and "1008 (CLEAN)". We would want th...
Java desktop program needed to Insert rows into mysql on aws lightsail
...even consider your offer. I have written a complicated pricing program in Excel and need assistance finishing it. For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able to start immediately *Be available for hourly work over the next
I'm looking for a Finale file or MusicXML file score to be created from the sheet music attached. This project: Saint Saens Danse Macabre violin and piano version.
I have a Google sheet addon(with google script) and it is already published to use privately. The problem is: When I install that addon in one google spreadsheet and set my preferred language(eg. French) from a select box on startup. And If I use that same addon on another google spreadsheet with English as language, The settings got changed in
Desired output is an Excel (Mac Version 14.7.7) spreadsheet which prioritizes restock from vendors by sales volume and/or profitability. Inputs are two data files exported from Quickbooks ("sales" and "stock") which are attached. Note that these data export files can be modified to some degree if required. Also, "sales" data file includes data for all
I need a faster VBA macro. It's important to mention that the data I intend to scrape needs expanding to view the data required. It's like vertical tabbed content if you will. XML http is faster you can use it or other way but goal is fast vba. Apply if you can deliver this and pls do so within my budget.
...and gives a dollar cost depending on data validation options chosen. The table is about 10 rows by 10 columns. I would like this to be accessible on a wix website. It must be dynamic (so the website visitor can change the data to get a price depending on the sheet rules). I will assess bids within 24 hours, please only bid if this is something you think