references

I have a very large worksheet (68 meg) that I have split into 4 smaller logical worksheets. How to get the cell references in the carious sheets to update to the new sheet names? Thanks

I really don't understand why Excel is so complicated when you autofill down in picking the correct range. Even if I record a macro and use Relative cell references, it still hard codes a range into the command. I have a formula in cell P2 that I want autofill to the bottom of the table. I...

I am working with an existing financial model workbook that has a whole mess of formulas and cross references. I want to try to get my arms around the dependencies and links between worksheets in the model. I am capable of writing some parsing formulas in excel, but they wouldn't be able to...

I have multiple formulas that reference a certain cell but now I have to move that cell to a new location. I may have to move it again in the future. I want to have all the references to that cell reference the new location when I move the cell. I know that one way I can do it is to name the...

Hi, I've been struggling with a formula all afternoon, and am in desperate need of help for my own sanity. I have a workflow system which automatically generates references. The system will generate a reference which is always prefixed "GOC-" and then will be followed by 6 numbers. The...

I have a spreadsheet that I need to update twice a month (continuously adding columns every month) but the last 9 columns need to stay the same the whole time, so I want to use the following code to copy a specific selection and paste it 9 columns before the end of my worksheet, but I can’t...

Hi there, I'm trying to split a list of alpha numeric location references as shown in cell A1 into two distinct references that I require, as shown in cells B1 & C1. Can anyone assist? Any help would be grateful and I can tell my team off for not collecting the data properly in the first...

Good afternoon, Every day I need to extract references from large descriptions. I came up with a formula for the time being to extract some references, however, I'm sure that there are people on this forum who have a much higher Excel skill level than me. It would be highly appreciated if...

Hi All I am having troubles in trying to maintain references to a SQL datatable. I have a sheet where the user enters an order number, there is some VBA codes that runs an SQL script to an external database to bring back information to a datatable. All this works fine. However there is then...

If I have a column which has unique formula starting in D25 running all the way down to D1896. The issue I am having is I am trying to duplicate the exact column formulas by copying and pasting the original into a new sheet. However every time I paste it changes the references or is asking me to...

Hello, I hope someone can help. I need some VBA to create 3 Range names based on column references. My problem is that there may be 100's so I would prefer not to do it manually. I can create the references based on the columns, so column B would be as follows: What is the code to look at the...

Hi all, I have a workbook that i'm using to present analysis of a lot of data. Currently i'm using a sumifs formula with indirect references within the workbook and it's returning the expected value. However, the workbook is very slow and i'm looking to speed it up and make it more responsive...

Hi, Good Morning! I need your help to tweak this formula. I want to create a drop-down list that when ever I chose EXPORT, the details used will be in EXPORT sheet. I have different set of formula for every sheet and now I wanted it to be done on a single sheet even if the references will be...

Hi all, I'm somewhat embarrassed to ask as this seems pretty rudimentary but I can't figure out a way to fix this. I've built out a spreadsheet that crunches some raw data from another datasheet in the workbook. It works great but this will be a quarterly process with new/updated raw data...

Can anyone help me out here. I'm dealing with a pretty messy Cohord Analysis and I need to be able to paste across a row, but have the cell references move over one and down one each time I paste to the right. Does that make sense? Said another way, normally when you paste to the right, it...

Hi - I have a weird issue and I can't work out how on earth to fix it... I have a reporting template file that should have no vba code - it is accessed by another separate workbooks vba code (opens the template, adds some raw data into it, saves and closes it). Yesterday this was working as...

Hi Guys, I am trying to create a formula where I have a set of Data in Columns A, B & C. If the Cell in Column B is Blank then it references the adjacent cell in Column A in Column D. If the Cell in Columns B and A are both Blank then if references the adjacent Cell in Column C in Column D...

Hey Everyone, Here is my situation.. I have data in cell Sheet1:A1 that is referenced by 10 other cells on different worksheets. The references are all different (i.e some uses Sheet1:A1 in a formula, others are just =, some are relative references, some are fixed ad have the $). I am...

Hi Everyone, Thanks for looking, I need to display the full formula in excel showing the sheet references. Once I set Excel to show formulas I get something that looks like this; =IF(VLOOKUP(A2,'Letting Dump'!C:F,2,0)<>0,VLOOKUP(A2,'Letting Dump'!C:F,2,0),"Vacant") What i need is for the...

Hi I have a table, in col A (header name is ColA), there are items from A2 to A100. Col B (header name is ColB) will get the number of reparation of cell value in Col A using this formula in B2=COUNTIF($A$2:A2,A2). The question is. Can i modify this formula after converting the range to...