retrieve

I'm working on a project with tables. I'm not sure if I can use a function or I have to vba. I want to retrieve the lastest 5 entries for a specific column (column AA), but not blank ones. Then I want to retrieve latest 5 entries for column AC. On a seperate sheet I want the entries to be...

Hello, I have created a number of complex functions that use or create 1-dimensional numeric arrays in VBA, and I would like to store and retrieve some of these arrays within single cells of a worksheet so that I can use them in dependent functions without having to store and display the entire...

HI I currently have a macro that searches several tabs for information but i need a way to display in a cell the tab name that the information is located on. eg the macro returns the unique number 123. What tab is 123 on?

Hi! I am trying to use a lookup to find the quantity of a certain fabric. However, more than one style uses the same type of fabric. Is there a way to do a lookup that retrieves multiple values? Any help would be greatly appreciated! Thanks!

Please help! I am very much a beginner! I am trying to write a code that retrieves information from this sheet entitled "Upload": A, B, C, D North America, Florida, Population, 938397.02 North America, Florida, Temperature, 85.04 Africa, Ghana, Population, 829783.50 Africa, Ghana...

Trying to help speed up a task at work. Any help would be appreciated. I want to retrieve a value and put it in Cell A5 of Sheet 2, but I must first identify the correct value in Sheet 1 that I need by doing the following. I want to evaluate/search the an array for a string of (e.g.) the word...

I know it's probably pretty basic, but I'm really a beginner. I need a VBA code that will do the following. I want to retrieve a value and put it in Cell A5 of Sheet 2, but I must first identify the correct value in Sheet 1 that I need by doing the following. I want to evaluate/search the...

I think it's a simple question. Can someone help me with the VBA code? I have a tab for each month of the year: Jan, Feb, Mar..... For each tab, I want to retrieve from a named range. Each of these ranges will be identical. For example A1:C20. I'd like to be able to assign this...

thanks for stopping by, can you help?? I'm using a worksheet as an ordering system with multiple command functions. One function of the system allows users to place a new demand, and this is carried out using a UserForm, the code for which is below: Private Sub placeDMD_Click()...

Hi, I have a workbook with 25 worksheets with multiple cross-referencing formulae. I'd like to produce a list of all formulae within the workbook accompanied by the cell references that contain that formula. Thanks.