microsoft excel 365

Hi again, I have more troubles with loops. One of these days they will come easier! Each record has a group of tables. I grab these tables (of varied lengths) and put them in Columns A-F (not shown to keep post shorter), this works great. Each record has more tables after clicking a button...

Hi! I am attempting to copy some tables from a website. The site is secure so I can't share. I got the table part fine. My problem is there can be 1 or a variable number of tables and to get to them one must click it's corresponding "Show History" . We could have one Button or ten, who knows...

Dear All, I am trying to do do a lookup based on two criteria, if the criteria matches, then it should not give all the results but the result I want. I tried various formulas on internet on Xlookup but not working and then I came across Filter function which is close to what I want but still...

I am in need of an Excel formula that looks to see if cells in column A match. If they do, then provide the sum of all of the cells that match in that group in the first cell of that group in the appropriate column (GA = column "G", "FL" = column "I"). You can see the totals in columns G and I...

Team, I am new to excel VBA coding, Could you please help me in this. My requirement is, In sheet1, I have a multiple check-box, with values IBM, HPM,UNY,ASM, When I tick check-box IBM, the columns with names HPM,UNY,ASM in Sheet2 has to be hidden and only IBM Column has to be visible...

I have following data for Latitude and Longitude with its coordinates and want to transform the value (LT and LG) as per below. for example S.no >383> 19.159314 to 21 : 8 : N and 77.313188 to 75 : 16 : E rather than a long coordinate numbers. These numbers are extracted from...

Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...

Hello I hope someone can help as I have been trying to figure this out for the last few days and getting nowhere. I have a complaints database that I have put together where the user fills in the userform with the details of the complaint and it gets put into the correct tab in the workbook...

Kind regards I am carrying out a linear regression process, for which I have resorted to the use of a userform, where in each of the four textboxes I have to enter the input data corresponding to four functions fi(x) To check if the input functions are valid and do not present some kind of...

Hi, I am working on a userform that calculates the distance between two cities (measured along a straight line) expressed in miles and kilometres. To make this possible, four ComboBoxes have been entered into the form, two of them record the State, while the remaining two contain the city...