cell reference

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...

Hi everyone, I'm quite new to VBA on Excel and haven't quite been able to figure out how to get my macro working yet. I have data that looks like this: <tbody> Date Amount 1 Type Amount 2 Amount 3 Macro Output 01/01/2013 -100 A -80 -20 01/02/2013 -150 B -30 03/05/2014 -200...