Jay Patkar has been a freelancer for four years now. He has worked on 300+ jobs. Now, he owns his own business and travels all over the globe.
...uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management
...table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and
Excel Add-In joka hakee ja tallentaa taulukkomuodossa oleva...hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
...relevant month’s Overheads MM/YY sheet, I should be able to pick up the numbers from the “Overheads ESSBASE” Raw data file by doing some sort of Drop down list function, Macros/VBA code, etc. so I don’t have to look for new G/L code AND Cost Centre combinations manually. Tip: You may not need to work with all the columns back on the “Copy of Overheads
I need data entry for ( TASI ) which is Saudi Arabia Stock Market with full analysis of all stocks that is updated live with p/e ratio , stock predict direction and everything possible. Please bid if you read the project and understand it and have ability to do it professionally
LINGUA ITALIANA Mi serve un programma realizzato in VBA Visual Basic di Microsoft Excell, e quindi mi serve un programmatore esperto di VBA. Io utilizzo la Versione Microsoft Excell Pro 2010. Ho gia preparato il FIle Excell che accogliera' il Programma (Alcune Immagini allegate) e la Descrizione di tutti i passaggi che il Programma deve fare con
...send and receive data from eBay using their REST API calls, using my MS Access 2016 database. Only experienced freelancers need apply - who have successfully written Access VBA calls using REST to ebay (or another site requiring an oAuth key). This project is difficult if you've never done it before, but I have seen other projects on freelancer with
...pressed 2. Cell B1 is an input cell for how many iterations i want to run 3. Starting in row 7 is pasted value data of one iteration of the data in row 3 I want a simple VBA code that will loop through a procedure to copy and paste value row 3 data determined by the number i put in cell B1. I also want to add a status bar at the bottom of the sheet
Hi there, there is data I would like to scrape from a website that uses a websocket API. I would like the su...there is data I would like to scrape from a website that uses a websocket API. I would like the successful applicant to create some code to get the data I need by ONLY USING VBA OR POWER QUERY. Please do not apply if using any other platform.
I have a data set and would like to get some KPI's out of it. Basically, all the information is present in the data set, just need to visualize it and automate the process where anyone can just add data and everything gets calculated and visualized automatically. Fairly simple task shouldn't take more than 1-2 days
Attached is the sample ...the sample project I've put together. I have some VBA code as well. Currently I need to apply the formula for 25 rows, and if a3 value changes b3 should say Please select, if b3 changes c3 should say Please select and if c3 changes d3 should say Please select. I am kind of stuck to implement the VBA logic in the speardsheet
Need some with strong developer experience to build a macro with VBA to update a webpage. This will also need you to have excellent web development skills Send me sample of projects that you have worked on. Right candidate will be chosen on the samples provided which are close to this project's requirement. Duration to complete this project 2 days
Hi I am looking for a VBA expert who can write clean code. This is a repost and please read carefully before bidding. The task is The task is putting a button on Excel (with predefined columns) and implement document generation from document template which has mergefields from the excel file. - An excel file is given. - There is a document template(docx)
I need someone who has excellent knowledge of excel formula to provide me the vba formula or similar to calculate the cost of stocks that were purchased in different quantities and prices than what they are sold at. EG. (purchased 1000 @ .50, 500@.57, 1200@.63) (sold 1075@.68, 125@.73) etc. What is the cost base of the 1075qty sold at .68 based upon
...spreadsheets utilizing VBA and a little ms access. I would like to know if you can take the documentation also with understanding the VBA to create an Access Database that will present the correct data. Must be able to highly knowledgeable towards being able to improve and modify excel VBA to perform automation and combine multiannual VBA macros to run precisely
I have a set of instructions that compiles a group of Excel spreadsheets utilizing VBA and a little ms access. I would like to know if you can take the documentation also with understanding the VBA to create an Access Database that will present the correct data. MS Access DB. Importing and exporting different sections of spreadsheets and manipulating
Description This job is for mid to senior Excel/VBA people. Please do not apply if you paste code found from Google. Your code will be edited/maintained by other people, so it must be modular, clear and concise. Only take this job if you can complete it comfortably in 2 days. I need this job done quickly and have another similar larger job straight
In the attached photo, you can see a list of my potential clients. I want to mail each one of those clients 6 different letters. The letters are Word documents that will use the information from the spreadsheet to populate the letter. Each letter is generated and sent out on a specific day. For example, if you look at the attached picture, on 6/14/2019, there will be (9) Letter #3, (4) Letter ...
We are a UK based renewables company working on a number of projects. VAT is a tax collected by HMRC the UK tax office. HMRC's making Tax digital system for VAT requires VAT submissions to be made electronically from the 1st of April 2019 using authorised software. Qmulus requires a spreadsheet or similar system which will allow the submission of their quarterly VAT submission in a way whi...
Hi Alhasan A., I noticed your profile and would like to talk more. Our company outsource excel work every month so we will need a number of excel spreadshe...noticed your profile and would like to talk more. Our company outsource excel work every month so we will need a number of excel spreadsheet every month. Some of them will require VBA and Macros.
...budgets (time sensitive) - Rack & Stack (Ranking Reports) - Inventory Reports - Employee Bonus Files (time sensitive) These files require Classic Excel experience but DAX, VBA (Macros), Connecting to SQL databases is a plus. [kirjaudu nähdäksesi URL:n] Please let me know if you have any questions
...user by having you create an Excel spreadsheet. The spreadsheet will need to pull the supplied data, format it correctly and also do a small amount of CRC calculations using VBA code. Please review the documents to see the details of the project, the expected layout for the 2 main tabs and examine the supplied CSV files that will need to be populated
...templates and Custom spreadsheet solutions for global markets and market them via our website. We are constantly accepting new teammates who are extremely skilled in Excel and VBA. So, if we like the quality of your work, we will offer many new tasks after this one. To understand the structure of our templates please check our website below. https://www
I am looking for a VBA programmer who can automate the data tranformation and reports creation from raq data in excel. Req: 1) cosume data from a raw csv with a click of a button 2) Transfrom the extracted data into desired format to be able to consumed in the report 3) populate data into the predefined reports Imp: Right now the data is extracted
Export all fields of Outlook Email Columns into Excel (Messages shall be in one field only). one button to be pressed to show which folder to extract. only VBA code is required in module that can be imported to MS Outlook 365
...Date CAFC Appeal Date" where "CAFC Appeal" would be yes or no and "Determination" might be "cancellation', for example Setup is the same as the prior project, to use Excel VBA macro, and delivery the source code. If there is anyway to speed up the scraping without overloading the docket navigator site this would be a plus....
I have a...Before the program runs, it should ask the user to input the phrase to look for and then proceed. I don't care which language is used to write this program but would prefer VBA or something easy and fast. The selected freelancer should be willing to provide support if I find a bug in the program, let's say, one month after the delivery.
I...can't find a commercial billing system that's a good fit for my business model, so I believe building one from scratch is the way to go. I have some experience with Access VBA, but I was never very good with it. I'd prefer to have something built in Access, but that's probably not a deal breaker if you can make the case for a different platform.
I need a Small copy and paste "[kirjaudu nähdäksesi URL:n]" I need it to "send Keys" to another application (Bluezone mainframe display) Retrieve some numbers from that Application, Paste in Excel. It then needs to take the Numbers from excel in Cell H4, Paste back in the Bluezone mainframe display, Hit enter in the application, the repeat to cell H19
I have a spreadsheet with 32k lines I need to insert data in between each of the 32k lines looked up from a separate excel database. Kind of like a VLOOKUP but the data inserted varies in number of rows so the function must be dynamic. Then the file needs to be saved into blocks of 1000. Initial project is 32k lines but over the coming weeks there will be 2 million+ split into separate blocks, ...
I have a number of daily reports that require exporting data from SAP to Excel and formatting it into a report. I have already written working VBA macros that do the formatting. I have to manually extract the data and run each report macro individually. So much time could be saved if my macro could just go into SAP, grab the data for report #1, format