topics

Hello, If the VBA below cannot find anything for the particular pull I'd like it to Goto 1: and put a blank/1, can anyone help? Thanks. Public Sub Data_Pull_Products_and_Prices_2() Dim http As Object, html As New HTMLDocument, topics As Object, topics2 As Object, titleElem As Object, topic...

Hello, I am trying to pull data xml from the web into 2 columns, A and B. With the 2 topics below; topics and topics2, I need to try and pull it one - i.e. column A then B, rather than all of A's and then B. I cannot quite get the code to loop correctly below, any ideas? Thanks. Public Sub...

Hello following code works fine for 1 URL, I am trying to adapt so it runs for all the numerical pages it can find from the baseURL, so for instance the 1 up to the max until there is an error, is this possible? Thanks. baseUrl =...

Hello, Trying to pull all the names of the items and then the price on this page, https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1 e.g. Tesco British Salted Block Butter 250G £1.50 Tesco Gala Apple Minimum 5 Pack £1.60 But the code fails on this line...

The idea is to have a topic selection page where i can select yes or no and then based on my answers the next sheet will show all of the topics that i answers yes to. Images can be seen here: https://ibb.co/YfKK6pG AND https://ibb.co/1GpyjmJ Looking it this it maybe could be something where...

I have a work book with a tab labeled Training with about150 training topics. I then have a calendar with each month its own separate tab. What I would like to do is, put a pull down box of thetraining topics in each day of each month that requires training and then oncea training topic has been...

Hello all, Twice a year there is an exam with 10 questions. There are 21 potential question topics, and you don't know which topic will be used each for each question. I have a list of what each of the 21 topics have been used for the 10 questions over the past 10 years. Is it possible to use...

Hi, I'm working on a spreadsheet that we use to record Supervisor safety contacts (when Supervisors have a "safety moment" with an employee). The contacts fall into different categories/topics (ie: PPE, egonomics, etc.). Each department (packaging, production, etc.) has a different list of...

I have a formula that calculates how many topics deserve how many days that topic deserves in a 50 day training schedule. Trying to assign those topics to a 50 day training schedule automatically, based on how many days were assigned for those topics.

Hi All i have a basic table with months across the top and topics down the right side, each 1 of those topics scores a point each month. i'm after a formula that will return the last score for a topic in each row. Can someone please help me. Regards

Hi all, I have a problem and do not know how to solve. I have the following sample worksheet: <table width="192" border="0" cellpadding="0" cellspacing="0"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt...