rest

Hi, I am using VBA-Web to pull in some data in a json format via REST. Which works fine using Public Sub PullStaff()Dim Client As New WebClient Dim Request As New WebRequest Dim RequestResponse As WebResponse WebHelpers.EnableLogging = True Client.BaseUrl =...

Hello, I need to do a macro when I type the site in a cell it extract a table from that site to the rest of the row and I need to do it repeatedly to the rest of the rows till now I can only do it to one row only and it is msgbox This is the code I used If Target.Row = Range("cellone").Row...

Enter a formula in cell J4 using the IF function to it whether or not the item Beaded Earrings should go on sale. It will go on sale if its current sales rank (in cell G4) is 8th or lower. (Hint: If the cell value is greater than or equal to 8, it will go on sale.) So far I have =IF(G4>="8"...

I have kept a personal exercise log for many years and I am trying to keep myself motivated (extract below). Column A12 contains consecutive dates exercised from 01.01.1999, and a row is added to this for every new day. Column B12 contains exercise activity. Mon, 8 Oct 2018 OTHER Tue, 9 Oct...

when sorting a table e.g. A-Z or Z-A, the first cell does not change like the rest. Why is this?

Hi all I want to use a select case instruction to change the colour of a series of active x texboxes based on their values, I've got that working for a fixed reference e.g. Textbox1 but I want to be able to cycle through the rest of the textboxes on the active worksheet. I've tried...

Just a quick qyestion which I'm sure there is a easy answer to but I don't have anyway. I want to conditionally format a number in a row of numbers (See Example) that is at least Double Lower or more than the rest of the numbers. So in my example the number 1340 would be highlighted in...

Hi guys, I am using Excel 2013. If I have inserted a photo into excel, is there any way of editing the photo so that just one colour stands out, and the rest is in black and white? Apologies if this is in the wrong place, but it is an excel question!

I have a problem here with an excel function. This wouldn't be a problemif could use scripts but unfortunately, there's another piece of softwarethat needs to read the data, this software cannot read scripts. I musttherefore, only use functions. I have this list of data %MW101.0 %MW101.1...

Good day, Is there a formula that can extract only the numbers form text. The below data is an example of what I get. I would like to just extract only the numbers, really what I only need is the Lat & long numbers. But I could always just filter out the rest of the numbers that are not needed...

This one is a hard one to articulate so I'll do my best. Also, please tell me if this is easier in Access. I have a set of transactional data that has card number and merchant. I want to only display merchants (ideally in a pivot table) that all of those card numbers have been to and exclude...

I have an excel file in which there are 12 sheets. Each sheet contains the calendar for a particular month. There are 35 cells in the block (5 Rows/weeks X 7 Columns/days) with name of the day on header row. Now I have to manually enter the first dates of each month with corresponding day & then...

Hi all, I would like to create a Drop Down List in cell “A1”, so that to choose any month and then to appear the data in the current Spreadsheet. Note that the months are belong to another file, named Cash Sales Table. In sch. 1. are the original data and in sch. 2. Is the expected result...

So have a unique situation. I had to rebuild my entire spread sheet and make it a table. This was because I had to have the auto fill formula feature. After using this new method I've had 0 issues. Now I've ran into a situation that only happens a few times a year, but it can be an...

Hi I have a worksheet which has formulae which reference multiple other worksheets, e.g. <colgroup><col><col><col></colgroup><tbody> A B 1 Sheet 1'!W367+'Sheet 2'!W367+'Sheet 3'!W367 Sheet 1'!Z367+'Sheet 2'!Z367+'Sheet 3'!Z367 2 Sheet 1'!W370+'Sheet 2'!W370+'Sheet 3'!W370 Sheet...

Hey, I have a problem if I want to print something in a Worksheet. The sheet has different sections which you use a macro to hide the other columns. If I click on the second section and want to print it only shows me the header which its freezed but the the rest shows blank. Can somebody help...

<tbody> "OSV TO BULK ANODIZE RED" </tbody><colgroup><col></colgroup> What fx can I use to get rid of the "OSV TO " and only show the rest.

Hi all, I'm currently trying to make a macro which autofills a Vlookup from another workbook. I managed to get most of the macro working, except that it would't autofill to the rest of the empty spaces in row BA no matter what I tried. It was to only be the empty cells under the filters setup...

How do you make a box or column wider for a certain area while leaving the rest of the column below unchanged? Thank you in advance.

Hi, Please can someone help me? I would like code that once 1 cell has been entered in a range, the rest of the range enters a "C". So basically my range is D5:D15 If the operator enters a "N" then nothing happens. If the operator enters a "Y" then the rest of the cells in the range auto...