Hi There, I need a VBA written that will build a relationship table based on string searches. The search will have names in the format Smith J, if it matches with Smith JR i will need the relationship made and a flag highlighted. There will be wildcards used within the lookup. Each tab can have 1 or 1000+ names to search. There is a main
...built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs. Scope of Work: We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following: 1. Browse for the CSV or workbook to transform 2. Run the Script 3. Save the transformed file into the
...items. For example, Item 1 – Item 2 Vendor 1 – Vendor 1 Vendor 1- Vendor 2 Vendor 1-Vendor 3 … ** Important notes -> The number of vendors varies. Let's say I want to paste my table starting from A5. But the number of vendors changes. You should take the last raw. But it should not be that straightforward. There are some considerations below;
Hi, I need an Excel VBA guru to take the following columns as inputs and conduct web data scraping. Inputs in Excel: - Company Name - Location (e.g. NSW) VBA Process & Outputs in Excel: Google Search: 1. Google Search the Company Name 2. Extract information from First Search result (Header, URL, Description) 3. Copy Each into a separate
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format
I am looking for a outlook addon developer who can develop a add-on that works with our Appointment booking solution that is similar to qless.com. User should be able to book an appointment via outlook and see the booking in their calendar. Same thing if appointment is made via our webapp, user should see in their calendar
We need a native mobile app for a bodybuilding website, this app should show the muscles of the body and a video for each exercise. with some description. Admin panel is a must.
Refer to attached zip file. The [url removed, login to view] file links to 2 Excel files, 1 Access file and 1 SQL Server database. The SQL database can be restored from the [url removed, login to view] file, then linked using ODBC, DSN name = 'Calendar' The [url removed, login to view] file has a local table (called 'Connection') which can be used to determine the paths of t...
...designed for my business - Touchpoint Body Balance. The work I do is an energy modality called Jin Shin Jyutsu. JSJ is similar to acupuncture, but without the use of needles; instead fingers are used to activate points on the body. This work helps with physical pain as well as mental/emotional pain, it balances body, mind and spirit. I do not like the
I need someone to export contacts out of Outlook online into a spreadsheet. You will need to login Add specific email accounts as a contact Then export these contacts into a .csv Full instructions will be provided Approx 400 emails to export
...8. MVC and WEB API 9. responsive web applications 10. SSRS 11. MySql 12. business analysis 13. Silverlight 14. mobile applications 15. Magento 16. MSACCESS / VBA 17. visual studio team services Being available every day between Monday to Friday and the first 5 skills are critical to have, the remaining are a plus. Most of the
...link in the list to open a webpage 2. Click on a button on this webpage to reveal a phone number 3. Copy and paste the phone number into a given form and save it You will need to repeat this for each URL in the list. Other copy paste jobs within spreadsheets and other platforms will also be needed occasionally. Use of a VPN is strongly recommended
I have developed more than 200 automations, using different platforms supported by VBA, Automation such as Excel to Excel, Excel to Access, Excel to Powerpoint, Web clawring, Excel to Mainframe. Key projects I have developed are enumerated below: 1. Quality Report for Finance, where data is taken from 5 different files, into a single consolidated