cell reference

Hi, I'm wondering if anyone knows how to make a formula to reference a cell based on a solution of another problem. For example, could I do something like this.....? <tbody> A B C D E 1 -2 -3 .11 2 3 -2 .56 3 -1 .18 4 1 .96 5 2 .33 6 3 .85 =if(B6=A2, C6, "") =if(D6=""...

Just a quick question. I am working a lot with the Ascend order function, and was wondering if there is a way to guaranttee that the cell references don't get mixed up. I am working on two different lists with mostly the same data, but the second list has a few entries omitted. In the process...

Hi, I'm trying to use a variable as a cell reference in a formula using '&', but can't seem to get it to work. I've looked through the forum, which have examples of how to do this using a range, but not just as a single cell reference. This puts the formula '=VLOOKUP("A & lastrow &"" ...

I have seen all the posts with the macro to change pcitures based on a cell value but I do not want that. I was wondering if someone knew how to store a picture in a cell, not a comment, name that cell Logo and then in other cells type =logo and the picture be displayed Thanks for the help

I am trying to add numbers from first sheet data to second sheet data. I have to reference to another sheet a fixed increase of moving 8 rows across. What would be the formula for it? For Example: =SUM(SS!C2:SS!MM2) =SUM(SS!C10:SS!MM10) =SUM(SS!C18:SS!MM18) =SUM(SS!C26:SS!MM26) What would...

I am calculating a payback period (savings - expense) on a weekly basis. I am aggregating savings and expenses each week and at some point in time, my aggregate savings > aggregate expenses. The payback period only happens once, when the aggregate savings > aggregate expenses. I would like to...

I am making a schedule in excel and want to highlight cells in which people are on overtime. One work sheet is a schedule a separate worksheet calculates everyones hours in a month (column a are the names and column is the hours). So in the schedule worksheet i have a conditional format that...

I have a series of formulas to calulate values from a table, and there may be one or more criteria for a given criteria range. For instance, there are two criteria listed for the Species range and three for the Product range in the example below...

Hi, I am using the following vba save code; ActiveWorkbook.SaveAs Filename:= _ "G:\Baskets\" & Format(Now, "yyyy-mm-dd ") _ & Range("C104").Value & " " & Range("C102").Value & " Basket1.xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False Cell C104 = "BUY" Cell...

Hi I have a problem that I don't think the "indirect" or "offset" function can help (I could be wrong) I have created a macro that collects market data on a daily basis and inserts a new row (Row 2) with a time stamp and all kinds of various market data in different columns. The goal of this is...

Hi, so far with this code I can only reference the active cell that is clicked on AFTER a cell is edited; I've tried to work around this by having the users only click ENTER after editing a cell, and by offsetting everything by -1 row. I would like to directly reference the cell that was edited...

How can I use the cell as the name of the worksheet I want to lookup. e.g in cell B3 I have the text "Glasses", I also have a worksheet with this name. So in the first worksheet, I want my lookup vector to use the cell reference to determine what worksheet to lookup. I have tried just the cell...

I want to point the customers to the corresponding pivot table (On the same worksheet but far from the main screen) when they click on a pivot chart. I have tried to use the insert hyperlink. But it keeps the reference cell at the bottom of the screen and doesn't make any sense to the customer...

Hi, I am new to using VBA and need some help. I have 30+ sheets in my workbook each named after a product (Product A, Product B, ...). The cell A1 in each sheet has the name of the tab. For example: Cell A1 of Product A sheet has Product A listed. In another workbook, Cell A2 is a dropdown...

Ok so I have a workbook with several sheets, this question focuses on two sheets. 'Coded Prehospital Data' and 'Missing Pre Hospital Data', for brevity here i will refer to them as coded and missing respectively. In coded the cells are populated using an index/match fx to another sheet and if...

Hi, I am new to this forum and haven't posted but more searched and tried to find a solution to what I need and I haven't found quite what I need so I will post and hope I can get an answer. I have 6 status sheets that have each working day (6 branches) that show how many payments were Money...

Hi All, I am currently having real problem using the formula below: =INDEX(Data!C:C,MATCH(B7,Data!A:A)) What i am trying to do with this formula is return the cell address of an item that is in a different sheet. The reference the for search is in Cell B7 which is a date, it then looks at a...

Sorry if this is in the wrong place, I'm a first time poster. After a few guides I'm still having trouble doing what I set out to do. I'll start off with the basis on the spread sheet, so let's say in Excel, I have; <tbody> A B 1 Place BHX1 2 Date From 04/10/13 3 Time From 21:00:00...

How do i reference a cell range in vba when the range is dynamic? Basically I have a table underneath rows of data, at anytime data can be inserted into those rows. So everytime data is inserted my table shifts down a row and the cell reference in my vba code no longer match up. Is there a way...

Hi everyone, I am using the spline function like this: =Spline(A26:A31,B26:B31,A28,FALSE) but want to look up and construct the ranges based on variables, something like...