1. How many sets of a number can I make?

Hi! I have a huge set of data that includes hours employees have worked during a pay period. I need to know how many employees have worked 40 hours during the pay period. I can combine employees to get to one 40 hour employee. For example, if I have someone who has worked 40 hours they count as...
2. Add every file inside a folder

Hello, I'm trying to do a macro that let's the user select a folder with more folders inside, this folders could have images .jpg or .png. What I want is that the macro adds only the image files in the excel, any image file. What it does right now is that adds the images but only if they have...
3. Need to add multiplication to an array formula

Hello forum friends, I am trying to add a multiplier to an existing array formula but it is giving me, not an error, but the wrong result. The formula as it exists is returning a result of 24. I want to multiply this result by 0.621371 but when I add *0.621371 to the end of the formula and do...
4. Add text in red with userForm

Hi folks, For a worksheet I'm making a comment form. What it does is simply add some text to a cell the user selects. What I've been unable to figure out is how I make only the added text in red, while the rest stays the same (black). Right now it add's the text from a Textbox to a cell. It...
5. Lookup query

Hi. In Sheet0 I have columns A to O populated with travel data. E contains email address I contains departure date L contains country B has the formula =IF(COUNTIFS(TA!C:C,E2,TA!E:E,"*"&L2&"*",TA!D:D,"<="&I2+7,TA!D:D,">="&I2-7)>0,"yes","no") which looks to see if there is a corresponding value...
6. how to simplify nested if

this is my formula for IF...
7. Add asterisk to string with number format

Hello, Is it possible to add the asterisk sign to string of text with the custom number format ? i dont want to concatenate the string with the asterisk just format so in the formula bar the asterisk will not exist.
8. Limit Macro from Filling Past Row

Hi, I am making a Name List where people can put their name in a cell, and click on a macro-recorded button to automatically add their name to a new row in an existing list. However, I am trying to add VBA to set a limit to the number of rows that can be filled in this list. So, if I want the...
9. Calculation issues.

I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...
10. Adding a Minus Sign with a macros

I need to add a minus sign in front of a number in cell G8 and one in H8. Thank you for your time
11. Getting cells to reflect/mirror changes made in another cell.

Cells: B2, C2, and D2 are the cells. Values: 19, 7, and 12. If I add 1 to 19 and make it 20. I need 12 to change to 13. If I add 1 to 7 and make it 8. I need 12 to become 11. Possible? How?
12. need to add cell to this VBA code

Need to add Cells D7, F7, H7, J7, L7, N7, P7, R7 can't get it to work. Private Sub Worksheet Calculate() If Target.Cells.Count <> 1 Then Exit Sub If Target.Address <> "\$B\$7" Then Exit Sub If (Target.Value >= 0) And (Target.Value < 0) Then Exit Sub Pictures("Picture 7").Visible =...
13. Add #, ignore text, in specific cells (not columns) plus percentages

I have 11 cells to add that contain text and numbers. I only want to add the numbers, and if possible insert the sum into a cell that also contains text. My other problem is creating a percentage using those 11 cells divided by 11 corresponding cells with only numbers to get the percentage in...
14. Case Statement and For next loop

Hello, My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...
15. Macro Button for adding a column in a specific location

Hi, I am very much a beginner with excel, but wanting to add a button on my spreadsheet to add a column after a specific column. The code I have put together is as follows: Sub AddColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter Column Letter where you want to add a...
16. Add formula to existing formula

Totally new to this so I have this formula in the formula bar for a cell =+ALLDATA!BN6. I want to put an IF statement saying that if T6/220 >= 7.5 then BN6 else BM6. Also what is the exclamation point for
17. Split value in half and add

<tbody> A 500 B 750 C 750 </tbody> How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done? Thanks in advance GT
18. Formula to find new product and add to list

I would like a formula to grab new products and add them to a list. For example, I have two tabs. In tab A, I keep track of how much we sell/buy by product (so we bought 10 apples and 15 oranges and sold 10 oranges) and in tab B is a sumif formula to add up the sum so we know how much of each...
19. Averaging numbers

I have a row of 10 numbers and each week i add numbers. What i want to do is have a formula that will average the last 4 numbers in that row of numbers when i add numbers to the row of numbers. So what im saying is i want to be able to always adverage the last 4 number that have been entered...
20. Pricing from homedepot.com

I am an electrical contractor that uses excel to quote jobs. I am getting sick of looking on homedepot.com to check prices. I am looking for a way to have look up the price for me. I tried data from web and putting the website in there but I always get errors on the page and I cant add the...