beginner help

Hi! I am stuck and needs some help/feedback. I am working on a turnaround time frame calculator to include weekends. I worked through some other threads to see if I could do it and I am having a disconnect. I started with this, and added in the following formula...

I am trying to get the script/macro to move my selectee from onboarding table to completed table. 437&438-Onboarding table column y= "Move to Completed" is a drop down and is blank until "YES" is selected from the drop down. (that is the only option) Station Selectee Effective Date Position...

Hello! Thank you in advance for visiting my post. I understand there have been a couple posts here already that ask for help regarding VBA code and moving data from one sheet to another based on a drop-down value, I appreciate your help nonetheless. ---------- We are approaching territory...

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...