...a user to search for a product SKU, then imports that data to a specific sheet for that button. The sheet no longer functions as originally intended, so we are looking for a VBA coder to either help restore the original functionality, or to create a new sheet that does the same thing. In addition, we would like to be able to export the information to
I use excel to do the purchase order, and I want to make VBA to make the process easier. I want to pre-defined some class and variations for each individual product, so the VBA will base on the product's class and variations to perform different calculations. I have included an example excel sheet. It has the detail explanations of what I want with
I have a workbook in excel with a macro that opens and searches for a string in PDF file. Now I would like to automate following; list of strings in column A to be searched in the PDF selected via file dialog and return the page number in column B Attached is the excel file (macro enabled) I use excel 2016 and Adobe Acrobat Pro DC
I need webscraping of [kirjaudu nähdäksesi URL:n] site's derviative open interest data with 15 or 30 min refresh interval and to get the same integrated with my existing vba worksheet which is updated with previous end of day data and compare the changes for the same
I wold like to create a macro that I could paste in to PowerPoint v16 for Windows / VBA that would save selected slides in the slide sorter as INDIVIDUAL powerpoint files whose file name corresponds to the slide number in the presentation
Hi I am...[kirjaudu nähdäksesi URL:n] I need all the information contained in the table for all years and pages. I am looking for an excel button with a VBA script linked to it. The output should be in the form of a table within the same spreadsheet Further information will be provided once I have selected the freelancer
...workbook each day and manually clicking the Macros VBA button to run a data scrapping process. I would like to set up an auto schedule to run this work book each day. There a few other steps in the workbook and process which I want to automate the process. Summary of current workbook process: 1. Click Macro VBA button to run data scrapping process 2. Copy
Hi All, I need very advance and VBA skill to finish this small project I have sheet for the data (DE) i need to great report in the template in sheet (Call report for customer ) by choose the customer name and the date and automatic report copy to the required sheet (Call report for customer ) before you make any offer please read and review the
Hello I am looking for an Excel/VBA (Visual Basic macros) expert to assist me with developing a loan pipeline and securitization model. Ideal person would also have math / securitization / structured finance skills. I would like to model loan and bond cashflow waterfalls. I speak English but the loans are in Latin America so Spanish speakers would
...need a VBA script to handle incoming orders on my eBay store. The handling process includes confirmation of availability in stock (exist in an excel file), confirmation of the payment status (that appears on the PayPal transaction), comparison of the shipping address (that appears on PayPal and on eBay), etc. The script will need to access web pages
need a vba script where depending on brand name in column can match to email of company
Re design an excel log, must be proficient in Excel Dashboard, Macro, VBA. Fluent in English, with a strong statistics back ground.
What the Macro should do: If I put the cursor somewhere in the text of a document, I want that a macro runs which (i) Inserts the word "Exhibit", (ii) Inserts the current cross-reference of the paragraph where the text cursor is set (numbered item, reference to Heading Number (full context) after the word Exhibit, (iii) Formats the whole item into bold font and underlined, (iv) Adds a...
...For this project your main focus will be to develop to extract and import products WITH options IMPORTANT: We already have an Excel VBA Script to extract and import products without options. We are happy to share the VBA with the developer if they wish to work from this. Process Steps: 1) Download a report from BG website for example rankings report
Create a userform to automatically save down a template. Must create 2 lines from 1 entry. only difference is Col J one line must have receive or deliver short, second line receiver or deliver long. receiver or deliver is chosen by the option box. The highlighted cells are the entries that will be filled in. the rest is prefilled including the date which is whatever the current date of entry.
Develop a solution to extract current shipping status from [kirjaudu nähdäksesi URL:n] Solution must allow batch status checking of multiple tracking numbers eg 40 numbers from a specified list. Data must be populated back to same source or excel spreadsheet. Status from 17track should be assigned to a group for example "parcel picked up", "parcel arrived in destination...
Hi, I need an excel tool My project looks very simple for someone who know excell. I have many files of lists of clients extracted from 6-...from thoses 6-7 systems, and excell give the result when the ID refer to a client in the 6-7 Systems. So it will be especially Pivot Table, and Vlookup. ( The best would be a VBA) thanks you very much. regards,
I have software for producing cabinet doors designed in vba. I would like to have a 2d nesting program that I could integrate. You should enter materials and part to be nested. I would like to be able to save the nested sheets and export gcode for Cnc router
I would like someone to build me a macro in VBA that I can upload into Excel as default and use for formatting models. So when I open Excel each time, this macro will be running. The functions of this macro are purely for changing colours and formats so it should be very easy for someone who can pull together macros. I have attached a list of
creating an onlive webcam chat posibility to create private room live webcam with payment and free mode (possibility to be more persone who looks at the same camera) customer posibilite add webcam and creation room with webcam on live posibility add webcam phone and pc, and ip camera customer posibility add a video (homepage) plans payment and
I have created (2) MS Access databases that I want help with similar functions. Both databases I want to be able to have one command button that opens a file browser to locate the specific excel spreadsheet I want to import, have it add that spreadsheet to a temporary table so a query can be ran to remove new duplicates that may already be in the
I need VBA macro button to combine hundreds of workbooks contain several sheets into one sheet only. You can see the sample of raw workbooks (kd10s file) to extract into one sheet in tblairjoman.xls. You can download to see what kind of data that i need. If you can, please attach of the result your vba macro button that fits my demand then i'll
I looking for java /Spring boot /REST API/MongoDB/Swing /Andoid/AngularJS Developer to Build web and mobile Identity ID System use F...boot /REST API/MongoDB/Swing /Andoid/AngularJS Developer to Build web and mobile Identity ID System use FingerPrint Scanner(to capture FingerPrint template) and Webcam (to capture identity Photo).
...(loose language) with information on different fields. I need to break each message into 5 different fields of a row. The message can be in any order. You can use R or Python or VBA or excel. The script should identify the field in the sentence per the legend provided in the excel sheet and populate the rows. More information on message Fields and how to
...financial forecasting / budgeting / sensitivity analysis model. It will require some macro automation, easy data input, dashboard , styling etc. You must know Excel back to front, VBA and formulas such as Lookup, Index & Match etc Don't apply for this project if you only know bits of Excel and you think you can learn it as you go. I don't want your services
We have a need to automate data collection forms to eliminate the manual data manipulation, sorting, graphing, etc. The projects will vary in scope, function, and purpose.
I want to have a Macro for word which performs the following action: Example: This is the normal text. And here is the text with a Definition text. What the Macro should do: If I put the cursor somewhere within the word Definition, I want that a macro runs which (i) Selects (marks) the whole word Definition, (ii) Puts some quotes (" ") at the beginning and at the end of the word, ...