referenced

Good day all, Please i need your collective help with this small excel database which i created. I have an excel workbook with lot of worksheets refrencing to one sheet in the workbook and also referenced to other workbook, but whenever i delete a record by deleting the whole row, it...

I have a formula that references a table inside the file I'm working in, but I don't see the table in the Name Manager. All filters have been cleared. How is this even possible? I thought all tables were referenced in Name Manager.

Hi I'm hoping someone on here will be kind enough to help me out with a little VBA coding to have a Text box display an coloured arrow depending on a cell value. The reason for this is due to having a dashboard look to the sheet i'm working on which is made with a large shape that has a...

I am looking for a formula/UDF for computing the Variance of Folded-Normal distribution which incorporates the ERF function. The formula for the same can be referenced at https://en.wikipedia.org/wiki/Folded...l_distribution (PS - also posted with a different title...

I am looking for a formula/UDF for computing the Variance of Folded-Normal distribution. The formula for the same can be referenced at https://en.wikipedia.org/wiki/Folded_normal_distribution

I'm trying to tailor the IF command to put "SP" in a cell only if the referenced cell has FS in front of the number (i.e. FS101RR). FS will only be at the beginning of the entry, but isn't always there. What I've got isn't working which no doubt means it's not right. If there's not an FS in...

When you reference another workbook and add it to the references, is that reference then available to all excel workbooks or just the one you referenced from?

Hello I have a sales transactions sheet and I would like to add a column that would look at the sales date and compare it to a date in a referenced cell. If the Sales date is equal or 6 months greater. I would like column to state AFTER. if 6 months before referenced date , I would like the...

Can anyone tell me what the problem is with this code snippet? Range("D5").Formula = "=match(D6,ChTables!$A:$A,)" Range("D7").Formula = "=OFFSET(ChTables!A1,D5,53)" Range("D8").Formula = "=OFFSET(ChTables!A1,D5,47)" Range("D9").Formula = "=OFFSET(ChTables!A1,D5,51)" Range("D10").Formula =...

Hi everyone, I'm having trouble making this formula work. Essentially I am trying to Count anything in column A that has a C, for the date that is referenced (C8). What I am trying to do is..... If Column A equals the letter "C", then count any values under the referenced date that are greater...

Hi All, Looking for a little help on how I can quickly highlight the cells referenced in sheet 1 by formulas in sheet 2. The (Ctrl + [) work great if the formula and cell are on the same sheet, but how do I achieve a similar result crossing sheets. Background: Sheet1 - Raw Data; Sheet2 -...

Hi I'm pretty much new in using check boxes and option buttons and i would like to seek your assistance with this problem. I'm currently creating a form that reviews a certain audit that has been made based on the referenced row value. Essentially this is the code that I have to return the...

Time to clean code in one file I have this for highlighting some cells in a selection For i = 4 To 35 'rowNumberValue Cells(rowNumberValue, i).Interior.ColorIndex = 37 Next I I would like to just select the row referenced as 4 to 35 without a loop and apply the colour and...

In a sheet called "Summary" I have some hyperlinks to various other sheets. In some instances, once I click the hyperlink it takes me to the referenced cell in the respective sheet, however the referenced cell is at the bottom of the screen (because there are other data above it) and I have to...

I have a formula that references the numeric value of another cell with a formula. It doesn't work.... how can I fix this? Non-Working Formula: =IFERROR(IF(OR(F8/D8>0.05,F8=E8),"X",""),"") Referenced Formula in F8: =IF(E8="","",IFERROR(E8-D8,"")) Where the value in cell F8 and E8 is both 11...

<tbody> I have 2 spreadsheets which I will refer to as (spreadsheet 1) and (spreadsheet 2). I have values under a row called "name" in spreadsheet 1 that I need to cross reference with spreadsheet 2 within 4 of its sheets as to whether or not those values exists that I referenced...

Good afternoon. I’m trying to figure out why - when I am using Find/Replace to update formulasthat are linked to other files – each formula requires me to go back to thereferenced file each and every time which may be several layers deep. These spreadsheets have hundreds of formulasin them –...

Hello, I am attempting to = a cell from another tab with increasing a referenced cell by the cell below it and paste that formula every 5th cell. I have 1,300+ rows that I am manually having to change the cell to (d4, d5, etc) in that referenced tab formula. For example, my cell T6 says...

Excel Gurus- I am using excel 2013 and have run into a problem I can't seem to find a solution to after some fairly extensive searching. My problem is that I have an elaborate data table with 3 plots referencing the data and I want to be able to copy and paste the data table and plots on the...

Hi Hope you can help, I've tried everything to get past this problem and so far have draw a blank. I have an excel file which lists the 'up to date' selling prices of all the goods/products my company sells/manufactures called 'PRODUCT COST.xls' then each customer will have an excel file which...