Hi, I am VBA Excel coder since yesterday and I am stuck. Hopefully you can help me.
I am managing sports team and want to follow players training progress.
I have made google forms page and linked it's workbook to my computers excel file to update it automatically via Data - New Query - From...
I've got a data array, which my userform combibox/dropdown menu references.
I have 100 available "slots" for data input in the array, but I don't use all of them. The initialize code (below) works well for the combibox to populate it. However, being as I only use about 20 of...
I have the following code:
Dim wbCurrent As Workbook
Dim wsCHINO As Worksheet
Dim wsSTOCKTON As Worksheet
Dim wsFLM As Worksheet
Dim wsDGV As Worksheet
Dim wsAURORA As Worksheet
Dim nLastRow, i As Integer
Set wbCurrent = ActiveWorkbook
Set wsCHINO =...
I am using the code below to search cells for certain criteria and then keeping certain
rows and deleting certain rows.
This code currently takes around 1 hour to process 95,000 records. I need help in
determining if there is a better way.
'Delete Level 1's and certain Level 2's
Hi all! I'm pretty sure this may have been answered before, but I'm self-taught in excel and know about 100% of nothing as far as coding goes, so I need to try an get this explained super simply if possible. The post I think I found before talked a lot about coding and something like VBA and I...
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...
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...
Please I need help in this case; thank you in advance!
I insert data and have the data in Table1 in Sheet1:
=COUNTA(A2;A1000) (result: 2)
A2 Car 1
A3 Car 2
Every time I insert new data, new data might add/cut rows to/from this table...
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...
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?
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.
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...
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...
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.
Dim c As Range
Dim j As Integer