# required

1. ### Sum of each column from individuals costs times amount of items

Hello, I'm working on a game and I want to make an overview of required materials for ingame items. Column B contains items and column C the required amount of those items. Columns D through P (and proably beyond) contain the required materials for that item. I'm looking for a way to get the...
2. ### If information is missing from the sheet, I'd like a message box to appear

Dropbox link; https://www.dropbox.com/s/vi2zpdo86e...T%29.xlsm?dl=0 When the operator presses "Submit", I'd like Excel to verify completion of the form. If required information is missing, I'd like a message box to appear, alerting the operator. A simple message box stating that "There is...
3. ### Dynamically create a checklist based on a matrix

Hey folks. I'm looking to create a dynamic checklist based on the role ("user X" in the table below). The end result is to print off a sheet of paper for each user and verify each required step was complete, not all steps are required. I can get the data using INDEX (thanks Jonmo1 !). In the...
4. ### Need a formula

Hi Excel Experts, I have list of 50,000 people, they have different amount of money in their account. There is a required amount of money which always vary. I want a formula by which I will enter only required amount and can find the person who has equal or more amount than required amount...
5. ### Dashboard : Select Projects with Respect to Resources Available for List of Projects

Hi , I am planning to create a dashboard which will help executives look at how many projects we can start with respect to resources available / freed up. I have a list of projects with Resources required and i also have the number of resources required for each projects. Can someone please...
6. ### Need Solution

Here is an example source table: <colgroup><col><col><col><col span="5"></colgroup><tbody> Customer 01/12/15 02/12/15 03/12/15 04/12/15 05/12/15 06/12/15 07/12/15 Tuesday Wednesday Thursday Friday Saturday Sunday Monday A 2.00 6.00 3.00 1.00 6.00 7.00 B 6.00 4.00 10.00...
7. ### Counting number of adjacent cells

Hia, I am looking for a formula that will count the number of adjacent cells that meet a specific condition starting from Column A & looking for the word Required. In the example below ...... Row 1 should return 2 Row 2 should return 1 Row 3 should return 2 Row 4 should return 3 Row 5 should...
8. ### Splitting a number for normal and overtime breakdown

Hi, I am sure to have done this before but racking my brain has led me to actually take the plunge into the forum to get help. In creating a spreadsheet to simplify some tasks, I have managed to create it such that it will return the total number of hours required to complete a work package...
9. ### Confirming certain fields have entries before a form can be e-mailed

I have an excel form that has certain required fields (more than one) which must have data entered into them. I have created a button that emails the form to me using a VBA statement. Is there a way to prevent the form from being submitted if any of the required cells are left blank? Any...
10. ### tracking employee required training, who HAS NOT completed

Good morning, I am using excel 2010 and I have 2 sheets that I work with regularly. One is a list of staff, both current and past. This sheet is set up to filter out 'current' and other employees based on their employment status. The other is a sheet that I use to track all of the training...
11. ### Make it mandatory to fill a cell- before tabbing to next cell

I have a worksheet that is protected and users can only tab through and select unlocked cells. I am aware I can make cells mandatory on save/close, etc. using a macro, but is there a way I can prompt the end user before they tab to the next cell? I am envisioning a data validation box...
12. ### Force user to give additional info

Hi, this is what I need : In a list (of variable length), a user can enter some info in cell A1. However, if he does so, it should be compulsory that he enters additional info in cells B1 and C1. What I think of, is that the system reacts as soon as user has entered something in A1 and then...
13. ### Help Designing VBA Macro for Call Center Scheduling

Hello, I need some help on figuring out the design (ie. modules, controls, structure) for a VBA program I want to make to create the required schedules at a Call Center. I haven't really got into the coding part yet, I'm struggling a little bit with the designing of the program and how I should...
14. ### Require Macro order

I'm working on a workbook that has 2 different buttons each with a separate macro assigned to them. PROBLEM: The 2 buttons are supposed to be in series. Meaning in order for the macros to work properly the use has to click the first button then the second one. QUESTION: Is there a way I...

I am trying to force a user response to a cell, when the user leaves the cell blank and tries to navigate to another sheet, the message box would remind them of required entry and return to the sheet and cell. I have set up on deactivate sheet to run message box when cells are false which...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...