The site is:
https://pubchem.ncbi.nlm.nih.g...and extract the data in the attached format.
Note that the download tab contains a list of files that need to be downloaded for each chemical. Out of this only the patents file needs to be downloaded for each compound.
Please bid only after you have gone through the attachment. I need the code by 6PM IST

I need to loop through each row and for any cells that meet the "if" condition, then the cell value 6 columns to the left is displayed....to the left is displayed. I already have the entire code written that can email me the cell values, just needs small modification. Should only take 5 minutes for experienced VBA programmer. Need this done in 1 hour.

i want to add some logging to powerpoint which logs the slides presented in a powerpoint show adding information to a log for a later review of the contents displayed.
Especially should the logging respect the navigation with sections.
--
Initially i want to start with a discussion of the ideas and then code samples as needed.
--
i expect in the end a simple working code sample i can build on...

We are searching for a experienced developer who has knowledge in both MS Access VBA and one other language such as Python/Rails/PHP. The goal of this process is to achieve the same functionality as before.
Please don´t write a long list of accomplishments in your application but rather give me a short explanation how you would handle that problemset

The site is:
https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top
Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format.
Note that the download tab contains a list of files that need to be downloaded for each chemical
Please bid only after you have gone through the attachment

...workaround so please read carefully...I am budgeting for one day's worth of effort. We will need screenshare. I will need for you to give me the VBA script based upon the review of the website. I will enter into excel and get the [login to view URL] I'm on VPN this is the only way. I have to accomplish as if I was running my own scipt. Because this is a VPN, I do

I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system.
Issues to be resolved:
1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable)
2) avoid memory leaks
3) ensure that data imported from source CSV's is fully loaded before

I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.

Hi,
I would like to sort some files according to age, size, length and weight, etc.
The drop down functions should indicated ranges which i will provide. Also after completion, i should know how to add and delete those ranges.
It should be a fairly simple project.

...the statistics as a CSV file from the system. This includes the following files:
- Current stock (CSV)
-Sales of the last 14 days (CSV)
-Article Database (EXCEL)
The first two CSV files I read about the query function in Excel. I then made a little "program", if you want to call it that, tinkered. I also worked a bit with VBA. However, the tool is very

I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.

...
- We want the project owners to input their update into SharePoint and pull that into this workbook, mapping to the data elements in the dashboard
- We want to leverage a VBA button to produce a PowerPoint slide of the dashboard to automate our deck production.
We hope you will accept our offer and look forward to hearing from you soon. Please let

Non-profit business needs spreadsheet to track weekly contributions that will link to Annual total page for each parishioner. Also, spreadsheet needs Master worksheet that allows the addition of names that will automatically update each subsequent worksheets.

I want a vba code which can be installed in users pc. Which will expire after 1 year and on the expiry they should need to ask me for the licence key again. The programme should not work in another pc.

Write a VBA/Macro
Using Excel for analysis a huge number of property information, including all particular, Historical and Current rental status, Rate of Return, Historical and Current Market Value, Profits or Loss and Banking Facilities Information for each of the property....
Steps
1. Design "Master Data Sheets" to contains all information
2. Design

...have 2 excel sheets, which are a copy of each other. One is saved on my local drive (My Laptop), and the other is saved on my google drive. In the sheet saved on the google drive, a colleague can go ahead and change values in certain cells. Currently I have to download the sheet from google drive, look at the changed values and then update my excel sheet

Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #).
I need a blank spreadsheet where the user can input the following:
Input: Base #, Sensor # (or all sensors connected to that base), Date (single date).
The spreadsheet would generat...

I need for multiple VBA modules to be converted to C# and compiled into two standalone addins.
Part of this will require for the user to be able to perform CRUD operations to SharePoint online lists, which will require for the users login credentials to be passed automatically when necessary.

Dear all,
I need a vba run excelfile manager to be drafted with following functionality:
1/ list file names from the selected folder + subfolders
2/ list location of the file
3/ hyperlink to the file
4/ once list is generated, ability to change file names in the list that would automatically change names in selected folder and subfolders. So basi...

I need to manipulate a data file I will receive each month (similar to attached). The data file includes a list of managers (Column B-D) and all of his direct reports (Columns H-AB). I want the file to create a table from the original showing a summary table detailing each managers direct reports on a seperate row (see summary sheet for example).

Trying to run multiple reports off of a button push that filters data by date and then copies the data depending on criteria.
So attached is "Book 1". It has 3 Sheets. A "Tasked" sheet that shows what work orders have been given to employees, a "Total Tickets" sheet that shows all work orders that have been received, and a "MACRO" page with date ranges for...

We have an Excelfile with macros (XLSM). Download resource manager for excel from [login to view URL]
Problem happens across multiple versions of Excel and OS.
When downloaded from our website, or emailed, and the user tries to open the xlsm file, the first prompt is for:
ENABLE EDITING
After you click this, to enable

...Amazon orders XML from Amazon MWS. Module needs to get all orders from last 30 days and parse xml, append data to a table but only if not already there. (new only based on AmazonOrderID). Important: Your module needs to create the Signature MWS requires for each unique request. Module also needs to have function to get one order xml info but AmazonOrderID

Need to dynamically filter from drop down list in excel table. Need vba code w/ description/notes of code so new users can understand. Looking to dynamically filter the table ("Table") in file (also outlined by black bold line) based off the drop down menu highlighted at top of file.
Bonus would be to add signature blocks and note page on how to send

I'm in need of assistance with a sales tool my company has created for our clients. It's an Excel spreadsheet our clients use to track their sales process. I'm having a hard with with programming the spreadsheet to automatically populate the summary charts on the first tab and some conditional formatting issues. Looking for help on a few spreadsheets

From an existing Excel sheet read the path of a locally stored file from a cell. Copy the Thumbnail from that locally​ store location and append to a new cell. Then in a new cell create a link to the file that opens it when clicked on.

I need someone to write a routine to create a report based on defined rules using multiple excel files that will be received by e-mail.
Report should be displayed as on the REPORT tab of attached file.
This is made up of adding data from pivot tables from multiple data sources.
All data to be received from 4 original files that will be received by e-mail