references

Hi Everyone, I'de really like some help with incremental formulas and worksheets, please. Currently, I have a formula =SUM(Jul!K36:P36) in cell M9 - this references cells I need summed from my "Jul" worksheet (obviously right!) I have a series of work sheets named by month Jul,Aug,Sep... (you...

Hi, I am trying to expand references by comma delimited but not sure how. can someone help with this please Example: From This: <tbody> References A3, A7, A10-A15, A17, A19 B12-18, B20 C01-C09 D01,D04,D08,D013-016 </tbody> To This: <tbody> References...

is it possible to have a table array name in one cell, and in another cell, the VLOOKUP formula which references the first cell containing the array name? Example: A2=twofootlampsfull A4 = =VLOOKUP(T3,"A2",7,0) any help is appreciated!!

Hi all, My first question on here - so go easy! I have a sheet with over a million data elements (1000s of rows by around 100 columns). I've been given another sheet with the references of the exact cells that need updating, along with the new data that needs to go in to those cells. i.e...

Take a look at the spreadsheet. The references will change after sorting and break the calculations. Absolute referencing is not an option. The table has to be copied periodically to another sheet and placed it at a different row (the columns are identical). Absolute referencing will break the...

I have this formula: =IFNA(VLOOKUP(1,$C26:$F33,4,),"") I would like to swap 1 for a 2 and the 4 for a 1. Changing the formula to: =IFNA(VLOOKUP(2,$F26:$G33,1,),"") I am having to use "column 1" as a slave that references another column Is this possible?

Below I have posted my code that updates a fill down list, but The highlighted section in red gives me an error if I make the range selection bigger. The range has non contiguous cells that need the fill down list updated all the way down to cell 467. Is there a work around for this? Maybe...

Hi. Got what is hopefully an easy problem - Have created a nested IF formula that references multiple worksheets within the workbook and from external workbooks. All this is working fine. The problem arises when I try to copy the formula - the references within the workbook update to...

Hello everyone! I am working with a table, which is new to me, and I'm trying to create absolute references to identify the first instance of a duplicate value. I found the formula to identify the first duplicate value from Exceljet found here...

Hello all, Using a mac so cannot post my data sadly. (Excel for Mac latest version). Brief * One workbook, data extract needs to be checked against another list. One source of data is from a CRM another from excel. All data has been cleaned and sat in two tabs. Objective * Check if items in...

I am working to create a document that using VBA code can open the most recent document in a folder each month when the report is run and then do vlookups from that document. I have a code that opens the most recent document in a file folder location but when I record the code for the vlookups...

Hello, all. I can't find this question referenced in the forum before. I have a sheet where Column 'A' always remains the same each year I use it. But I always add columns between column 'A' and 'C' each year, like this: Year 1 <tbody> 2017 2016 Turnover </tbody> Year 2 <tbody>...

I have taken over an Excel workbook with some complex macros. I am having difficulty working out which cell(s) a particular formula references. The extract from the macro is: Range("F2").Select ActiveCell.FormulaR1C1 = _...

Win 10 / Excel 2016 Hi all, I was wondering if someone could give me some pointers please... Long story short, i have a 'tool' that i created that will search a workbook for external links and list them in a text file. I've recently found an external link that my 'tool' wasn't taking into...

Hi, I'm trying to create an array (which will be ultimately used in a formula e.g. NPV) of cell references which repeat themselves (which will be dependent on another cell reference). The range of cell references to be repeated will also be dependent on another cell reference. Sorry if I didn't...

Hi All, I have a macro that uses cell references from Column B, it uses a lot of cell references in Column B. Is it possible for me to set it up a macro or adjust it, so I could re-use that code for columns B, C, D ect keep the row references. Below is a hugely simplified version of what I...

Hi all, I have an annoying problem that must not be present for a file I am making for end users with little Excel expertise. I have a file that copies a worksheet from it to another workbook. If the user saves the originator file (the file from which the worksheet was copied from), the...

Hi all, I'm hoping someone can help me! I'm working with some data where each cell contains multiple entries (which are unique references). Essentially I want to compare A2 and B2 to show how many entries should still be live. I can get a numerical view of this in C2 by using...

I've tried all the usual solutions. Checking if automation is on. cells are not set to text. Check for Circular References not an issue The strange thing is if I restart the computer it will sometimes work. Corrupt excel or something else?

Good Afternoon, I have come unstuck with an Excel sheet we have after trying to automate part of the document. This spreadsheet tracks costs over a year based on what week it is. Each member of staff has a spreadsheet seperate to this one where they fill in data, and that data is referenced in...