help !

Hi Would like to calculate past 90days past. Employees hourly bonus start after 90days worked. Thanks. I did post this question to ExcelGURU forum as well. Currently I am working in May month So I have to go back Feb month data to verify hrs.

Hi! Do you happen to know how to take all data points from every single row and column and copy and paste it into a single line (one long column) so I can export all the emails? I have two images I upload (I did it manually but have 6,000 cells with email addresses and I need them in a straight...

Hi, I am looking for some help. At work i have a report containing product, quantity and dates. I would like to set up a formula to combine all qty's by weekly in a report listing all products. (See example of delivery report "attachment capture 1") I usually use Vlookup to extract total...

So I'm trying to do a pivot table that changes the color of the data based on wether the value reaches a certain target, green if above, red if below. I the procceed to use a method similar to the one present in the following link: Create Dynamic Target Line in Excel Bar Chart But instead I make...

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