retrieve

Dear experts When the "https://yenibeygir.com/at/15673/budakhan" web page opens, I want to retrieve the data from the page "Galopları" instead of the default data. Can you help me?

Hi all, been trying to use a macro I've seen here to help me retrieve a range of values of all workbooks in the folder. However, I have 2 problems: 1. It only retrieves one cell and not a range of cells in multiple rows and columns. 2. It seems to hangup when the cell is located in a hidden...

Having used this forum many times over the years for tips I find myself posting for the first time with a query, so here goes I am using data connection to retrieve data from dozens of workbooks, each workbook has 17 worksheets, Apr through Dec, total of Q1, Q2, Q3, Q4 and Grand Total To...

I have a spreadsheet which is created using VBA and I want to retrieve the column of the last non zero value on row 1 (range(K1:T1)). This is so I can use the column later in the code. I am using Excel 2016. Any help would be appreciated.

Hi! I have a large (6000+ rows) spreadsheet which is a mess. Its just copy/paste of dozens of different spreadsheets, containing customer information from several different stores. Goal My objective is to retrieve all the customer emails from the spreadsheet so we can import it to our...

Hi All, Is this even possible? I think it is, I really hope it is. I need to retrieve the highlighted amounts based off of a match. I have tried various index match formulas to no avail. My match will be the 4 digit id's in Col A. So if you look at B23, in C23 I want to retrieve G10's data...

I am using the refedit control on my userform. Is there a way to extract the first range from my selection so I can offset it to retrieve other data from that row as well from "Sheet1" within workbook named "SDPF". Example: With the refedit, I am selecting the range(H1044:H1061). However, to...

Hello Everyone, I wish to use VBA to retrieve the folder (or path) in which a workbook is located. For example if the workbook is called "MyWorkbook.xlsx" and is located in "C:\ExcelWorkbooks\" (which means the path to the workbook is "C:\ExcelWorkbooks\MyWorkbook.xlsx"), I want the code to...

Hi, I have a range of cells (let's say cells D2:H2) that can either be formula-driven or user-inputs. In cells D1:H1 there are drop downs that determine the type of formula that should be used if a formula is chosen over user inputs. I can't simply use an IF formula in D2:H2 because a user...

Guys, for fun, I'm trying to learn something new. I was wondering if it would be possible to have a report like the one on the picture. In columns, you would have the vendor's name and in rows, the KPI associated. The information would be pulled from the sheets which would have the vendor's...

Hi! I retrieve picture, using Index & Match functions. I have picture data in one sheet & contact data in another sheet. If we retrieve the picture in one row it may possible. But I want picture so many rows. It may be want so many named range. Is there any other way to do solve this problem?

Hi, I am trying to retrieve within a cell any 5 charactered words, numbers or alphanumeric. Example: 1eaSsg dgsgeee 1233 122 VXC2H i want to retrieve VXC2H. Again, it can be letters, numbers or combination of both. I just need to extract the 5 character text within a cell.

Hello, I'm wondering if there is a way for excel to run a simulation to retrieve a value of a specific cell for each day of the year. Example: I have a drop down list that contains every day of the year. When I change the date, some cells are populated with values from a table of data using...

Hi, I have 36 columns of data split in 3 clusters of 12. Cluster 1 - Sessions 1 to 12 for attended sessions Cluster 2 - Sessions 1 to 12 for cancelled sessions Cluster 3 - Sessions 1 to 12 for no show sessions For each row there will be a max of 12 values across those 32 columns. I want to...

Hi, There are formulas already to extract unique items from a range but all of them are based/depends on comparing the list column reference by COUNTIF. Is there anyway to retrieve a unique array alone, for example may work in TEXTJOIN function? E.g. TEXTJOIN(", ",0,UNIQUEFUNCTION) Thanks a...

My worksheet is as follows: Key Metric1 Metric2 1 a aa I am trying to retrieve a value using the dictionary's key: Dim dic As Scripting.Dictionary Set dic = New Scripting.Dictionary dic.Add Cells(2, 1), Cells(2, 2) Debug.Print dic.Item(1) but it does...

Hello Everyone, I am hoping to talk this idea through and hopefully get a working vba code to accomplish this or see if I can get some maybe better ideas? I have a template I created for work that has a series of checkboxes, text boxes and cells for data entry for each file I...

Good Morning, I've run into a strange scenario that demands a formula that can count an Employee ID under two different conditions, and THEN retrieve the name of the top 5 employees. The table or example that I will be using is shortened because the one I'm working with is too large. It's...

Hello, I'm creating a front end navigation sheet to point to other sheets within the workbook. I want to retrieve the sheet tab color then fill a cell to match that color. Thank you Shannon

Hi all, I have a drop down list of my employees in A1. I would like to use B1 as a "Comments Box". In C1 I would like to read the comments that I wrote for each employee. Therefore I need a VBA code that stores whatever I type in B1 so that I can retrieve it in C1 when I choose any employee...