...an excel spreadsheet filled with inventory data that contains 4 buttons, which, when pressed, allow 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
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 [登录来查看链接] 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
This is long term project for over 3 months to upgrade existing VSTO and VBA add-ins to the latest version of the Microsoft Office add-ins platform. The ideal candidate is experienced with: Typescript, HTML, CSS, Oauth and integration with RESTful web services, and preferably has hands-on experience developing add-ins for Microsoft Office 365. Please
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
...this website: [登录来查看链接] 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
Auto Schedule Excel Workbook with Macros to run in Windows I am currently opening an excel 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
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
Hello, I 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
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...
...options. 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
...[登录来查看链接] 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 country" etc example tracking numbers: LF484662815CN
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
...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 database. It would remove these duplicates based on several criteria. So I would need someone to write the VBA for that command button
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 need an Excel expert to help build a complex 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
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, ...
I have 2 spreadsheets...source & destination. I need to AUTOMATICALLY copy from source to destination file, then to DELETE various rows, lock sheets, copy sheets and hide sheets, as all part of the VBA process. Currently I have somebody from Australia completing this work who is VERY good. Unfortunately, he is on a months' holiday, and I could dowith
...Scope: We are looking to get two Excel Marco created where we can clean up and deduplicate a data list and then export them into a tab-delimited files, the second macro will be simply cleaning and merging worksheets together. First Macro First Function: Ref: Emails to [登录来查看链接] We need to take an Excel CSV File and strip out the email addresses
Build a web page to substitute a Excel spreadsheet with following functionalities: 1-Load .wmf file into the screen (product schema) with dynamic text floating on the image. This image may be printable with the text without distortion. 2-Database access (search and save). One table, 40 fields. The fields can be filled in the webpage.
Hello everyone. I need help with a macro button which will copy the data from row above it. Secondly that macro should be working both on windows and mac. Also need a drop down and a dependent drop down created. So it's like 1 hr work for a macro expert. Get in touch. Thank you.
...are fully aware of the requirementss. After you have seen the demo, you can update your bid and advise the time you will need to finish the task. For a solid prgrammer with VBA and SQL knowledge, it shouldn't take more than three hours to get it done. In your response, please tell me the name of current prime minister of australia. this is so i can
...installed Office 2016 on my lap and excel will not open any 97-2003 worksheet. I've played in the trust center settings - file block settings and protected view but nothing is working. Funny because I have the same settings my both my PC and we don't have any problem. The only the to have excel show the content in a 97-2003 worksheet is to open a ...