reference cell

  1. A

    Calculate formula while inserting and removing sheets

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

    Relative cell reference for summing

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

    How do I extend a series of data referenced from another worksheet?

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

    Need help with a SUM function!!

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

    XL07 Referencing table coloumn values in sumif statements

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

    Importing Data

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

    Importing Data

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

    VBA: Copy Paste Range Question

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

Some videos you may like

This Week's Hot Topics

Top