site

Hello everyone, I am trying to download a bunch of tables from a site (allowed by the site administrator). I can use the site's filters/search tools and get all my data by year on a web page. However I need 20 or so years worth of data, so I have to click on each year one by one to access the...

just a little help needed. 3 tables on one worksheet that change depending on what is selected from drop downs. is it possible to look up the values from the first table (sales for advisers at a selected site) and then highlight certain fields in the other two tables? so id like it to look at...

I currently have 3 different tables on one sheet. a table that lists the standings of sale execs at a certain site. another that has the standings of all the sites a final one that has the standings of all sale execs as the all sale exec table is bigger than the rest i have an auto filter code...

Having a lot of issues trying to resolve this problem. so i currently have 3 league tables. each league table is then automatically changed depending on the options selected from some drop downs. shows the sales of staff at a particular site. You have an option of new sales, used sales and...

I am trying to do something that should be simple, by my brain is having a dumb block. I have a table of sites showing their ranking for various performance measures. I just want to create a list showing which is their best and worst measures, but I'm getting confused where they may be the same...

hi folks, Struggling with this one and not sure there's actually a solution, but i'd love to be proven wrong (gauntlet, thrown.) I am compiling a Worksheet KPI that reports back a ranked list of performances, based on that areas stock holdings. Each of our stock holding areas hold a different...

hello everyone, I am new to vb.net... I need help in a macro, I have a site , after logging to site I want to move to subsite in it.. I tried with providing direct subsite url but after entering credentials, page gets refereshes and takes to home page only.. pls help

The company i support has standardized IP schemes, IE the server for each site always ends in the same octet, workstation 1 for each site ends in the same and so on, what id would like to create is a sheet where a user can put in the ip for the server and it figures all the other IPS out, so say...

I have looked through other answers but it appears that my problems are addressed only partially, as the issues are across multiple issues. BACKGROUND Every month, a workbook is opened with links to external data and reports are run for each site. The file updates as each site is accessed from...

Hello! I’m working on reporting to show the overall impact an agent has on our site. Our site KPI goal is 90%; Agent 1 has 20 surveys averaging 80% Agent 2 has 100 surveys at 80%. Both are obviously not meeting but Agent 2 has a bigger “drag” to our site. Can someone help me with the formula...

Hi everyone, Is there a way to rearrange the columns based on values in the cell and not based on the headers? for example the first rearrange would be Username, Hint, Password, Site, the second rearrange would be Password, Username, Site, Hint. If i'm not being clear enough, please let me...

So, received a bunch of help in my other thread on how to set up some formulas to only look and count certain values that we use for tracking maintenance performed at our Job Sites. The only issues i have left is when tracking 200 and 2000. So, i have the one formula that successfully sees...

I have a VLOOKUP formula where if the result is "#N/A" or "0" I want the cell to return the text "not provided". I'm sure a nested formula would work, but I can't figure it out. Here's my formula at present: =IF(ISNA(VLOOKUP([Tracker Site ID],Table17,5,0)),"not provided",VLOOKUP([Tracker Site...

Hello, I want to get the table containing currency rates from the following web site: www.cbar.az/currency/rates Though Power Query does not return a table, but HTML parts. Is there a way to get the table from the mentioned web site? Best, AH

Hi, From the link to my test spreadsheet, I have 3 tabs, Site 1 and site 2 and site 3 What I am after is that the data of the 3 tabs populate the Main Page tab automatically as I enter data...

I have done many google searches for trying to change macro web site scraping code from using Internet Explorer as the default web browser to an alternative web browser for scraping data. Unfortunately, all I have found is changing the web browser for hyperlinks in an excel cell. Is there a way...

So i have a formula for counting even that have occurred at certain sites. Like different job sites doing different events and a simple one that basically says Job site 1 did this Job site 2 did that we delete everything older then 2 months as the year progresses, just to keep file sizes...

I use a web site to monitor when my son gets dispatched on a fire call https://www.toronto.ca/community-people/public-safety-alerts/alerts-notifications/toronto-fire-active-incidents/ I have a macro that works fine on my Windows 8 computer but not on Windows 10 and no one in the world seems to...

Hi all Master, I'm really confused to grab TEXT from words, i already trying used many formula but still <tbody> No. EXAMPLE OF DATA 1 <tbody> XXXXXXX XXXXXXX: 111111_CCCCCCC {SITE NO_111111_BLUE CAR DAYS, SITE NO_111111_RED HOT MOON, SITE NO_111111_THUNDER STORM, SITE NO_111111_GUN...

Is there a way I can paste a table into here to show an example of what I want to do? I know I can make a table using the tools here but that involves a lot of manual typing. Alternatively I can show an image, but it seems like we can't paste one or upload it, only link through an external...