help !

I'm new to VBAs and I pieced together this code for a random question generator. It worked the first few times but now every other time I click the button it comes up with an error. When it doesn't come up with the error it populates my form with the same questions not random ones anymore. Can...

Good morning!! Can you please help!! I wrote this code but I keep geting error I want to assign this code to pacific sheet the sheet name is Devices names. Sub Final2() ' ' Final Macro ' ' Workbooks("Mobile devices report").Worksheets("Devices list").Range("A1:A10000").Replace...

Good morning!! Thank you so much for taking the time to help each other!! I receive a daily zip folder inside the zip folder another folder and inside the 2nd folder all the files I want all the files to go to documents. thank you!

I need a formula or macro I enter a “start date” say 1/5/2022 use count +28 in a different cell I get 2/2/2022 use count +14 and get 2/16/2022 then repeat in the pattern of +28 / +14 this is how I got my work schedule for the year ( I’m a sailor )…I need to pull days worked per pay period...

Good morning guys!! please assist if you can!! I want this code to unzip the latest folder in Dir and copy all the files inside that folder to a different folder and open the bigest file in the folder Sub Unzip1() Dim FSO As Object Dim oApp As Object Dim Fname As Variant Dim...

Hi, So I am having some trouble figuring out how to summarize the square feet of the fences being applied to concrete, grass. asphalt and soil. What I am looking to achieve is for excel to look for "*concrete*" in rows B4:AE6, and return the values in row 7 (the height). In this case that...

Hello, I have a list of product codes, descriptions and locations. I require a macro based on the highlighted list to create 4 columns with headers please. Product Code, Decription, Loc, Count, then the data, then a space and then the header again, with data etc etc. The data is grouped by...

Hello all ! I am fairly new to MACROS and VBA. Recently I wrote a Macro to segregate data of employees as per their job levels. Since it is for a fairly big organization the number of rows (employees) of the data is huge. I made a simple code for copying the title header of the data to new...

Hi All, I am learning how excel more and more as my job requires me to and try to use it in my personal life where possible. I have created a budgeting workbook and would like to be able to click a button that will extract all the data in the "master calculator (null)" sheet and place it into...

Is there a way I can convert the letter A to 13 and B to 15 number won’t be in order with the letter. need to be able to type a word and for it to spit out a very long number. For example if I was to type hello need a number 22 23 26 26 35. its for an old alarm panel I need to program and it...

Dear All experts , Please forgive me for my bad English as i am not native English guy. I am assigned to carry on some work from my company and i was given a excel sheet which was probably made by my previous colleague , since i am not very familiar with VBA for excel so i am looking for help...

Hi! I am currently trying to figure out a VBA code (I’m not super familiar, but can grasp concept with little experience I have): The coding is for a training tracking sheet. I have a date in one cell, that will get over-written each year with the new training date. the next cell over...

Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...

Hi guys, I could really appreciate some help tracking some golf matchplay results between me and 3 friends. Each month we play a team competition 2vs2, randomly picked teams, with the lowest score from the team being used. Whichever team has the lowest score wins the hole, if they're the same...

Hello, After I enter a date range (start date and end date) for a certain task, I want to be able to physically enter each day a value; say 0 for not done and it would show it in red color, and 1 for done and it would show it green color. Also when I put either values 1 or 0, I want the data...

Hello I am having an issue figuring out how to get my duty excel spreadsheet to do the below and am looking for either a formula or VBA based solution: Basically I have the below spreadsheet and if there is a value in the additional duty column (starting at I5) I would like the value to be...

Okay so on a pivot table if you double click a search result you get a new sheet showing the results. I am wondering if there is a method to replicate this from data returned by a sumifs formula?

Hi all - I have a sheet with multiple columns utilizing data validation drop-downs. I need the drop-downs to be searchable due to the large number of options in the drop-down lists (Country column for example). I understand there are limitations with data validation and this can be done with...

I am trying to come up with a formula to count how many robot batteries are needed. Below you will see the formula that I am using to input the type of robot battery for that type of robot and multiply the quantity of robots in that column by 4 to come out with how many I need (each robot takes...

Hi All, Every month I have this task of collecting data from about 200 reports, into a main central consolidation file. The Report is an Excel file stored on SharePoint. All the Data i need is on a hidden tab in one Range. Process:- 1. I go to the SharePoint site where the files are stored and...