beginner help

I have an exported file, basically an Excel text spreadsheet with column headers and around 2000 lines. It can change, so I don't have a fixed array size. I have stumbled through things where I believe I can build the array, but get lost on essentially how to call out and display specific parts...

Hi, I am looking for a formula that can count the number of fractions 80% or larger in a range(in which cells can have multiple fractions inside, separated by commas), with the exception of 5/7, which should be counted despite being smaller than 0.8. For example, if the selected range is like...

Hello everyone, I'm very new to Excel/VBA but I've been tasked with the automation of the manipulation of a report that we run several times per day. The manipulation is done, but now I need to figure out how to save my data to a specific and ever different spot on the master workbook. We...

Hi, I am a complete VBA beginner so I expect this a very easy question. In the below am trying to check if a file exists. In the below when I check the value of bExists using a Msgbox at the end of the function, the value is true and this is correct. However, if I at the end of the...

Hi All, I need to make several hundred excel files which all have the same layout with different information (I.D. Cards). I have resolved all time consuming issues except manually changing the picture for each person. My idea is to write a macro and assign to a button that does the same thing...

**Definitely a beginner. Please bear with me. First attempt at web scrapping.** I need the following URL to auto-login and retrieve a table from the website. I have pieced together VBA code from different websites to fill in the login information and hopefully pull a table but I am unable to...

Hi Team, Forgive me for some of my lack of knowledge of syntax and proper definitions on even the beginner details of VBA, but I have a certain scenario I need help with. Basically I have four seperate ranges on one sheet (Stacked on top of each other with one row between each). These ranges...

Hello friends, I'm trying to save an Excel file with VBA code to the location C:\Users\Work\Desktop\Google Drive. I am able to successfully do this with ActiveWorkbook.SaveAs ("C:\Users\Work\Desktop\Google Drive\" & varEventName & " " & varDate & " " & varReportType & ".xlsx") However when...

Hello, I have written/recorded a long VBA code to reformat data. I have two versions of this code. One version automatically saves the file to a specific folder and reformats the data while the other just reformats the data. Here's the code I used to save the workbook: ActiveWorkbook.SaveAs...

Hello everybody! I got some amazing help last time I posted, so I'll give it another go. I'm still very new to coding in excel and find myself stuck with a Run-time error yet again. This is the code I'm working with: Private Sub Worksheet_Change(ByVal Target As Range) Dim n As Long If Not...

Looking to calculate a weighted average if there is a rate in column B, and then to be able to filter on other columns and have the subtotal update with the correct weighted average rate. Below is a copy of the formula I have thus far, where column B lists the rates and column A lists the...

How can I loop through 3 cells that each contain data validation lists, in order to update my model? In order for the model I am working with to update, there are three cells (C3, C4, and C5 each containing a drop-down data validation list) that need to be cycled through in order for new source...

I have found a post that similar what I need to be done, but I do not know how to convert it to fit my purposes and data. I am not sure if I can link it here but ( How to combine values from multiple rows into a single row in Excel? - Super User ). What is different is that I am wanting to sum...

Ok, so. I have my range selected through Range("G1").Select Selection.End(xlDown).Select Range(ActiveCell, ActiveCell.Offset(0, 5)).Select because it has changing number of rows. I want to have those cells (G:L) autofilled but am having some difficulty finding the proper way to do it. If...

I have two sets of data. One offset from the other but directly below it. I want to do things to the second set but do not know how to reference it because they both change per iteration of the data. So example: My top set of data is A1:L11. There are 4 blank rows between them. And the...

So I have stumbled my way through creating a range that will change with the size of the data I am using, but I am wanting to cut that down some in order to do some formatting. Specifically I want "MyRange" (currently using A1:L17) to not include the top row (1) or the bottom row (17), or the...

Hi All, Long time lurker first time posting. I have workbook with the following specs and macros: WS named Master (here I paste my data base) this takes into account the information that is included in column L and copies specific information into the worksheet that is named after the...

I am brand new to anything to do with Excel programming via VBA. My issue sounds simple but I don't know how to fix it. It is for my job and I feel there is an easier way to do this. I have a workbook that has 177,000 records. The example below doesn't show all the columns on the original and...

Hey guys, I have been cracking my head last 2-3 days with the following coding, but just aren't able to understand the syntax. The code works well, but I am a beginner in this. Any help on the meaning of it would be great. Thanks! Code: Sheets("Payment Schedule").Range("A2:f" &...

Hello, I have a beginner's question about multiple regression, so a stats question really. I've only recently learned the basics of linear regression and I still have the following nagging doubt. I'd like to analyse some sales data for the purpose of forecasting future performance. My dependent...