dynamic cell lookup

This is not looking for a solution its more so advice on if its possible. Was looking to create a dynamic floor plan in Excel where on the raw tab you would enter certain dimensions of a piece of equipment and it would then map it on a sheet. Something like Item A being 6*3 meaning its 6...

Hi smarties I am trying to make a table that turns this: <tbody> John potato 1 Mary cranberry 5 David salsa 4 Stacy potato 6 Greg potato 2 Anna salsa 3 </tbody> Into this: <tbody> John Potato 1 Mary Cranberry 5 David Salsa 4 Stacy Potato 6...

Hi all, Wondering if you could help me here. I am trying to create some profiles for some players in which I change the name and their picture changes. I have created a table with their picture next to their name and followed some instructions online to make dynamic pictures however I keep...

I have two sheets. Sheet1 has a table of data that I will need to lookup, and I will be pasting data from another workbook into Sheet2 that has somewhat consistent column headers but in different orders. I want to put a formula in Sheet2!A:A that finds a specific column in the pasted data and...

Sub numbers() Dim rngCell As Range For Each rngCell In Sheets("Final").Range("F13:F" & rowLast) If WorksheetFunction.CountIf(Sheets("Filter").Range("A1:A" & rowLast), rngCell) <> 0 And _ Range("I" & rngCell.Row).Value <= 0 And _ Range("D" & rngCell.Row).Value < 50 Or _...

Hi, I am working on a report which divides total income down to each consultant. In a sum up page I sum up the total amount of income on different projects gathered from different pages in an Excel document. In addition, I want to add under each consultant a formula which fetch project...

I have successfully created several drop down lists however I am trying to display different drop down values based upon a selection. Ex. In cell A3 it displays a drop down list with the values Keyword, Certification, Skills If a user selects Keyword from cell A3 I want them to be able to...

Hi, On Sheet 1 I have: A row of consecutive monthly dates (Jan-14, Feb-14, Mar-14, Apr-14 etc.) - let's call them A1-Z1 A row below with Sales figures for each month (1,2,3,4,5 etc.) - let's call them B1 - Z1 On Sheet 2 I have: A row of dates which represent different period end dates which...

I would like to repeat a formula and make its dynamic depending on the request. The formular that I would like to repeat is...

Hi All, I currently have a spreadsheet with the following sheets which are tables, I also have a worksheet for every month and creating a monthly view of each day in their associated worksheet, I basically need a VBA macro to use the below information to construct a matrix such as below...

I work for an insurance brokers who sell policies on behalf of a panel of insurers. I've been given a spreadsheet containing sales data where each individual row represents an individual sale, and each column represents a different element of each such sale. For example: <tbody> Insurer Area...

Hello all, I am new to VBA and really trying to improve. I tried looking a solution up, but couldn't really find what I need. Can anyone help me? or have an idea would be great! I really appreciate it! I can't attach the xls, but here is how its presented: Column A has the daily dates, column D...

Hello, I have a sheet called “Calculation” on which column E that contains (from row 4 below) approx. 50 numbers (results from a formula) and somewhere in these 50 numbers one row that contains the text “maximum” (also as a result from a formula). This formula is for row 4...

I have what I think is a pretty simple question. I have a column (A) of stock symbols (IBM, WMT, CAT). As the first part of this project, all I want to be able to do is to make a query to yahoo finance to get the name. What I do is this. 1.Click on cell B1 and go to Data -> From Web 2. the...

:) Good afternoon, What i'm trying to do is to have a dynamic comparison between cell values. Here is the case: In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column...

Hello Excel Masters, after a few days searching and puzzling, it is time to ask the masters... It is more of a project then a single question, but maybe you can direct me to the right page for certain aspects. I have one master sheet 'Totals', built up like: >>> Customer Number Name...

Hi, I am building a Comp sheet that automatically populates a long list of stock tickers with a corresponding "sector code" Ex: <TABLE style="WIDTH: 86pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=114 x:str><COLGROUP><COL style="WIDTH: 86pt; mso-width-source...

I have a Lotus spreadsheet that was created before I started here. I am attempting to recreate it in Excel. I have a Field I a dynamic field G6 which the user puts a date in. When they do this Field B10 needs to be populated with the number in the corresponding date field that is on sheet1 of...

Hi, I have a range where I want to find a cell address based on another function, like HLOOKUP or any other. But when I use HLOOKUP function as a 'refernce' argument in Excel's inbuilt function Cell(), it gives an error. Is there a way, that I can find a cell address based on any of the...

Hi All, I have just started VBA-ing in Excel, and feel I am way over my head. Any solution to the following would be greatly appreciated: Basically, I have two two workbooks, let's call them data.xls, and model.xls The model workbook needs to pull numbers from the data workbook. Basically the...