row

Hi, Greetings for all! I have a formula at Sheet2 as ...something(from this beautiful forum)..Sheet1!$A$2... When I insert 10 rows in Sheet1, formula in Sheet2 changes into ....Sheet1!$A$12.. How to prevent/fix formula to $A$2, how to fixate it to A2 Thank You in advance!! New Micro Excel...

Hi all. Here's a head-scratcher for you all... I have linked to an example workbook in Google Sheets below (unfortunately I don't have Excel on my home PC). Basically I have one worksheet - "Sheet 2" - with a bunch of data. I have another worksheet in the same workbook -"Sheet 1" - that I need...

Hi, CDEFG1Var AVar Bexpected result...

Hi, Sample of 100+k rows data: DEFGHIJKLM1MaxBIBexpected result :231.207021.207024Max Exist41.207021.2067551.207021.2088961.207021.2030271.207021.2070281.207031.207031Max X91.207031.20701101.207061.207063Max X111.207061.20702121.207061.20705131.207061.20702141.207021.20699151.207241.207246Max...

Hi, Sample of 100+k rows: FGHI1Bexpected result...

dear all, I'm currently stuck with Excel and I hope you guys can help me. I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed. This date will be defined in D3-O6. So the way it...

Hi, I am able to assemble a cell range (O21:O162) using this formula: =CONCATENATE("O21:O",ROW(XLOOKUP(INDEX(B21:B670,MATCH(TRUE,B21:B670<0,0)),B21:B670,A21:A670))) But when I insert it into a sum function, I get a #VALUE! error. Can someone show me what I'm doing wrong...

Hello. New to this board. I found some code that compares two worksheets (sheet 2 with sheet 1) to determine if there are any differences in the rows. The code works perfect for highlighting the entire row. If there is a difference in the row on sheet 2, it is highlighted in red. Instead of...

Hi I have a list of 4 digit numbers in a column in Power Query, for example: 1234 3827 3845 4028 3957 The file is refreshed with a new list each week with a differing amount of numbers. I want PQ to combine them so they end up in a single cell in the following format...

I managed to have to make it partially work; however, it copied and pasted a whole range from Data sheet - I want only the row that matches C6 from Entry sheet . Here is the code: Sub Find_Order() Dim entrySheet As Worksheet Dim dataSheet As Worksheet Dim checkSheet As Worksheet...

Hi All I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I have this formula to find content in a sheet called "Test", it works perfectly until later (G94)...

A B 100 1 100 2 500 3 400 4 100 5 200 6 7 200 8 100 9 100 10 I want to sum a maximum of the bottom five rows that have values. I want to skip the blank rows. So the results of the formula in B10 should be 100+100+200+200+100 = 700 I will use this formula in an adjacent...

Hello! I'm trying to highlight the active row in a table. I have multiple table in 1 sheet and I already formatted the sheet to highlight the row when selected. However, when selecting the row in a table, it also highlight the same row in all the tables. is there a way to only highlight the row...

Greetings experienced, With my limited knowledge of Excel, only know basics, I was thinking to use function "=IF(AND(N4=1,O3>0), , ) " & "(INDEX(O:O,ROW()-O3-1" ,in formula but do not know how to structure/complete it. When cell in Column N =1 and above row of it, cell in Column O >0 , assign...

Hi there, I have found some old posts on this topic but nothing that seems to solve my issue. I am using the below formula in order to pull a list of individuals names that have correspondence through the same email address. For example if Mr John Smith, Mrs Jane Smith and Miss Janet Smith are...

I have a range ("A31:AB31") in the "Input incidents" sheet, so I need to paste it (only values, no formulas) at the next available row in a data base ("Incidents_Accu"), the columns are also A:AB in the data base, the information should be accumulated in the data base by clicking on an ActiveX...

I tried putting together a code for a checkbox in Sheet "Budget" which will unhide 4 rows on Sheet "Vendor Cost". When the checkbox is ticked, it should unhide the row on Sheet "Vendor Cost" which contains value "1000L" on column A and 3 more rows underneath it (no value on column A). I can't...

I am trying to create a code that can create Namelist amount of emails. Each email should include some specific cell variables such as name and email AND a table in which i need the header from the excel sheet and a specific row. I have tried to incoporate a take one row at a time approach but...

Hello, I am very new to VBA and looking for help hiding rows if the the first cell (Column A) in the row (7-72) is zero. I would also like to unhide the rows if the cell is not zero and ideally not have to manually run the code each time the values in column A change. Column A is dependent on...

Hi, I am trying to sort some data, if I indicate header:=xlyes it only exclude the first row. However, I need the first 2 row to be excluded from sorting as I have the first 2 rows as header for my table. Does anyone knows how i can exclude the first 2 row when sorting my data using VBA? if it...