referencing a cell

Hi Everyone! What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is. I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...

The formula I'm using is: =SUMIFS(Examples!$I:$I,Examples!$F:$F,"m6300-47101-0000",Examples!$C:$C,"=1",Examples!$B:$B,"*"&$A$1&"*") This section in red is the only part of the equation that I'm having issues with. I'm creating a PO tracker, and the A1 box is the drop down box to select the...

I'm having problems getting the contents of a cell to display where there's text and numbers in the cell. It's a problem that I've never come across before, and I've no idea what the problem is. I have a table with column headings that I need to display in another table. Simply using =K4, L4...

Hi All, I have an unusual question I am really hoping you can all help me out. I have a "Master Spreadsheet" that references to multiple other spreadsheets and their specific cells. This is done by inputing the directory and the referencing cell (e.g A1) into the master spreadsheets cell. e.g...

I have a worksheet where I am trying to apply conditional formatting. I want to apply the equation =($C$6/'Q1 2016'$C$6)>$H$39 I am trying to apply this to my entire worksheet but it will only work for the cell C6. The entire range I am using is from C6 to AB10. How do I have this code which...

Hello, I have this formula that works fine: =IFERROR((INDIRECT($A2&"!C30")),"") I need the column in the "C30" reference to change as I copy and paste it to the left or the right (ie. B30, D30) I'm guessing I need to use the "column" function in there but I can't figure it out. Any help...

I have a master sheet (Master) that references another workbook (Details) that I use for inventory control. Details has a separate sheet for each part number (Part 1, Part 2, etc.). When a new quantity of Part 1 is entered (in cell A1, Part 1 tab, Details workbook) I want it to show up on the...

I have a weekly report that accumulates numbers YTD. Easy example: Sheet 1 (name "week 1") A1 = Sales for week 1 B1 = A1 Sheet 2 (name "week 2") A1= Sales for week 2 B1= Week2!A1+Week1!B1 Sheet 3 (name = "week 3") A1= Sales for week 3 B1= Week3!A1+Week 2!B1 Each sheet is...

I am trying to create a summary sheet that pulls information from all the work sheets in the work book. Each sheet is identical from with the exception of the information and the naming convention is (#the the number) The summary sheet has 5 columns Author (B8), Date Initiated (B17)...

With the problems and limitations I have had with the "Conditional Formatting" in the Styles Menu I have decided to approach it a different way and need your help.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> The table below is just a small...

Is there a way to transfer conditional formatting across sheets in a workbook by referencing the cell? I have a large workbook that has Mon-Fri calendar schedules showing when employees are working. The Master Calendar tab is where we edit content and apply different colors to the cells so...