I created a workbook with multiple time cards (1 for each employee on different sheets). I need a vba code to copy and paste from each sheet into a compiled master sheet ("Data") The first line of data in each timecard sheet is in B8:H8. Some timecards could have a variable amount of lines from...
I have a working code to ask user for:
- a product
- what column to put it in
- quantity of product
All this happens based on customers region and checkboxes. (Checked regions will get data from user input)
Code is working fine in columns from C all the way to Z. But when I try to change the...
I need help regarding attached excel file:
1. If I select "At Par" from the drop down menu the % cell should only accept zero as a value.
2. If I select "Above or Below" from the drop down menu the % cell should accept only positive values greater than zero.
Hi All,
I really hope some genius can help me.
Excel in Office 365.
I have a spreadsheet that contains an array of data (column A-Q and row 2-10,000)
The data that I have is generated from 34 sheets within the spreadsheet (I have converted each sheet into a table) and have been collated all...
Hi, I'm creating an Incident Management form that has two buttons. One for injuries and the other for near misses. when the injury button is clicked, a message pops up instructing the employee on next steps, once the OK button is clicked on the message box, the email pops up where the employee...
Hi guys,
very new to excel!
I was wondering if there is a formula you can use to highlight if a specific word or number is repeated over a certain amount of times e.g. I want to highlight the cells that contain the number 19 only if it has appeared in the whole spreadsheet 3 times
basically...
Hi All
I'm trying to return the next 05 April from any given date, with the cell A11 holding the date. I was using this:
=IF(MONTH(A11+1)=4,A11+1,DATE(YEAR(A11)+1,4,5))
Which works fine unless the date I'm using is a month less than 4 (eg jan,feb,march,April) as it will then return to me the 5...
I am using =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=1)) to count the incidents that occur on a Sunday and =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=2)) for Monday and so on. They are working great, except for Saturday =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=7)). I am getting a value that is 9000+ higher than...
I have a formula that works great when the spreadsheet is empty, but when I start adding any data it presents an error.
Is there a way to add iferror to keep the cell blank until the cell has pertinent data?
O2#N/AO2O2=IF(ISBLANK(A19),"",VLOOKUP("tow",A$19:B$38,2,0))
I am trying to highlight column B based off of values in column A.
If A has the word parts in it, then I want B to change. I Googled it and seen several examples, I just can't find a way that works for me...
I have an if formula that has a variable. I'd like to search for a keyword (diesel) and if it is found, return a string. I thought about IF(F23="*diesel",S$33 but that didn't work.
Any ideas?
The first 4 parts work, but none of the rest. Any ideas why?
=IF(ISBLANK(A19),"",IF(A19="tow","Towing",IF(A19="etow","Emergency roadside towing",IF(A19="itow","In house towing",IF(A19="inspect","Inspect to determine necessary repairs",IF(A19=”dot”,"DOT re-inspection fee",IF(A19=”scene”,"Clean...
If I add a new column A, that changes all of my other formulas. Is there a way to add a new column (every 2 days) and have it add the new column in the formula?
Example. I have in M2 a formula: =COUNTIF(A$2:C$30,L2)
But, when I add a new column A, the new formula will be =COUNTIF(B$2:D$30,M2)...
First Name
Last name
Suffix
Complete name
Last, First
Phone
DOB
Hire
Term
SSN
Tenure
Phone
SSN
Age
john
doe
jr
John Doe Jr
Doe, John
8158675309
5/21/73
11/28/2017
123-45-6789
2 years, 11 months, 5 days
(815) 867 - 5309
6789
47
If I enter a date in the term column (j2) is there a way to...
Every couple of days I add data to column A. After I do, I insert another column A. I would like to see, if at any time, i have duplicate data in 3 consecutive columns.
Hello. I would like to count my data in column F, but only each unique entry.
If I have multiple examples of a particular number, I need to exclude those.
Thanks in advance
I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for.
When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet...
The formula works well until I remove a driver.
The formula I use:
='[N&I...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.