e.g

I have a list of URLs on sheet2 "Url List" when my code runs it works it way through these URLs and the extracted date is placed in sheet1. Is there a way of skipping Urls with captcha? e.g. it times out and moves to next url if no data is extracted with X amount of secconds If this is...

Hello Every One, I am looking forward for a solution of below cited problem.... 1) I want to have total of four random values between 2.5 and 7. 2) System must pick random values by its own and values must be in between 0 and 5. 3) Total must be in multiple of 0.5 e.g 2.5, 3, 4.5, 6.5, 7...

Hello All, Can someone please help me on a sheet that i am working on for a headcount, i have several arguments like Present, Local Leave, not reachable etc and i am using if function e.g: "=IF(C2="On Way xxxxx",1,"") and "=IF(C2="On Site XXXX",1,"") whereas "XXXX" is a different place and same...

Hi, I'm trying to create a dropdown that show a text value e.g. High but has a value associated to it so I can calculate it. https://we.tl/t-GCnCPTCPcA Thanks Matt

Can someone please help me? I have a Query Table of climate data from 1/1/1900 to today which I update regularly. I wish to calulate the mean High for each of the days (e.g., month 2 day 19) and compare it to the High for each date (e.g. all of the Feb 19s), subsequently indicating whether it...

Hi I have spreadsheet & I am hoping to have a block of cells (e.g., A1:D10) locked upon changing a cell (e.g., F15 having an entry of "Yes"). I.e., any other value such as "No" will not lock cells A1:D10. Additionally, anyway to embed the code without having to run the macro each time opening...

Dear Expert, i am looking for VBA code which search value from all sheet from particular column and paste all data in last sheet. e.g. i have one file which have 5 sheets and name of the sheets as below 1) Search 2) Bank1 3) Bank2 4) Bank3 5) Bank4 in search sheet, B3 cell contain search value...

Please tell me how to combine these into a single VBA. Each one runs alone but I cannot figure out how to combine. Thanks. (The first one allows entry of date without use of / key and the second allows entry of time without : Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim...

Hi There, I'm hoping someone may be able to assist. I'm setting up a budgeting spreadsheet and want to align each tab with our pay cycle, each fortnight. I would like each tab to be date named e.g. 02.01.2018, 16.02.2018 etc. Is there a way I can automate this instead of updating 26 tabs...

I am using the & function in a cell to present a value from three different cells. Here is my code: ='AMC Calculator'!E8&'AMC Calculator'K8&'AMC Calculator'!O8 The code works well as it properly shows values from each cell (e.g., '0 5 0'). However, I will only ever need one value from the...

Hi, I’m hoping someone can help me, I have looked online but to no avail. I understand there is a quick way to populate an array in VBA, with values taken from a worksheet e.g. 2DArray= worksheets(“Sheet1”).range(“A1:A4”).value The above populates a 1(column) x 4(elements) array (named...

Hi Is it possible to have a callback for the ribbon when a key is pressed, rather than when they press 'tab' or 'enter' - for a dynamic search? Also, is it possible within VBA to set focus on a Ribbon Control? E.g. after the macro has executed, to go back to the text box in the ribbon? Thanks...

I have come across this....I know the most "normal" way to use ROW function is to give it a cell ref, e.g. A10, B3. But when I put an number array as an argument into the ROW function, e.g. row(4, 5), it will return {4,5}...I guess it interprets the argument as row 4 and row 5, so it spits out...

Hello, I have a macro (below) that works as it should. However, if I put the time in (using a colon), so 12:00 instead of 1200, it gives me a different time (0:00). Any ideas? I need it to work both sides. Public Function MilitaryToTime(T1 As Integer)' ' Input T1: 24-hour time as integer,e.g...

Hello, I have the below code to toggle my grouped columns in excel to expand and contract (the code doesn't remove the grouping), how do I amend this code so that this only applies to specific columns e.g. A:E and leaves all my other grouped columns Thanks Public Function...

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 73.6px;"><col style="width: 73.6px;"><col style="width: 73.6px;"><col style="width: 73.6px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width...

Hi i would like to change the format of month to date in col. "C" so to convert it, e.g. 10/2018 to 31/10/2018 using VBA. Thank u all in advance

Have 10 command buttons and a text box. When I enter a value in textbox1 i want to show that number of command buttons E.g if I enter 0, no command buttons will appear, if I enter 4, command buttons 1,2 ,3 and 4 will be visible and the others won't be. Thanks

Hello Excel Experts. I am facing some challenges in sorting an excel document, where there are occupancy percentage values by date (e.g. from Jan 1, 2018 to Yesterday) on one sheet and other sheet just have date ranges for a person's visit at our facility e.g. Mr. X visited from Sep. 23 to...

Hi there, I am wondering what the easiest way I can band values which are the closest to the actual values. Take the below example: Here are my bands: <colgroup><col><col></colgroup><tbody> Chargeband Exc VAT (pence per min) 1 4.5 2 4.5 3 4.5 4 13.5 5 13.5 6 13.5 7 13.5 8 36...