retrieve

Hi, I am using the following array formula to retrieve data from a Table on a sheet. {=IFERROR(INDEX(MasterTable!$C$2:$C$564,SMALL(IF(MasterTable!$A$2:$A$564=$BR$2,ROW(MasterTable!$A$2:$A$564)-1),ROW(MasterTable!1:2))),"")} $BR$2 contains the matching criteria. The formula works absolutely...

Hi All, I know this is a fairly common topic, but I'm still having trouble. My table: Column A) Account ID Column B) Account Name Column M) Parent ID Using partial account name, I need to retrieve all values in Column M that match. I'd like the output to populate horizontally in separate...

Hi All - I am trying to create a macro to retrieve data for the same range on 20+ tabs using one click. The code below works in moving between the tabs and selecting the range, but the Essbase Retrieve is not working. Any assistance you could offer to help me figure out where I'm going wrong...

Hi all, I'm trying to create a formula in which I can pull names from my big data table. One formula and I can drag it down and it fills up with all approved names (based on the criterias). I have names in column A, values in column B and other values in column C. I want to retrieve all names...

Hi, I'm looking for some vba that will retrieve data from a table in one wksht and drop it into a table on another. Looking at the picture below, I would like to be able to enter header values in the cells C5:Q5 in the 'Report' wksht then press the button to execute a macro that will retrieve...

Say I am interested in the first 100 rows of column_j and I know the j. How can I retrieve this values in non-volatile way, using formulas?

Is there someone that can assist with some VBA code that will save data from various cells across multiple worksheets into a table that I can later retrieve and replace any of the cells that have been changed? Ideally I'd like to be able to copy this set of cells multiple times, collecting...

Hello I´m very new to VBA and I need help for some work i'm doing. The macro below opens the webpage i want, then inserts my ref, then submits. After submiting it, it opens a new webpage. What i need is to retrieve some links in it. The links is "javascript:loupe(R0000000001)" the last numbers...

Good Afternoon, I wrote a VBA in Excel (below) so I can retrieve comments but I quickly realized that people are using multiple cells in multiple columns to make comments. Is there anyway I can create something that will automatically find the comments and put them in an empty cell? If I...

In a sheet like that: <tbody> 3 1 2 7 0 </tbody> How can I get retrieve the value that is >5 and <=10? Thanks.

Hello: I need some assistance. I am trying to retrieve rows of data based on specific values of a column (field 15). I wrote a macro (see below - I only copied a few UPC items) by using Filter and then I was going to input the remaining UPC item values, but it's over 100 and I ran out of room...

I wanted to give this code to people that like me had a hard time getting it to work correctly. The 2 codes work as function in an Excel sheet and depending on parameter set, will return whatever has been filter on a particular field. 'Returns AutoFilter Criteria (Not to use on Tables) Function...

I want to know if it is possible to retrieve data from excel sheets automatically without making any changes. This is the document link that i want the document to be like: [https://www.dropbox.com/s/a3pl7ets703ohxy/TOP%20Sheet%20.xls?dl=0] And, this is the link to the type of document that i...

Hi there, I am creating several Smart View template retrieves in Excel, using some mild VBA to retrieve data and metadata, and to spit out copies of certain tabs to new worksheets in the same workbook. The VBA includes a loop to go through each spreadsheet to retrieve the data. Over time, the...

I am working making a primary sheet that retrieves data from other sheets automatically based on entries in certain cells using macros. My main sheet lists tasks, and my secondary sheet lists responsible party metadata (contact info, etc.). If a responsible party value is entered in a...

Hi guys, Please refer to screenshots below for reference. So basically I want to be able to keep track of how much vinyl material I have left after each order. The process would be - When I order a roll of vinyl material I would input the colour ordered and cm ordered by selecting from drop...

Hi all, The below code works fine when retrieving from the one database but does not when trying to switch databases (where I put "server = Sheets..." for the second time). I assume this is because I have used Declare Function at the top and can't define the server, application and db twice in...

I have two worksheet. One worksheet is a form where in the Field Door No. should be a dropdown list. The list will be retrieve from worksheet Source. Now upon selecting a specific Door No. it should also autopopulate the respective Type, Brand, Serial No., and Type. First thing i need to know...

Using this grid, how may I retrieve the TEXT value "Sprint 00" from the top row of the column marked with "X"? I'd like to retrieve the TEXT value of "Sprint 00" into the first "???" row under the "Sprint" column. Subsequently, I'd like to retrieve the TEXT value "Sprint 01" from the top row of...

I have made a form to enter the details to save in database. I want to recall the data for editing. Using web help, used the below code, but showing error when i press the findnext or findprevious command and highlighting in Set LastFind = Where.Find(Me.NO, LookIn:=xlValues, LookAt:=xlPart)...