reference cell

Hi there, Is there a way to reference the current value for a page field without using a macro-enabled file (i.e. without VBA)? I'm trying to do dynamic chart titles (by having a cell that references the page field I care about), but I get in trouble if additional page fields are added or...

Hello... I'm writing a macro that creates a summary worksheet that references data from other worksheets. I want the summary page to be dynamic so that if the user changes drop downs on other pages, the cells update accordingly. For example cell G2 = "=worksheet2!A2" which equals "Tree"...

A Person using my workbook will go to sheet 2 and enter a series of integers from 1 to 5 inclusive. Sheet 1 will display analysis of the numbers. In order that the data be easily updated , I have had to use formulas which will refer to the right places when they are clicked and dragged, or in...

I need some help in subform references in formulas, ie, I have Main form: frmMain subform sfrmSub1 sfrmSub1 fields: cost1, cost2, iCnt sfrmSub1 will have more than 1 record For instance, how do I do calculations such as cost1 * iCnt, cos2 * iCnt etc. Also, how do I differentiate between...

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

I would like to reference a blank cell in Sheet1 and have it stay a blank cell in Sheet2 without a 0 popping up. Is there a way to do that?

I need to extract data from Sheet1 into Sheet2. The data being extracted is sample book analysis and each book has a series of row headers and column headers. The row headers are repeated for every book while the column headers are repeated once at the top. Each book is separated by a blank row...

Hi, I need to calculate formula in sheet1 taking values from others sheets. For example I have a formula in sheet1 containing the cell A1 of others sheets (sheet2,sheet3,sheet4 only). If i remove any one sheet (ex. sheet3), then the formula should work taking remaining sheets (ie., sheet2...

Here is my dilemma: I am given data that looks like this: I need to make it look like this: This is one of about 25 sheets in one excel file, and I will be receiving about 5 different files a week, so a macro is necessary to save time. I tried to create a macro just by recording, and it was...

I'm using Excel '03. I have a workbook with 21 spreadsheets. The first 20 are days of the month (Oct 13, Oct 14, etc) and contain job duties and the total number of hours for each job duty. The last spreadsheet is titled Summary. On the Summary sheet I have the job duty titles to match the...

I have a budget spreadhseet which has a column for estimated spend, and a column for actual spend. I have a SUM function set up to calculate the total 'actual spend' but if the actual is missing, I want the SUM function to refer to the 'estimated spend' column. Is this possible, I have been...

Hi- I was hoping somebody would be able to help me with a problem I'm having. I want to reference a table of events that lists the dates,the event type and benefits. Currently I have a working sumif that uses dates to retrieve values from a benefit column within a table, however, I need to add...

I created a macro that imports production results from multiple staff folders. Before I had the macro I was manually coping and pasting their results into staff tabs that was auto filling a PivotTable. When I clear the data that was imported the links to the other tabs are lost, they give me the...

I created a macro that imports production results from multiple staff folders. Before I had the macro I was manually coping and pasting their results into staff tabs that was auto filling a PivotTable. When I clear the data that was imported the links to the other tabs are lost, they give me the...

Quite a simple question: I would like to be able to type a range name, all of which I have already defined, into cell A1. When typed in, I would like VBA to copy that range to cell F3:(however big the range is). It would also be nice for it to automatically do this whenever A1 is changed. Take...