ref

in a cell H3 i have ref to =C3 i need H4 to ref cell =B3 i need H5 to ref cell =C4 and repeat down many rows . if i copy down excel doesn't work out i need the pattern to repeat. how can i simply copy down? i.e then in H6 need =B4 H7 =C5 H8 =B5 and so on TIA

Hi can anyone help with a macro? I have many hundreds of rows of Data on Sheet2 "A1:Z" with headers. "A2:A" has 'Ref values' for each row of Data. Sheet1 column "R5:R" has 'Ref values' added that change daily. I want to Filter Sheet2 "A:Z" using "A2:A" as field, based on the Values entered...

This is my formula but if any cell in range c5-c41 is blank it returns a ref error...

Hi, Hope someone can help. I am trying to create a formula to lookup data in an input sheet and create a summary of key info and gap analysis. the table looks simply as follows: <tbody> <tbody> Input Table REF Region PM Wave Ref 1 Region 1 PM1 Wave 1 Ref 2 Region 1 Wave 1 Ref 3...

Hi Guys, Below formula keeps on giving me REF error. I cannot figure out why, can anyone have a look at it {sum(indirect("'[benchmark 04.30 project.xlsx]" & $H7&" '!M$6"))} thanks

Hi Guys I have the following link https://www.dropbox.com/s/i77n2rc0c5pgfk7/transpose.xlsx?dl=0 Sheet1 is my data table and Sheet2 is the output. You will notice that there are five Ref Numbers which are the same(TV201801/000380). These Ref numbers are assigned to the name of the persons...

Hi I am helping my local historical society in a voluntary capacity to get their website on line. It will contain a catalogue of 400-500 documents. I have a list of them which I can get into excel. In excel they appear as: column 1, a code for where they are in the filing cabinets, eg...

Hi, I will try and make this all make sense.... I have a spreadsheet with 3 work sheets, A,B,C for ease sheet A is master, in which I have columns A - K, Column B has a ref number, this ref number is also in Sheet C on sheet A in column I, I have a drop down list of Y, N, U which I have set...

I have the following formula below =IF(IFERROR(VLOOKUP(A5,'[Group Stock Report.xlsm]shirts'!$J:$J,COLUMNS(J:J),FALSE),VLOOKUP(A5,'[Group Stock Report.xlsm]Trousers'!$I:$I,COLUMNS(I:I),FALSE))="","Item in stock","item Sold") The ref number in the source file is in Col A Kindly amend my...

hi, I can save the file based on 1 cell ref, but need to also use 3 others? cells ref :- B4 = name e7 = james w2 = ID Number w3 = 008 file name save as c:\data\namejamesidnumber008.xls hope this makes sense & thank you :}

Hello I have formula that's working fine in small data but now I have to use in a large data set so I really need a way to optimize the formula. the table is like this, <tbody> Ref Name Height Strength Weight 1 A 150 120 60 2 B 150 120 60 3 C 110 10 60 4 D 180 200 80 </tbody>...

Hello Newbie so please bear with. So, I want to pull a Value from a table using the lookup based on data in column A of a new sheet. I need to use the header rows of the table to find my Value as the number of columns will differ but the row header will not change. For example <tbody> Unique...

Dear Experts, I'm pretty much a newbie on VBA. I really need your expertise for below case:- I need to transpose the values/TURNS from PivotTable1 to Dashboard sheet under column B by using macro. Codes are already written but i'm facing an error on "REF". Is there something missing from my...

Hello friends, I am using this formula to to get the smallest value in the range. Like 1st to 5th Smallest value. Here is a sample data <tbody> 95822 123 95825 123 95828 123 95830 123 95831 123 40041541 127 40043227 127 40042045 129 12943122 A 130 12943122 B 130...

Hi, Apologies if this has been asked before as I am sure it has (for the life of me I can't find a thread for it). I have a csv file called "import.csv" in the format: <colgroup><col style="mso-width-source:userset;mso-width-alt:512;width:11pt" width="14"> <col...

I have a very large spreadsheet which looks up a number of different other tabs to return the project someone is working on across the day. I'd like to colour the different projects and I could use conditional formatting however there are around 50 different projects and I'd like to find a way...

Hi. I am trying to write a formula in G6 of worksheet MAIN that uses the contents of a cell (G4) on worksheet "MAIN" as a reference to a worksheet with the same name (plus one word) as the cell e.g. MAIN,G4 = monkey MAIN,G6 would normally equal = ‘monkey baby’!E30 Unsurprisingly...

I'm having an issue getting the worksheet ref to change to the next sheet automatically as I copy them to the next row. Table 10 is my sheet name. Followed by 11,12,....229. Using formula: =if(B$4="",if((or('table 10'!$B9="comment",'table 10'!$B9=""),"",B$2&" / "&'table 10'!$B9),"")

I have Refences in Col G I have tried to set up a formula below to look up the reference in Col G on workbook Sales BR1.xlsm on sheet Data Import in Col D as well as on Sales BR2.xlsm]Data Import’ and if it exists to return the ref number, otherwise return a blank It would be appreciated if...

Hello, I'm sure it's relatively simple but I'm trying to do a formula whereby I can return the Ref no. in column C if there is cost in column A but no volume in Column B or vice versa. I want to try and do it all in one formula but when i try and add in the OR part of the statement, excel wants...