Show Different Data Based On Value Of Cell
Call centre data for financial years located in separate workbooks (1 for each year)
Here's what I want to create.
One main file to consolidate/view all data
I've tried to make this as user friendly as possible by having a validated list, whereby the user can select the year they want to view, and hey presto, the data changes to reflect the year displayed in the validated cell.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Show Data In Cell Only If Other Cells Show Data
I have 2 different formulas that I need changed in a similar way. The first formula is for cell AV11: =SUM(BI11,BP11,BW11,CD11,CK11,CR11,CY11,DF11,DM11,DT11,EA11)+10 Every cell starts off blank. What I need is for cell AV11 to always start off blank until data is entered into one of the other cells. The problem is that since the sum always needs to be +10 only when data is entered in the other cells, I don't know how to keep 10 from showing in cell AV11 when no data is typed in the other cells. The other formula is for cell CO39: =(CU8)+3 I pretty much need the same thing. If no data is entered in cell CU8, then I do not want cell CO39 to show the 3.
View Replies!
View Related
Show Users Only Certain Data Based On Their Name
I have a large workbook that contains markbook info of all my classes that I teach. I don't want them to see all my workbook as it would be too confusing. I would like to hide all the data and have a simple INPUT box on a separate page that would ask for their name. The name would then be used to find the row number, add this to a specific column number (always the same) which hold their marks and then return the mark in a Message box.
View Replies!
View Related
If A Cell Has Data Show It If Not Show 0
I have a column of data held in column B. I am required to show the following. If there is data in the cell then it is to be left. If there is no data in the cell then I would like to show the value 0. I have tried using a circular reference, using the formula =IF(ISBLANK(B1),0,B1) and other similar formulas but they dont work as the formula overwrites the data in it. do I need a macro?, or conditional formatting?
View Replies!
View Related
Show Data From Another Worksheet Based On Matching Properties
I'm building a spreadsheet for a sporting franchise using a pull-down validation menu. Once the opposing team name is selected from the drop down menu, I would like it to display the opposing teams players and their statistics. On the database worksheet, I have a web query pulling names and statistics from the web. Each player name has his team name in his corresponding row. What function can I use that will search for that team name and report it back to the display sheet? Once I have the player name there, I think I can figure the statistic portion... But I can't seem to figure out how to pull all of the players with the matching team name into my display sheet. Example: A1 on worksheet "A" contains a pull down menu with team names "Lightning", "Storm", "Magic", and "Thunder". A16-A20 on worksheet "B" contains players from team "Lightning" A21-A25 on worksheet "B" contains players from team "Storm" A26-A30 on worksheet "B" contains players from team "Magic" A31-A35 on worksheet "B" contains players from team "Thunder" B16-B20 on worksheet "B" contains team name "Lightning" B21-B25 on worksheet "B" contains team name "Storm" B26-B30 on worksheet "B" contains team name "Magic" B31-B35 on worksheet "B" contains team name "Thunder" If I pull down "Lightning" on A1 (worksheet "A"), I want the following to display:..........................
View Replies!
View Related
Hide/Show Pivot Table Data Based On Criteria
I want to write a VBA code, so I can apply dates criterias to my pivot table. Say, I have 1-Dec-2007 in "C2" and 10-Dec-2007 in "C3". Now I want my pivot table to show me the dates between those two dates and the data that goes along with it. I have written this code, but it keep debugging: Sub FilterDates() Application. ScreenUpdating = False Sheets("PnL").Select Sheets("PnL").PivotTables("PivotTable3").PivotFields("Date") _ .PivotItems("01/01/1950").Visible = True 'to always have 1 populated
View Replies!
View Related
Show Sheets Based On Cell Value
I have 15 sheets - Resident 1, Resident 2 etc If cell A1 on Summary tab contains 10, I want sheets Resident 1 to Resident 10 visible, everything over Resident 10 to be invisible If cell A1 on Summary tab contains 5, I want sheets Resident 1 to Resident 5 visible, everything over Resident 5 to be invisible
View Replies!
View Related
Show Image Based On Cell Value
Question: I would like to have two pictures (one in cell B2, the other in cells D1-C10 to I10) display based on a data validation list that I have in A1. So, for example, if you click U.S.A., two pictures for U.S.A. show up; if you scroll down to Canada, two pictures show up. If you're interested, I have included the history of what I have tried in the past. History of what I have tried: I used this code before [url] , but that makes all pictures but 1 invisible and I need two. So then I used this one, Sub HelloWorld() 'Message box to say hello MsgBox " Sub GetPicture() Dim oPic As Picture, imgFlag As Range, imgMap As Range ' Loop Flag and Map images 'imgFlag = Worksheets("Image").Range("B1") 'imgMap = Worksheets("Image").Range("D1") For Each oPic In Worksheets("Summary").Pictures If (oPic.Name = Worksheets("Image").Range("B1").Text) Then oPic.Visible = True oPic.Top = Worksheets("Image").Range("B1").Top oPic.Left = Worksheets("Image").Range("B1").Left ElseIf (oPic.Name = Worksheets("Image").Range("D1").Text) Then oPic.Visible = True oPic.Top = Worksheets("Image").Range("D1").Top oPic.Left = Worksheets("Image").Range("D1").Left Else oPic.Visible = False End If Next oPic End Sub"
View Replies!
View Related
Show Picture Based On Cell
I have folder with 5 photos on c (c:Pictures). Photos are named a, b, c, d, and e. In Excel workbook sheet1 (c:Photos.xls), how to display the photos in cell range (B1:F10) in response to change in cell A1 (i.e., when A1 cell value is “a”, the photo “a” is displayed in the range B1:F10, and so on when the A1 value changes)
View Replies!
View Related
Hide/Show Pivot Table Data Based On Date Criteria
I have looked at the below Hide/Show Pivot Table Field Items help web pages: Hide/Show Pivot Table Field Items Hide Pivot Table Fields Pivot Items by Criteria I am trying to use the above, but with dates in the following format in each cell: YYYYMM 200612 200701 200702 200703 200704 200705 200706 etc, etc The below code is working for >200702 and removes all years/months prior to this entered value. Unfortunately the code does not work when a user enters <200706, instead the code goes through to the “NonValidCriteria” prompt. Sub HideByCriteriaYYYYMM() 'Declare variables 'SEE: [url] 'SEE: [url] Dim pt As PivotTable, pi As PivotItem Dim lMonth As Long Dim strCri As String, strCri1 As String, strCri2 As String Dim bHide As Boolean Dim xlCalc As XlCalculation
View Replies!
View Related
Hide Or Show An Image Based On A Cell Value
I have a spreadsheet with two bitmap images inserted into it. In cell E2, I will enter a number, either a 1 or a 2. if I enter a 1, I want only the first image to be visible. If I enter a 2, I only want the second image to be visible. Is there a way to accomplish this (hopefully without the need for macros)? I've attached a spreadsheet as an example of what I'm trying to do. Also, note that I'd like the images to be stacked on top of each other so that they show up in the same place regardless of wether there's a 1 or a 2 in cell E5
View Replies!
View Related
Show Numbers Based On Percentage In Cell
I have a rather large report full of data, 10+ columns contain a RANKING column, and these ranks, 1-10, are assigned by a % bracket: 1-20% = 1 21-40% = 2 41-60% = 3 61-80% = 4 81-100% = 5 101-120% = 6 121-140% = 7 141-160% = 8 161-180% = 9 181-200% = 10 There are several hundred rows in each column that all need individual ranks. My first thought is to program a if then else statement for 1 to 10 with a % limit range, but this isnt feasable as i would have to program a separate if statement for each of the many hundred rows, or do one heck of a fancy loop that i just cant contemplate (as the rows are split and sepperated... no solid uniform place for the data to be plugged.) What is the best way to go about this? I'm at a total loss of ideas with my knowledge of excel.
View Replies!
View Related
Automatically Hide / Show Rows Based On Cell Value
I wrote a small code to hide some columns if a certain cell is equal to a certain string. The cell is actually a drop down list and when they select a certain one, I want it to hide 2 columns. So I wrote the code with sub name Action, but I want it to be running all the time. I tried to achieve this by writing the following code however it gave me error 438 for my 2nd line. Sub Auto_Open() Range("A1").OnEntry = "Action" End Sub Auto Merged Post Until 24 Hrs Passes;Oh, by the way error 438 states: Object doesn't support this property or method
View Replies!
View Related
Hide & Show Rows Based On Cell Value
I have two sheets say: Sheet1 Sheet2 Sheet1 has a few comboboxes saying (YES / NO) conditions Which are assigned to particular cells (for Ex: say Combobox1 value assignes to Sheet1!B5 ) If Sheet!B5 = YES some rows in Sheet2 Say ( Row12 ,Row 15,Row 16) has to be hide. I will add a command button to sheet1 and call macro if i click command button checking the conditions in sheet1 combo boxes..rows in sheets2 has to hide..
View Replies!
View Related
Formula To Show The Value Of One Cell Based On The Value Of Another To Automate Some Internal Processes
I'm trying to get a formula to show me the value of one cell based on the value of another to automate some internal processes. Cell J3 returns today's date, then J4 says what week number that is. J5 concatenates the two to make the look up. Column A is named range "PN", and columns C onwards are named ranges to match the column heading. What I'm wanting is for the result in test cell 2 (J8), is to return the stock requirements for the current week, based on the result of cell J5. I can do this by using nested IF statements, but that would be 8 cells to calculate, then another one to find the cell that has a value. If there a way to get Excel to recognize the value in J5 as a range name, so it just needs the one formula?
View Replies!
View Related
Formula To Show A Date Range Based On The Amount Shown In Another Cell
Attached is a excel file that has a working formula for tracking cashier variances. I edited out names etc. I added a new cell called Track Back on the employee search sheet. What I want to do is only show variances for the amount of days back selected in the Track Back cell. For example if I select the last 30 days, only the last 30 days would show up below in the sheet. I am not sure if this is even possible based on the forumla that is already on the sheet. I couldn't figure out a way of doing it. But there are a lot of people on here much better with excel than me
View Replies!
View Related
Hide/Show Sheets Based On Cell Values & Validate Entry
excal VBA programming.I have attached the file name "help" for your easy explanation purpose. 1. Is it possible to hide sheet nos. 1,2,3,4 & unhide the sheet as wished by me by puting the value (1or 2 or 3 or 4) in B3 cell. 2.There are per day production rate in E18 to E22 cell. Now whenever I will give value in H18 or H19 or H20 or H21 or H22, it will check whether the value is same with the respective E 18 or E19 or E20 or E21 or E22 cell. If both the values are not equal then give a message box "WARNING!!! YOUR VALUE IS NOT SAME". Can it be possible by creating VBA programming.
View Replies!
View Related
IF A Cell Is Not Having Data Show It As Blank
there is data going to excel from database. The data is something like jan to dec sales and in a arbitrary fashion. now if there wont be data availble for say month of july then nothing will be there. Now i need to nicely formulate data from jan feb ..Dec and in same order in another cells. Now for empty cells data after formualting it is coming as #N/A. and by this i am getting a same thing in the application where this excel sheet is being used. So for eliminating it i need to use 'if' such that if it is undefined or NULL then blank should be there in the formulated cell.
View Replies!
View Related
If No Data, Then Show Empty Cell
I'm using Excel 2003 and have a main workbook which stores the quotes, invoice, worksheet and contact details. In order to email only the invoice to a customer I have created another workbook which replicates whatever is shown in the open invoice tab of the main workbook. A macro from the main workbook then opens outlook. I attach a sample of both for information. My problem is this - You will note that on the email invoice that any entries where there is no cost in the main workbook, that it shows "£ -". how to get it to show an empty cell if no value in the main workbook?
View Replies!
View Related
If No Data, Then Show Empty Cell Using Conditions
I'm using Excel 2002 and am having trouble with what I thought was a simple conditional command. On part of the spreadsheet I have 3 columns: Hours (D5), Cost Per Hour (E5) and Total Cost (F5). Here's what I'm trying to do..... If there is no value in the Hours then the Total Cost should show an empty cell and conversly if there is a value in Hours then calculate Hours*Cost Per Hour in the Total Cost cell. My condition for cell F5 is as follows: =IF(D5="","",SUM(D5*E5)). Whilst it works if there is a value in D5, when empty F5 shows #VALUE!
View Replies!
View Related
Show A Certain Cell Depending On Data From A Drop Down Menu.
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.
View Replies!
View Related
Efficient Entry Of Data & Automatically Have Their Price Show In Adjacent Cell
I own a Hair Salon which collates its daily takings using a spreadsheet. A section of this takings sheet asks staff to enter which Products have been sold and what they where sold for (RRP), so that once all products have been entered, totals at the end of the day allowing the end -of-day "till-up" process to reconcile purchases and services rendered aginst cash and cheques received. Unfortunately there is over 600 products to choose from and this evergroes as new products are introduced by manufacturers. Names are long and often very similar, and product price manual listings are slow to reference, therefore the customer has to wait while the staff find the right product and select the right price. All of this is subject to human error. What i would like is simply to enter part of the product name into a Cell and the right product to be visibly selectable and the price automatically added to an adjacent cell.
View Replies!
View Related
Lookup Data In Row & Cell Based On Data In Row And Cell
I am looking for a way to do what i would call a dual vlookup. i have some data in a number of sheets and need to do some consolidation into a summary sheet. problem is, not all the sheets have data in the same columns and rows but all the data is the same. what i am trying to do is something like vlookup("a",sheet2!A:M,***need to put the column of the data here***,0) i cant just put in the column number because it changes on each sheet, need some way to do another lookup there, like an hlookup or something, so that i could lookup which column contained 'sales' and return that number so it can be put into the vlookup.
View Replies!
View Related
Show Worksheets Based On User
I have a workbook with multiple worksheets, and I am trying to create a title sheet where a user can select their name from a drop down list, and Excel will show only the tabs that are associated with that user. For example: The worksheets in the workbook are: Heading Control sheet Client Relations Admin Sales Summary etc... The user Hudnall needs to see the sheets: Client Relations Sales Summary The user Ferguson needs to see the sheets: Sales Summary Control Sheet I want the user to be able to select their name from a drop down list on seperate sheet, and have the Macro show only the sheets that they need to see.
View Replies!
View Related
Show Sheet Based On Weekday Name
I have 5 sheets in a workbook named the following: Monday delivery Tuesday delivery Wednesday delivery Thursday delivery Friday delivery I want a macro to fire when the workbook opens. I want it to look at what day it is and then show the sheet for the next day and hide all the rest. Example, with today being Tueday, if someone opened the workbook, I want only the Wednesday delivery sheet to be visible and all the others to be hidden, well very hidden. Then tomorrow it will show Thursday delivery and so on. If opened on a Friday, it should show the Monday delivery sheet.
View Replies!
View Related
Data Validation Based On Cell Value
I am trying to set the data validation on a cell based on another cell value So basically if the User enters say CAN in cell A2, cell B2 should use "listCAN" range as the data validation list and if i enter US in A2, B2 should use "listUS" as the data validation list
View Replies!
View Related
Cell Color Based On Data Within
To my problem: I have created a spreadsheet from a questionnaire I gave to al members of staff, i have the names on the left and questions going along the top (just so you have an idea of what it looks like). To make it easy to spot problem areas I have coloured cells according to the answer (there was a choice of four). Now this works great from that point of view, but as they are just coloured cell with no data i cannot create a chart displaying the data. I understand I could just put a 1 or 2... ect in the cells as well and colour them the same as the cell so they are not visible (as it would look untidy if they were). I was wondering if there was a way to use the colour of a cell as data? If not is there a simple bit of VB that could tell the cell and text to change colour depending on data (e.g. If i put "1" in a cell, it will change the cell colour and font colour to red)?
View Replies!
View Related
Sum Based On Data In Another Cell
I have data sorted by employee that contains multiple rows for most employees. One of the columns contains a percent. I need to adjust this percent to a revised percent based on the amount of the year elapsed. For example Jones 25% Jones 15% Jones 14% Smith 30% Smith 24% If only 50% of the year has elapsed need to adjust each of the percents for Jones so that they total 50% and do the same for Smith. I have tried using the offset formula and played with a dynamic named range but am missing something. Column C contains the correct formula done manually. Need to figure out some way to have the formula change the range that is being summed. =B2/SUM(OFFSET(B2,0,0,COUNTIF($A$2:$A$11,A2),1))*$F$1 Need to keep the reference cell (B2 in this example above) constant if the name in column a does not change for 2 or 3 more rows.
View Replies!
View Related
Show Value From A Table On Second Sheet Based On Month
I need to display a value that is in a table on one sheet when the month is matched on the first sheet. The month that I need to match up is on sheet1 in cell B1 I have a table on sheet2 that is a year budget, the cell range for the months are C5:Y5 Under each month I have a list of headings and it is these cells that I need to display on sheet1 in the relevant box.
View Replies!
View Related
Show Room Occupancy Based On Dates
I want to a create a formula that reviews a series of start dates and end date, then sums the number of days (if the end and start date are withing a yearly period). i.e. Column A = Room No Column B = Start dates Column C = End dates Column A references a list of rooms (Room List) If Column A = Room123 If start date is equal to or greater than 31/12/2007 If end date is less than or equal to 31/12/2008 Calculate the number of days used.
View Replies!
View Related
FORMULA TO EXTRACT DATA BASED ON CELL VALUE
I'd like to have a formula in Column C which would extract the quantity from either Column A or Column E depending on the value in Column D. A ---- B ---- C ---- D----------------E-----------F QTY -UOM----------Tariff #----------QTY 1-----UOM1 46----PCS---------3402.12.5000----94.3--------KG 85----PCS---------3402.12.5000----174.25-----KG 4-----PCS----------3701.10.0030----4.8---------M2 5-----PCS----------3701.10.0030----1-----------M2 15----PCS----------3701.10.0030----1-----------M2
View Replies!
View Related
Rename A Sheet Based On Cell Data
I'm looking for a solution that will rename the sheet to whatever is enterd into particular cell. Ie: cell A1 = "Joe Bloggs", then the sheet is renamed to Joe Bloggs Also, on the same sheet, is it possible to change the sheet tab colour based a data in a different cell? Ie: cell B1 = "Parts", then the sheet tab colour changes to pink.
View Replies!
View Related
Assign Data To A Separate Cell Based On Value Of Yet Another
I have a "memo of meeting" excel document used to capture notes during client meetings. In this document there's a cell for "purpose", "agenda", and "notes". The 'consultation type' cell is a drop-down populated by values set in Sheet2. The 'agenda' & 'notes" cells are then populated with information (also stored in Sheet2) based on what drop-down option was chosen in the 'purpose' cell. I'm currently making this happen with basic =IF() statements; however, the problem is that by doing it this way, the =IF() statement must reside in the actual cell which will end up showing the data. This is undesirable as there may be additional notes, agenda items, etc. that I'll need to add during the meeting and as it's currently setup, I can only have either the pre-populated info OR the ad-hoc notes - not both. It seems a simple fix. Maybe put the =IF() statement in a cell off to the side but have it "assign" the value to 'agenda'/'notes' but that doesn't seem to work.
View Replies!
View Related
Data To Separate Worksheets Based On Cell
I have a spreadsheet of ~5000 rows of data that I would like to separate based on the product code column (11 product codes - 43,301,304,313,332,334,979,984,985,986,992). As it stands, I've been copying the sheets, then removing the data by filter, but doing this every week seems to be a waste of time.
View Replies!
View Related
Populate A Cell Based On Range Of Data
I need to modify the code below: PHP Sub Macro1() Macro1 Macro Dim strbody As String For Each cell In Range("B2:B640") Sheets("MASTER").Select Cells.Select Selection.Copy Sheets("Final Merged").Select Sheets.Add ActiveSheet.Paste Next End Sub The code above is creating a new sheet for each different value in column B. I would also like to take that value and place on the newly created sheet in cell A17. Also, how would I get the sheet to be ranamed to match the value in cell A17 of the newly created sheet?
View Replies!
View Related
Find Worksheet Based On Data In A Cell
In Sheet1 I've got a list of names in column A, then I've got a worksheet for each name in the list. I'd like to fill in column B with information from the worksheet of the same name as in column A. Quick example...name in column A is Davis, want to fill in column B with a value from cell C3 on worksheet named Davis and do it for the entire list. Data being looked for is in same cell on each worksheet. Tried using a formula and dragging it down the list, problem with that is it doesn't change the sheetname just the cell.
View Replies!
View Related
Filtering Data Validation Based On Other Cell Value
I'm working on a few dynamic KPI charts and could use a little help with figuring out data valuation for the End Date value. In the attached workbook I am using data validation to pick a start date from a dynamic list (Dates) in E2:Exxx. Cell B2 has 2/8/2010 picked. I would like to have a drop down in B2 show the listing of all dates in E2:Exxx which occur after 2/8/2010, so the filtered list would be in the range E3:E49.
View Replies!
View Related
Move Data Based On Cell Values
I would like to know if the following problem can be solved using only Excel without any operator intervention. Can a formula be created? If yes I would appreciate it very much Problem: If B5 = X Move B6 thru K6 to B5 thru K5 And Move B7 thru K7 to B6 thru K6 And than Blank out B7 thru K7
View Replies!
View Related
Lookup Data Based On Cell Content
I am setting up a worksheet (1) with a full list of part numbers supplied, cost etc. ie: Part Description Price Qty 1234 Blah Blah £1.00 1 1235 Blah Blah £3.00 0 1236 Blah Blah £2.00 2 And I have set up a seperate worksheet (2) as an invoice. What I have been trying to do is when I enter a qty in worksheet (1), worksheet (2) will reconise an entry in the qty colum an copy selected fields/ cells. I can do a "=" or use an "if" statement looking at anything greater than "0". but is there a way I can get the invoice worksheet to ignore any lines with "0". So it will only copy over the information with only qtys for the invoice ?.
View Replies!
View Related
Copy Data Based On Date In Cell
I am trying to build a summary report that pulls from two different worksheets within the same workbook. Here's the context of my problem: Worksheet 2: Column A has a list of dates. The corresponding information for each date is within the row. Sometimes, there are repeated dates with different corresponding information. Worksheet 3:This is my summary sheet. This report needs to update daily and only pull data related to "today's" date. My question is if i have three rows with the same date but different data, how do i tell my summary sheet to display all three rows for that date. So far, I can only get it to pull the data from the last row with that date.
View Replies!
View Related
Transfer Of Data Based On Common Cell
I have a workbook with several sheets containing prices of products. One column has the product number and a second column has the price. We just received new prices. Can a macro read the product number from the new sheet, find the same product number on the old workbook and transfer the new price. and than change the price so I know it was updated.
View Replies!
View Related
Shapes Or Angles Based On Cell Data
Can Excel Draw Shapes or Angles based on Data? I have a radiation Excel file that solves for Radiation intensity using Distance and shielding as reducing factors. Similar to a circle of light being less intense with distance so is radiation. I need excel to draw a circle from a point specified based on a value I give. For example at 1 ft I might have 500 R in 1 hour (life threatening!) At 16 feet I have about 2 R in 1 hour (not safe for too long). These circles would be overlayed on an map. I would like to draw a new circle at various distances, simialar to a bullseye. I would also like a triangle drawn based on angles and SIN / COS / TAN formulas
View Replies!
View Related
Hide & Show Sheets Based On Names
I made one file with 13 sheets. sheet1 tab name is : MAIN and other sheet tab name like following 2. xyz-Sales 3. xyz-Rev 4. xyz-SSN 5. xyz-ddn 6. abc-Sales 7. abc-Rev 8. abc-ddn 9. abc-ssn 10. ddd-sales 11. ddd-Rev 12. ddd-ssn 13. ddd-ddn In Main sheet There are 3 buttons 1 . XYZ 2. abc 3. ddd when user press on xyz button then only xyz sheets (like sheet 2 to 5) are shows to user and other sheets are very hide if user press abc button then only abc sheets (like sheet 6 to 9) are shows to user and other sheets are very hide i don't want to use Sheet2.Visible = xlSheetVeryHidden i want to use finde xyz sheet tab name and shows and other are hide.
View Replies!
View Related
Show/Hide Command Button Based On Location
What i am trying to do is make a command button appear when you hit any cell of the row its on. For example, If you were to hit any cell on rows 1 or 2 the command button will appear and when I am not on the visible property goes back to false. I have a ton of buttons on this sheet and I am trying to clean it up so buttons only appear as needed.
View Replies!
View Related
Show Late & On Time Based On Dates
I'm working with data as displayed below. My objective is to create a table by Model with summed quantitiies in two columns representing On-Time and Late. On-Time is achieved when Date Shipped is on or before the Promised Date. I have included the required format to be achieved in the second example. I'm willing to work with macros or VBA for the solution. I just need guidance to learn how to accomplish this task. CREATE TABLES LIKE BELOW? ----B---- -----C------ --D-- ----E----- 6 Promised Date Shipped Inspection 7 Date Mod # 8 11/30/07 11/01/07 780 15216 9 10/10/07 11/01/07 230 15174 10 11/20/07 11/07/07 665 16314 11 9/13/07 11/07/07 230 15008 12 12/10/07 11/08/07 780 14452 13 11/15/07 11/08/07 780 15233 14 12/18/07 11/12/07 665 15219 15 12/3/07 11/12/07 780 15224 16 10/14/07 11/12/07 230 15011 CREATE TABLES LIKE BELOW? -N-- ---O--- -P-- 7 Mod On Time Late 8 225 9 230 10 335 11 555 12 665 13 780 14 1120
View Replies!
View Related
|
TRACKER
