element

  1. T

    For Each Loop

    Following from this thread: https://www.mrexcel.com/forum/excel-questions/1114405-collections.html I was told this piece of information: Syntax ... For Each element In group ... element ... For collections, element can only be a Variant variable, a generic object variable, or any...
  2. B

    Appending a Value to Each Element of a Range Array

    I have a workbook with 2 sheets: Sheet1 and Sheet2. In Column A of Sheet1 I have a short uninterrupted list of product IDs: <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in...
  3. S

    Copy status value from web page

    Hello Everyone, I am not expert in VBA. Requesting your support to complete my macro. In the webpage I want to copy the status "Awaiting Business Review" in my excel sheet. Below is my HTML Code.. I cannot disclose the website address. Apologize for that. <div title="" class=""...
  4. W

    What does this mean?

    HI, I've been using this formula for some time and I can just about fudge the way it works. =SUMPRODUCT(SUMIF(INDIRECT("'"&Courses&"'!b:b"),$B4,INDIRECT("'"&Courses&"'!"&SUBSTITUTE(SUBSTITUTE(REPT(ADDRESS(1,COLUMNS($A:G),4),2),1,":",1),1,"")))) I understand its looking at the named range...
  5. D

    How to skip rows

    Hi Guys!! I'm using the Hyperlink function for a database with different sheets. On my main sheet I have the label of each element, and on my second sheet I have each element with an individual table with some data. The issue is that I need to link the label on the first sheet with the table...
  6. M

    Placing an Autofiltered range inside an array works only once

    I'm currently having a problem where an auto-filtered range is only placed inside an array on the first loop but subsequent attempts to do the same despite the range filtering correctly don't work. Set OpenWBS = Workbooks(Workbooks.Count).Worksheets(1).UsedRange...
  7. H

    Web-Scraping Selecting Dropdownlist in website

    After button element "ContentPlaceHolder2_btnSearch" is click, element "cbSite_I" returns to blank. I want element "cbSite_I" to have value "Cát Lái" after element "ContentPlaceHolder2_btnSearch" is click. Pls kindly help me accordingly. Thanks. Visible Text on websit : Button : "Search"...
  8. R

    Access with formulas and fetch values

    <tbody> BIN ELEMENT# TTL LV2 LV3 LV4 1234 12 200 150 50 0 1234 13 150 130 10 10 1234 15 350 350 1234 18 10 10 1234 201 255 255 1234 340 30 25 5 1 </tbody> Secondarytable ^ main tbl ex. below <tbody> BIN ELEMENT X...
  9. J

    Data quantity calculations & summary across multiple tabs

    I have a workbook for budgeting construction projects. Each element of a project gets its own tab (for example, walls, roof, floor, etc.). Within each of those tabs the user chooses a category of material from a drop down menu, then the actual material from a second drop down menu. Those drop...
  10. B

    Selecting info based on a previous column

    I have a list of data made up of four columns, Element, Feature, Attribute, Life Expectancy, an example would be fire access & security systems(Element)>cctv system(Feature)>recorded(Attribute)>25(Life Expectancy). Each one of the columns is related to the previous one, so if I was to select...
  11. Sharid

    Email Extracting

    My code extracts emails from a website, this bit is fine It can also extract URLs from a site, the PROBLEM is that it extracts all LINKS and not just the domain name Also I can only extract one or the other, either emails on their own or Links, when what I want is for it to be something like...
  12. R

    Need one more element to this formula

    How do I modify this: =IFERROR(VLOOKUP($A8,'D:\Corporate\Analytics\2019Analytics\Final2019\[NewsLettersJan2019.xlsx]Stations'!$A$3:$FC$156,64,FALSE),"") so the result is multiplied by J6 thank you in advance
  13. J

    Userform with input numerical number with listbox

    Hi, I found this code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = False On Error GoTo exitHandler If Target.Column = 10 Then gCountryListArr = Sheets("RESOURCES").Range("Table2[COD]").Value gCellCurrVal = Target.Value...
  14. P

    Multiple Arrays and Loops

    I am comparing 2 arrays, and based off the comparison, placing values from an array into a range using the active cell. I am not receiving errors, but two things are happening. 1. Excel (not my machine) locks up when I run the code - How can I improve my code so this does not happen 2. I...
  15. G

    Drop down list returning another list element

    Hi guys, I deal with a lot of weird identifiers that I can never remember and I was wondering if it would be possible to create a dropdown list that returns an element from an adjacent list. So if you refer to the list below as an example, let's say my drop-down list would be counterparty...
  16. B

    Trying to use 2 VLookup formulas but need a "Then".....

    =IFerror(VLOOKUP(E3,_20181219_milly_final_2!$B$2:$H$175466,7,0),iferror(VLOOKUP(J3,_20181219_milly_final_2!$G$2:$H$175466,2,0))) Here is a formula that is not working --- I have 2 tabs and each tab contains account # and element #. I am trying to match acct # from tab 1 to acct #on tab 2 and...
  17. E

    Extract text between specific characters in a alphanumeric string

    Hello group, I am looking to extract text data that is between specific underscores. Example: ONE_TWO_THREE_FOUR_5_6_SEVEN_EIGHT_9_TEN_11 I need to extract element SEVEN. How can I specify to read between specific underscores? Thank you!
  18. E

    Html table scrape with vba

    Hi, I am new in data scrape via VBA. I want to get my order history over amazon. I can get all the info from html table with the code below. However, this code gives td elements in a single and it is hard to parse it again. I attached the html code of web page and highlight the info I want...
  19. R

    Is it possible to store more than one number in a cell (i.e. an array in a cell), and how can the nth element be referenced in formulas?

    Hello, I'm wondering if it is possible to store more than one number in an array. I'm hoping I can reduce the size of my large score sheets by storing the scores of each student in one cell where for example the first element would be math score, the second physics score, the third chemistry...
  20. E

    Returning values from multiple headers

    Hi all, Looking to return values from multiple headers in an excel sheet. I have the following table for illustration: Ideally in 'column 8' i would like to pull the value from the merged header. The problem is there are multiple merged headers running through the sheet. For illustrative...

Some videos you may like

This Week's Hot Topics

Top