... Item, Color, Size, Qty on Tab 1 (the data on this tab has multiple repeating records) SKU, ,Item, Color, Size on Tab 2 (the data on this tab is a lookup table) I need a macro to run and do the following : 1. Do a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating records in a new spreadsheet by
...company) airport shuttle with the right odoo tools to handle customer enquiries. The shuttle software can be easily custom configured. It should suited for offering airport shared ride and charter transfer services. 1. It should be created a shuttle tranfer odoo website 2. Clients should book a shuttle transfer in a few easy steps and choose how to pay
I am a telecom engineer. I need to get an Excel Macro developed for a large Excel sheet with a block of unique information consisting of 23 rows repeated 2100 times making the total number of rows to be about 48300. I need to add 3 rows of unique information to each block of 23 rows making it a total of 26 rows making the total number of rows 28x2100=54600
Hi. I need someone to build an Excel VB Macro that, when run: 1. takes residential property query field data from Excel provided by the user (e.g. postcode, number of bedrooms etc) 2. runs a search in "[login to view URL]" based on that query and 3. copies the results from that web query back into the Excel sheet. For example, the query contains information
Induction motor needs to be driven using battery bank. Required voltage range is up to 500 V and frequency range is from 40 Hz to 400 Hz. You are free to choose battery technology, their combination or whatever. Let me know your relevant experience and final bid amount for the project. Write Inverter at the beginning of Bid, so I know you understand what needs to be done. Without it, your proposal...
1) Windows 10 pro, Excel 2016 2) User should be able to identify target folder for process to run on all excel sheets in the folder as a batch. 3) Source data is Excel sheet (no more than 4 columns, and max. 100 rows) 4) Output is csv (12 columns, and no more than 100 rows) 5) Some columns in source will be split into many columns in output
Create a Macro in EXCEL: 1. Count the number of spelling mistakes in a cell eg: "The lanb is a world beest" Count = 2 2. List the all the spelling mistakes in a cell eg: "The lanb is a world beest" Mistakes= lanb,beest 3. Exclude the spelling mistakes based on the word count. eg: if we say letter count as 4 then if word "cat " is misspelled then it
Looking for someone savvy with VBA (Excel) - essentially good with macros, and linking this to Word. In need of a workbook that can serve as: 1. an upload tool (for a list of questions) 2. a db sheet Q&A format, for the search tool to search for matching answers to the input questions 3. a functionality that will take the matching questions
The original excel file has one sheet and output should have 3 additional sheets than the original: 1) extra sheet1 (just a selection of columns from original) - date filter 2) extra sheet2 (some pivots should be created in this sheet) 3) extra sheet3 (a new selection of column from original) - date filter 4) vba code should have comments and be explained
I need a macro or bot created that will do the following function. 1. Login to Google voice account 2. Sent text message 3. Record any response to text message to file The macro/bot should support doing this for a list of multiple accounts pulled from a .csv file with the following fields. Google Voice Account Login, Google Voice Account Password
Call variation description globally for all variable products in Woocommerce on select of variations from dropdown on product single page.
...interface ( like a small app ) or excel with Macros file where i can put all my soccerplayers in. I am a Soccer Coach and i want to have a Database where i can put all playing times, assists, goals scored, exchanges and some other information in live time during the match... so it has to be a easy interface. So i can see exactly how many minutes one
...need to create an excel macro file, it is very easy and fast work. all the details are attached in the files attached include a sample excel file. i need this done very fast, preferably within next 1-2 hours if possible i am copying the list of details about macro function again, it is attached in the text file also:- the excel file details are as
...i need to create an excel macro file, it is very easy and fast work. all the details are attached in the files attached include a sample excel file. i need this done very fast, preferably within next 1-2 hours if possible i am copying the list of details about macro function again, it is attached in the text file also:- the excel file details are as
...within next few minutes if possible i need all data in different columns of sheetA copied 43 times in sheetB, when i run the macro For example: sheet A: columnA columnB tex1 text1.1 text2 text2.1 then when i run macro, in sheetB i should get columnA columnB text1 text1.1 ... ... copied 43 times text2 text2.1 .. ... copied
Hello Freelancers, I want a macro or visual basic code to extract the data from PDF to Excel Automatically. I have PDF and sample. Dont get forget to mention you offer I think it is not more than an hour work. Happy bidding
I need the script of macro to sort my spread sheet. I need something that I can use myself on a daily basis. The attached file should be sorted based on the name of the city - which is part of the string in the first column. Each city should be sorted out to a separate sheet (if possible). Please type the word "Root Beer" at the end of your proposal
- I'm a programmer, i'm integrading woocommerce with a stock manager system, my problem is when i try to set the attributes of the current variable product, they save in the data base the name of the attribute insted of the slug, if i go to the database and change it, for example the post_meta attribute_pa_color the value is equal to 'Black (example)'
Excel macros play an important role to perform repetitive operations in excel. It takes lot of time, when handled manually. I have done quite good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Text to columns
I need you to create a macro for vehicle that are changed. For example, if a customer wants to replace a white bumper with black then a parts list is generated. From that list of parts a quote is created. Basically, it's a option pricing. If you think there is better way to do it on access or any other way then please let me know. I would like to
Hello Freelancers! I have this project in C language for the end of month DESCRIPTION: Implement four(4) FIR / IIR FIL filters, the filter types will be (High pass, bandpass, low pass, notch filter). The cut-off frequency of each filter will be set by a potentiometer and will start at 1kHz. The type of filter will be determined by typing a button. I'm sending you a photo of the board wit...
I have an Microsoft Word document and i want to add a dropdown list to one place on the document. It will contain 3 peoples names - Steven, Darren and Michael....If darren is selected (location A) on attached, then darrens email address needs to be placed in the footer (location B) and his photo shown on the document at location C. If michaels name is selected, his email address and photo needs to...
Excel expert needed for a small job Iv added a new column to my excel file and my macro has producted an error [login to view URL] Before macro use to produce a sheet with last weeks bookings now i want to create a sheet with some of the columns hidden. Should be an easy job and my budget is 20 or max €30
...that this will run in an office environment that has a macro blocker in place. Simply put, macros or hotkeys don't work (AHK/Jitbit/etc). The only way for it to register input is from physical keyboard keystrokes or mouse movement. I need some custom software or alternative solutions for this. I can accept it working on either mouse or keyboard. No need
Hello there. I need help with VBA code in Outlook 2016 so that: When email from "no_reply@[login to view URL]" is received in mailbox, sub "OpenFile" is called. and msg is saved in "k:/files/" as "[login to view URL]". Date should be "year-month-day" and time" hour-min" thank you..
Upload the wordpress Variable Product with Price Based on Weight 250 Gr | 500 Gr | 1 Kg - 2 Hours Job, or share some tool.
We have an existing macro in excel (created by another freelancer many months ago), that needs some slight modifications done. The macro It was designed to work with multiple .txt source files, but now the source file is just one big single .txt file. The existing script loads values from a .csv finance file and uses that to make calculations in a main
i have two sheets in excel,i want combine rows in one sheet if match with particular column value in excel
I have a job that pays me weekly on Friday. I am a strong believer in giving every £/$ a job and I want to make sure that every last £ from this goes towards my savings. I would like to automate the weekly transfer from employer A to Payee A (my savings account). Currently I have to (1) Log into the Barclays mobile banking app (2) Look at the amount paid that week (varies due to ti...
I create new project workbooks based on predefined templates from many existing workbooks. What I would like is a new project workbook with drop down menus that lets me choose sheets from different workbooks and copies all selections to the new project workbook.
I have an excel file with 384 input columns and approximately 86000 data point. each row represents 1 second. I want you to write a macro that would take each column copies it and provides an adjacent column with 5, 10, 15, and 20 seconds delays. Simply the column gets copied, inserted next to the original one and the data is shifted down 5, 10, 15
Hi, I would need a quick VBA macro, The task is relatively straightforward: As per attached, there is an excel file with data only in two columns, A and B. For column A you have data for all of the rows, For column B you only have data for some of the rows, The macro should loop through the spreadsheet and copy the content of column A to column
Statement of Work attached - this will be the whole project (with some potential small adjustments)
Start your bid with ***EXCEL*** READ THE DESCRIPTION CAREFULLY!!!!! I need a microsoft excel expert who is highly experienced with advanced excel functions, variable product CSV files and WooCommerce (WP all import). I will give you a CSV file with one product on it, this CSV file has two extra columns which will be the variations, in this case the
creating a new options to select by department or cost center or both
Dear Machine Learning experts, I am looking for a python based tensorflow solution which can classify images for the following cases. 1) Color-cast vs Non color-cast images 2) Black & White (or Sepia) vs color images 3) Blurred Photos vs normally sharp photos I have a database of 2000 images for each classes. The main challange here is as follows
i currently have a file that after 10 days of a completion date the history move to the 2nd sheet. the problem i'm having is that the history overwrites the data and i want all the data on the 2nd sheet to stay and keep.