rows

Hello! I am new to excel and have learned a lot from these messages boards and hope to keep the learning momentum going. I have a large dataset with over 25k rows and hundreds of columns. I would like to delete rows (participants) who have over 50% missing values per variables. Each column...

Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need to replicate this for the 19 rows beneath this. Do I need to Keep writing the same code for each row or can I write a code to cover all the rows...

Hey, Please I need help in this case; thank you in advance! I insert data and have the data in Table1 in Sheet1: <tbody> A1 DATA B1 Order =COUNTA(A2;A1000) (result: 2) A2 Car 1 B2 25 A3 Car 2 B3 45 </tbody> Every time I insert new data, new data might add/cut rows to/from this table...

Hi Everyone, Thanks for this awesome forum. I've spent a lot of time on here in the past and am normally able to get answers from previous posts but this time I can't so trying to post myself. I want to write a macro that takes the values of a set of columns (the number of columns will vary...

I am using Excel 365 and have a worksheet with a threaded comment. I wish to hide all rows from above this comment to the bottom of the worksheet. If this were a normal comment, now called "Notes", I could format the comment to move and size with cells and this would allow me to hide the rows...

Hi I have the below code to copy rows with data from one workbook to another ignoring the first two rows as these are header rows however it is only copying column 1. Where am I going wrong? Sub Export_data() Dim ws As Worksheet, wb As Worksheet Set ws = Sheets("Triage") Set wb =...

I have a sheet that has groups of 50 rows with a row to separate each group from the next. I would like to increase the amount of rows in each group by 150 (a total of 200). So starting on cell ("D55") add 150 rows above D55:AA55, then go down 51 rows and repeat for cell ("D106") [add 150 rows...

Hello, I am wanting a macro to automatically run when a spreadsheet is opened to check a cell to see what month it is then hide some rows off the back of that. It should look something like the below saying if C5 is one of those months then hide rows 12-18 in the sheet Check List. Private...

Hi, I've got this sheet where I've sized the columns, rows & zoom perfectly to fit a header picture on a single screen page where you don't have to scroll to see any of the data. Also, cells were sized specifically to overlay on top of specific parts of the header image. I just opened the same...

Hi all, I want to group rows in blocks of 2 rows at a time. For example...row 1 & 2 would be a group. row 3 & 4 would be a group. so on and so forth. I want to use the 1 & 2 button to open and collapse the groups. I had it before but can't for the life of me remember how to do it again. I have...

Hi All, Need some code to do the following. For a range of rows from Row 10 to 50000 Hide any row where COL A has a value = 0 Many thanks....sorry for such a numpty question. James

Trying to copy rows from spreadsheet named "Items", where if Column E = Yes, then those columns will copy over to spreadsheet named "Print or Email This" & paste starting in row 13 column A. The code below is isn't working for me. Sub CopyYes() Dim c As Range Dim j As Integer Dim...

Hi, I have a number of workbooks, named by date they were created, and need a summary of how many rows each workbook has. Thanks Jon

I need some help. I get a few reports like this on a weekly basis the largest one only containing about 150 rows and 26 columns. What I would like to do is use a macro to add a few things to the bottom of each sheet. Each sheet is dynamic in its number of rows and columns. <tbody> 123465...

Dear MrExcel, I need to insert rows based on certain numbers and I need your kind help and assistant to help me out. I have 2 columns, A & B A is containing value (string) B is containing value (number) If the value in column B = 1 then no inserting rows But if the value in column B <> 1...

Needed a help on an excel scenario I have a column of say 3 rows containing numbers, Say A, B, C I need to generate a formula / code to give me sum of all possible number combinations.i.e. A + B A + C B + C A + B + C My real life scenario has more than 3 rows (actually about 15 rows)

Hi, I am making a Name List where people can put their name in a cell, and click on a macro-recorded button to automatically add their name to a new row in an existing list. However, I am trying to add VBA to set a limit to the number of rows that can be filled in this list. So, if I want the...

Hey, Currently this pulls the data in one row Ary = Application.Index(wb2.Sheets(4).Range("A8:U17").Value, Evaluate("row(1:10)"), Array(1, 3, 4, 7, 13, 14, 15, 16, 17, 18, 19, 20, 21)) Ws.Range("A" & L).Resize(10).Value = wb2.Sheets(4).Range("D3").Value Ws.Range("B" & L).Resize(10).Value =...

I have a table in columns C - N. There are over 14000 rows of data. I need to have data where, in column K, there is data that is identical in consecutive rows. If I could have it highlighted then great, if I could have it automatically filtered out then even better! If filtering out is possible...

Hi all, I am looking to copy duplicate rows from a large sheet of credit card charges. I want to copy any duplicate rows based on a string text in column "AL" on sheet "Trx List" to a sheet named "Duplicates". I'm really new to VBA so any help would be greatly appreciated! Thanks, K