I currently written the following formula, but always have issues when adding additional depending on selection.
D8 is the selection ( Validation ) on PERF EXP FORM Tab, Once you enter the selection... you then go to the Accounts per hour Worksheet
=IF('Perf Exp Form'!$D$8="Test1 14-18 station",IF(('10220DBHE'!B9=A6),IF('10220DBHE'!C9 > 11000,11000,'10220DBHE'!C9),"N/A"),"N/A")
Perf Exp Form
Perf Exp Form *ABCDEFGHIJKLMNOPQ4 *1. GENERAL INFORMATION****************5Customer***Date / Name(s)*6ApplicationSheet Size1UP/2UPOrientationSOG/EOGFold TypeFold Plate# CH***78 1/2 x 142 UPPortraitSOGLetter/ZHeavy1***8Machine / model**Enduro 4-6 station9ConfigurationCHANNEL 1CHANNEL 2CHANNEL 310590-4720-4910 Dual DeckNONENONE11Date / Name(s)*** Excel tables to the web >> Excel Jeanie HTML 4 ......
I want to be able to create a log of incoming orders and requests with a column containing initials of the person who will be responsible for handling the item entered. From this sheet, I want to populate other worksheets in the workbook with the data base on the initials placed in the first column. Each initial set would have its own dedicated sheet in the workbook.
Is it possible to create and IF "ST" in column A of main log THEN copy all data to designated fields on the ST worksheet?
I want to populate "selections" sheet with data from the previous sheet (it will be the date) depending on the value of a cell in column G. You will see I have already got the data from 27th April into my selections sheet but wondered if it can be done by a formula to save me copy and paste time?
I administer an excel spread sheet which over the years I have added bits of code to which now generates our weekly roster sheets and our daily duty sheets. Sheet 1 is the weekly roster and sheets 2 to 8 are the daily sheets. If an employee is on leave or sick for the coming week the value S or L is entered in to Column B on each daily sheet and when the roster is processed for printing it strikes through the names of the employees for each day that they are off. What I would like to do is then Highlight the name on sheet 1 the weekly roster sheet so at a glance we can see on the main week sheet any issues we may have for the next week. What it needs to do is if the cell in column B contains S or L on sheets 2 to 8 the name which is in column C on these sheets needs to be matched to the name in column D on sheet 1 and this cell highlighted.
"Sheet1" of Book1.xls contains the daily efforts of each members in the team. The detail changes automatically everyday like:
Date Name Task1 Task2 Total 1/1/08 Mark Design-2 Analysis-2 4 1/1/08 James Design-3 Analysis-2 5 1/1/08 Paul Implement-4 4
On the very next day the details will be automatically changed as:
Date Name Task1 Task2 Total 1/2/08 Mark Design-2 Analysis-4 6 1/2/08 James Design-3 Analysis-2 5 1/2/08 Paul Analysis--8 8
i.e. "Sheet1" will contain only the details of current date. I have managed to do it in "Sheet1"...
Here I need to add all the details automatically for each and every day in a separate worksheet ("Sheet2") from "Sheet1" of the same excel.
As soon as the date changed, then it will be reflected automatically in "Sheet2" in the next blank row for each member of the team... The details of "Sheet2" will be:
Date Name Task1 Task2 Total 1/1/08 Mark Design-2 Analysis-2 4 1/1/08 James Design-3 Analysis-2 5 1/1/08 Paul Implement-4 4 1/2/08 Mark Design-2 Analysis-4 6 1/2/08 James Design-3 Analysis-2 5 1/2/08 Paul Analysis--8 8
I am tracking business hours of various business locations. I would like to be able to enter the businesses operating hours on the "overview sheet" and, based on those hours, have a table generated on another sheet that "autofills" based on the date entered on the "overview sheet". For example:
I would enter the operating hours of the business on the "overview sheet" and it would look something like this:
Day Open Close
[Code]....
I want a table for each day created. I would then manually enter the data for the "Ranking" column. The issue is that I have numerous location I want to do this for and all with varying hours of operation. It is very tedious to manually create the tables.
I am trying to create a filterable To-Do List. My goal is to enter each item with a userform, which I have created and pops up upon clicking the "Insert" textbox. making the following macros happen:
1) I would like to insert the new item in a row at top of existing info, below the headers, with the populated information from the userform when you click the "Add" Commandbutton on the Userform.
2) I want to make sure any filtering is reset whenever a new item is entered so the list reverts to original appearance.
I am wanting to transfer data from one sheet to another depending on cell input
Example:
If I enter "2" in sheet1 cell B1, then I want a macro to take A1 to sheet2 but place it in A1 & A2. Then say I enter "1" in sheet1 cell B2 goto sheet2 and put A2 into A3 and so on.
Depending on the number entered on sheet1 column B, the Macro duplicates the info from Column A in that row into column A on sheet2. ??
Sub Auto_Open() Sheets("Data").Select Range("A2:E32").Select Selection.Copy Sheets("May").Select ActiveWindow.SmallScroll Down:=-9 Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("A1").Select Sheets("Data").Select Range("A1").Select ActiveSheet.Paste Range("A1").Select Sheets("Sheet1").Select Range("A2:E32").Select Selection.ClearContents Range("A1").Select End Sub
1) How do I set this up so that if the cell Z1 reads 1, it will paste the data to the "January" Sheet, if Z1 reads 2, it will paste to "February" Sheet, if Z1 is 3 it will paste to "March"......
I am working to make an automatic result card in which excel automatically gets data of every student which is present in sheet within the workbook by simply writing roll number of the student in a cell. and i have done it easily by Vlookup and index functions but the only problem i am facing is, that i want to show the picture of each student by roll no. pictures are in one folder on my hard drive, now i want that as the roll number of the student is written the result excel should display the picture (from the folder, each picture named by roll)of the student. for example i write 1234 in roll no cell and want to get and show the picture no 1234 in another cell. (from the folder)
I have a file consisting of two columns, called, "bom ref" and "material" I need to show the data as indicated in the file, headed required format required.
In effect where I have a 0, that is the material I need to show for every row with a bom ref. of 1,2 or 3, down as far as the next 0 but not including the 0, when I reach the next 0, the material is a new letter, and that letter needs to repeat down as far as the next 0, but not including the 0 and so on.
i have 20 different materials which have codes assigned to them
wh = white ivory = ivory db = duck egg blue
etc etc
when i create an order some of the codes will be called up i want to be able to put them codes plus the description into the worksheet Ideally into the header. if not call a1
I have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.
I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.
I can imagine that this is hard to picture so i have attached the file as well.
I have several blocks of data that I have defined under several names to make data processing much easier when writting formulas. They problem that I have right now is that depending on the value of one cell, I need to call up a given defined name block of data to be used on the calculations. These blocks are labeled as DATA400, DATA500, ... user will input information that will allow me to determined what block needs to be used, user will input data like 400, 500, ..., but to be able to call a block of data I need to reference the complete label DATA400. I have tried to concatenate "DATA" to whatever value is input by the user and use the concatenated value to call the specific blocks of information but it doesnt work.
I have 2 worksheets, 1 with a table sorted like this (in a row):
component | start date | end date | assigned to
Second worksheet with a table like a calendar with dates and people (dates in the columns and people in the rows), every component is assigned to each person by dates.
I want the assignment from worksheet 1 to worksheet 2 to be automatically. i will set the start and end date next to the component in the first table and assign it to a person/s and it will be automatically get filled in the second worksheet (the calendar) under the person/s and under the same dates as set in the first worksheet.
I need a formula that displays the word "Day" or "Days" depending on cell entry i know the formlula =IF((B12)>0,"Day","") to show the word day but i want it to show "day" if a 1 is entered or "days" if any number over 1 is entered.
This may not be the best way to do this, but I don't know Macros or Pivot Tables.
I am looking for a way with formulas to do the following: Within a workbook the 1st sheet is the data entry. In another sheet that will total data from the data sheet is where I want to be able to total columns of data, depending on what is entered in one specific column:
Example: Data Sheet, E2:E2999 is a unit number selcted by pull down tab entry. G2:G2999 in the same sheet is where the data is.
Q: What formula would allow to total the data on the Total Sheet depending on what unit number is selected in column E on the Data Sheet and the data amount in column D from Data Sheet?
I am an undergraduate biology major working on a geometric morphometrics project. It is focusing on wing asymmetry, so I have data for the left and the right wings for a sample population of 30 individuals. The data from the software is exported as a spreadsheet with two rows of data for each individual, since each wing was calculated separately, and my mentor has asked me to average the data for subsequent analyses in another program.
I'd like to do this easily with an Excel formula, but when I try to do the averages I'm having a little trouble getting the formula to carry on correctly. I need it to average, say, E2:E3 then the next cell average E4:E5, but instead the only thing I can get it to do is average E2:E3 then the next cell do E3:E4. Which obviously doesn't work for me, since E3:E4 is data from two different individuals.
Is there a way I can do this for my data? One of my spreadsheets is a 60x32 matrix of landmark coordinates, so I'd really rather not try to do all the cells individually.
I have drop drown menus that allow you to select 1 of 3 choices and based on those a second set which lists the options for the first three (subset). Now depending on the second value I need to pull a set of x y coordinates that can be of varying length. '
Example
Drop down menu 1 1560, 1669, 1554. Drop down menu 2 1560-1,2,3,4 1669-a,b,c,d. This has been done now lets say I select 1560-1. I need the following to be pulled from a list, the data is a block.
I have a sheet with a country in it in A1 (validation list).
Depending on the country in A1 a country specific IF command has to be executed on a column1 with first cel = A3. This IF command also relies on the values in column 2 and 3 on the same row. (B3 and C3 are in the IF cmd)
I taught to do it like this : =IF($A$1="Spain";$A$5;0) with A5 being the country specific IF command which should be executed when spain is selected. however when I do this, this only works for the first cell ( I cannot drag this formule down, since it will always give the value calculated in column 2 and 3 on row1.
I'm not sure if the best way to 'select' the country specific IF cmd is with another IF command..
Basically, what I'm dealing with is an inventory system. When a cell value reaches below a certain quantity, we have a cell light up with the word "YES" (under the "re-order" column). What I'd like to do is have a macro that checks to see if that cell is populated with "YES" and if it is, to run another macro (which I already have written) that sends out an email notifying us of the need to re-order.
How it would work: The person pulling out the inventory would fill out this form and click "Submit"
submitbutton.jpg
I would then have a "call" code tied to the "Submit" button that when clicked, would run the macro to check cell population and send out the email. The email code is already written and works flawlessly on it's own. I just cant seem to figure out how to write a macro that checks for cell value and then runs it (or not) based on that.
Ok, so this is my first attempt at an excel macro. I'm trying to develop a macro that will assist me in auto-populating a column in a new worksheet based on another worksheet. Recently I ran a new report at work that is 4000 lines long that I really do not want to have to edit by hand, since I already had to do it with the older one.
I can't post my data but i'll try to explain it the best I can, but basically it's set up as a part number, next column is the steps in completing that part, and then a workcenter number. I'm trying to populate that workcenter column in the new worksheet. I've put this macro together with the best of my ability along with excel help and the internet but I just can't seem to get it to work.
Excel has a QUARTILE function to divide a population into quartiles. I'm trying to do something similar but divide a population into deciles (i.e., every 10%). Is there any easy way to divide a large population into deciles and to assign a decile to each value in the population (i.e., top 10%, 11-20%, 21-30%, . . . bottom 10%)?
