Extract From List Based On Conditions
I want to know how I can make Excel look at a list of information on one worksheet, extract certain items from the list, and place it on another workshet
For example, the following list would be imported from an inventory program as text and pasted on worksheet 1:
P+green beans
d-2.99
c=2
cd+10258
p+cherry tomatoes
d-3.99
c=1
cd+11204
p+red apples
d-.69/lb
c=3
cd+08902
p+tissue
d-1.99
c-2
cd+20023
How can I have Excel take this information and create a list like the following on worksheet 2? ...
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Extract Certain Data Based On Conditions
method to extract certain data from a column of values. The attached workbook has two sheets. From the worksheet named "Data" I would like to be able to extract any values >0.00% and then display the corresponding "model" (C:C) on the other sheet called "Results". I need to be able to achieve this for each day in the month and disregard all other values so I am left with a concise list. I have manually entered the info for the 1st June as an example.
View Replies!
View Related
Extract Certain Records Based From List Based On Date
In sheet1 I have the following 1. Names (Column A) 2. Date (Column B) My current list if from A2:B300 I am trying to have a piece of code go through all the records in this list, if any of the dates are within the next 2 weeks (from now()) then copy this record (name, date) and put in sheet2. And loop through all 300 records or possibly additional records.
View Replies!
View Related
Populate List Based On Two Selected Conditions
I have a worksheet which contains all the details of the medical equipment in the county that i'm responsible for. This worksheet posesses amongst others; two columns titled location and sublocation. I need a technique which will allow me to select a location from a dropdown list, select a sublocation again from a list and for these two conditions to then populate a list containing data such as asset code and description of all the items in the location and sublocation (possibly a little like an advanced filter, but only for the selected conditions) This list will then be used to provide an engineers report on equipment holdings at various locations. I'm open to any ideas fellas.
View Replies!
View Related
Lookup Value From List Based On Multiple Conditions
I have a list of holiday data which has the following info. Name, Date from, date to, hours off per day. I need to look up this information and place the number of hours against each day for each person. The problem I am having is that I can't get the hours into the cells for which the date is between the date from and date to. I have attached spreadsheet and how I want the summary page to look. I just need the correct formula inserting.
View Replies!
View Related
Create New List Based On Multiple Conditions
I am trying to filter a range of text and copy only those entries from it that meet selected criteria into a new part of my page. The entries will all look like the following but will have varying numbers before the final Equity/Index part: IBM US 3 C60 Equity IBM US 3 P60 Equity UKX 3 P5000 Index UKX 3 C5000 Index I have constructed something using a modification of the find nth word function from this site that allows me to filter based on whether the fourth part (or for the third and fourth choices, third part) shows C or P at the beginning and then based on the value that is written after the letter. However, I have to break down the code a bit further to firstly check whether the final word of the string is Index or Equity to decide which word to check for C/P. I was wondering if anyone knew whether there is possibly a more simple way of running a find within one cell than using the nth word function. Would it possibly be a case of making two subs within a different module and then calling them to look for the specific word number based on what I have in F6 (my original equity/index ticker symbol: for example IBM US Equity or UKX Index)? Attaching code below. I'm sure it doesn't make a lot of difference but in case it helps I am currently running Excel 2007 on a Vista machine but I also use it at work on a Win XP PC with 2003. ----CODE----........................
View Replies!
View Related
Extract The Counts Satisfying Two Or More Conditions
I encounter some problem in excel. I would like to get the counts that satisfy two more conditions. For example, I want the count that is both "m" in column F and "1 yes" in column G. Do I use COUNTIF or some other functions? i try COUNTIF it doesnt work well, the counts obtained doest satisfy both conditions.
View Replies!
View Related
IF Statement With List And Conditions
I am trying to create an IF statement that will double the unit value of a certain box (J15) if the number of I15 is less than or equal to 160 AND either "A,B,C, or D" is selected from a list in H15. If it does not qualify with both, it would just be the single value of J15, not doubled. So far I can only get it to work with one item from the list in the IF statement: =IF(AND(H15="A",I15<=160),J15*2,J15) However, I don't know how to add in the other list options B-D and get it to work. Basically I need these four statements combined into one: =IF(AND(H15="A",I15<=160),J15*2,J15) =IF(AND(H15="B",I15<=160),J15*2,J15) =IF(AND(H15="C",I15<=160),J15*2,J15) =IF(AND(H15="D",I15<=160),J15*2,J15)
View Replies!
View Related
List Possible Combinations With Conditions/Constraints
I am trying to write VBA code that will list all possible combinations of data contained in a worksheet based on a few conditions. I have a list that varies in length. In the first column is a list of numbers denoting a particular course number. In the second column is a list of numbers denoting the specific class number for the course. As an example, I have a 6 courses. The first course has 1 class, the second course has 3 classes, the third has 11, the fourth has 3, the fifth has 7, and the sixth has 6. Thus, my columns look like this: A B 1 1 2 1 2 2 2 3 3 1 3 2 3 3 3 4 3 5 ... I need to list out all possible combinations of classes given that I must have all six courses. EXAMPLE (Course, Class):.......................
View Replies!
View Related
Extract List From Combobox
Trying to get the list from a combobox in an online form. I'm doing this as a check to make sure what I need to be there is there. Then the macro will select what I need and move on. If not found in the list, then it will move on... So I start thinking about it and I'm not quite sure how to do that in Forms. Does ListIndex get me there? I'm unable to give the site because you'd have to login with a password, but here's the code I have to Set the combobox: Set PartNumOffr0EDrop = .Document.all.Item("PartNumOffr0EDrop") myVal = PartNumOffr0EDrop.ListIndex I need to know how to loop through the combobox and store the value of each member of the list to a variable or cell.
View Replies!
View Related
Extract Certain Entries From A List...
I have a list of U.S. cities and their crime numbers. The list contains roughly 8700 records. What I need to do is pull the records for 10 specific cities from that list. Exactly which cities are singled out may change from year to year. And this is something I'll need to do every year when the crime stats are released by the FBI.
View Replies!
View Related
Extract Data From A List
I have some code that is importing data from a text file that contains ~35,000 line items and is ~50 columns wide (this part of the code is working fine). Once the file has been imported, I need to copy certain line items to a sheet called “output”. The code would be something like this if reading line by line: If the value in row x, column 5 (it is always in the 5th column) in “AccountList” then copy entire row and to next empty row in sheet(“output”) The “AccountList” is separate sheet with a list of account numbers in column A with ~250 items. I am not sure if the code to extract this data should occur while I am importing the data or if I should do it after and run through the data again.
View Replies!
View Related
Build List Of Cells Meeting Certain Conditions
This below code i find out from this form Skip the row find next but i need it i have column fom c to M if the cell k valur or j value = 0 or empty skip the enitre row go next row ifthe kvalue <> 0 or <> empty do something the below code where do i moify . Set c = .Find(MyInput, LookIn:=xlValues, SearchOrder:=xlRows) If Not c Is Nothing Then Count = Count + 1: ff = c.Address k = c.Row Redim Preserve wsName(1 To Count): wsName(Count) = ws.Name Redim Preserve rng(1 To Count): rng(Count) = c.Address(0, 0) Do
View Replies!
View Related
Extract From A List If A Cell Has Data In It
This will get kind of complicated just a heads up.. I will try to take it in phases.... Without actually uploading my true sheet I will do my best to give a representation of what I'm trying to accomplish. Basically I will have Lists for the Year by Month. In each month the list will compile a list of problems and there corresponding data for each problem. Most of the problems will be internal, however some will be due to external (a supplier). When this occurs the suppliers name will be input into one of the columns. I want to beable to pull out the suppliers from each month and then sort them in order from top offenders to minor offenders by "QTY" See the attached example sheet. That should give a better understanding of what I need to do.. I am not sure if this can be done with worksheet functions so I posted it under the Programming thread.
View Replies!
View Related
Extract The Non-negative Numbers From A List
i need a self correcting formula to solve the following case: In column A in 7 rows: 5 -9 3 2 -4 -7 1 I want to extract the positive numbers to column B in the amount of positive number rows(no skipped row/space): 5 3 2 1 So it would look somthing like this: A B 5 5 -9 3 3 2 2 1 -4 -7 1 Is there a simple formula to do this? I have been doing IF functions but it is taking too long. And I have got the results I wanted. =IF(A1>0,A1,"") ==> works but I want the numbers to be one right after the other (no blank rows in between).
View Replies!
View Related
VBA Extract Anagrams From List
Say I had a list of words, all 9 letters long and I wanted to find all the words that had anagrams of themselves (e.g. ISOPTERAN - PATRONISE) and then list them separately as a new list. I have tried all sorts of Excel spreadsheet solutions, but I always hit a dead end. Can anyone write some code that I could add to a module that would accomplish this? The logic would go something like this: Start with first word, check that word against all the words in the list (column of words), if it is an anagram with another word (e.g. ISOPTERAN - PATRONISE), then both words would be extracted and pasted in a new list for the first occurrence, if while still checking the first word in the list against the remaining words it found a second match, only the second word found would be extracted and pasted in the new list. After the first word was checked against all the words in the list the second word would be checked. Then the third, etc. until the whole list was checked.
View Replies!
View Related
Match Data On List & Extract
Im using XL 2k and working on several worksheets. Im trying to create a formula to do the following. On Hardware Wksht Tab cell B20 should extract data from HardwareLIST Wksht if it matches to cell C20 from Hardware Wksht Tab. The cell in HardwareLIST A10 is a drop down list of hardware. C20 Specifies 4 x 8 Only C21 Specifies 4 x 9 Only C22 Specifies 4 x 10 Only However the drop list contains 3 different types of 4x8's, 4x9's & 4x10s. If selected then B20 should read drop list and match criteria & return the value from HardwareLIST D10. Im having trouble formulating this one.
View Replies!
View Related
Count With Conditions & Doesn't Exist In List
I have a Sumproduct formula to count instances of a particular event (from a list of events) based on multiple criteria. I am trying to utilize the same method to count instances of all events not defined in the list of events but I would welcome any solution In the attachment, Defined list of events A4;A5 (this is just an example, the actual list is approx 100 events) Data being counted F2:N10 (actual data approx 1000 rows) My working formula is in cells B4 through D5 My not working attempt to adapt the formula B6
View Replies!
View Related
How To Extract Dates From Cells And List Them Seperately In A New Tab?
I have set up a 'week of' calendar for a year. This allows users to enter data in a cell for the week. For example, the today would be displayed on the calendar, the 11th. What I would like is, in a separate tab, to list (in list format) only dates with data entered. How can I write a formula that checks a cell, and displays the data, but if there is no data, it goes to the next cell (to the right). In the new tab, I would like the data to be listed top to bottom even though the calendar is left to right. It would also be cool if in a separate column in the new tab to display the date, but im not sure how because the calendar isn't of actual dates, but of a few cells on the top with the month, and the actual number is in the cell. Right now I have this as a start, but it's not much... =IF(Category!C11>"",Category!C11,"") I have attached an image of how the calendar is set up.
View Replies!
View Related
Extract Month End Data From List Of Dates
I have a spreadsheet which in the first column has dates for every day of the year(for many years), and figures in the second column. I want to extract the data relating only to the month end dates. What is the best way to go about this? The month end date may also only be the last working day of the month rather than the actual month end date
View Replies!
View Related
Lookup Based On Two Conditions ...
I know that there are bunches of threads concerning lookups with multiple criteria, but I just can't figure out how to translate one to my situation. I want to return a value based on an item name which is in column A, and an operation which is in row 1. The array from which I need to look up the value contains part number in column B, operation in column G, and the actual value I need returned in column H. So I need to return something like this: ...
View Replies!
View Related
Get A Result Based On Several Different Conditions
New to the forum and in need of a bit of help. Friend of mine is in here regularly looking for assistance and tells me this is the best excel forum around. Thought I would put it to the test with a problem that is doing my head in. The following is a table which shows a salesmans sales. He or she has sold to 8 customers. What I need to do is show in the commission column how much they should get paid for the additional products based on this criteria. 1. If the penetration is equal to or over 41%, and he has sold the additional product for max profit of 250 then he should get £40 2. If the penetration is less than 41%, and he has sold the additional product for max profit of 250 then he should get £25 3. If he hasnt sold the product for full amount then he gets 10% of the profit, regardless of the penetration ...
View Replies!
View Related
Display Value Based On 2 Conditions
I have a workbook with 2 worksheets. The first sheet provides a summary showing the last date a person attended a specific course. The second worksheet is a list of all courses, attendees, dates, and status. I need a function that will match the attendee and course from the Master and display the date from the master in the corresponding cell on the summary sheet....
View Replies!
View Related
Lookup Based On A Few Conditions
I am wondering if I can do a formula that would tell me if the name that appears in column J or K appears more than once at the time/date slotted in columns A and B. Basically, I want to make sure that the name(s) in column J and K aren't assigned 2 different places at the same time slot (column B) on the same say (column A).
View Replies!
View Related
Lookup Based On 2 Conditions
In the sample that I have attached. I am trying to compare Control ID and Business Date in Sheet[Test] and Sheet[Perform], If they are the same, then populate in Sheet[Perform] Column Test Status with the corresponding row in Sheet[Test]. note that Control ID and Business Dates are not constants.
View Replies!
View Related
Sum Based On 2 Conditions
I want to have SUMIF and IF functions to be combined. i tried using the formula SUMIF( Timesheet!D2:D55,B2,Timesheet!F2:F55) but i want to edit the range everytime. Can i have formula like if name = Ant merce and prj = Implementation support, then the sum will be 15 for the sumrange of Timesheet!F:F (entire F column)
View Replies!
View Related
Summing Based On Multiple Conditions
I have been trying to search an array and cannot find the correct combination of functions to get the information I want. I might need a macro to do this but I will try anything. Here is an example: 1 A 1 1 B 2 2 A 3 2 B 4 3 A 5 3 B 6 I want to search for 3 and A and return the value in the 3rd column. I have tried several functions but cant figure out how to make sure I get the correct value in the 2nd column that corresponds to the value in the 1st column.
View Replies!
View Related
Cell Value Based On Multiple Conditions
I need to create a macro that will calculate a value based on the contents of multiple cells. Looking at the example attached, if columns A and/or B (employee ID and name) are empty, then allowable OT (G) should be 0. If either have data, then if Stage (F) is CAN, G should be 20. If Stage is FAS or FAR, G should be 10. I'm not very savvy with IF statements, which is how I imagine this can be done, and I don't know if this would be easier to do as a macro or as a formula within G. Since the contents of the of the cells will be changing on a weekly basis, I'd prefer the formula to only be there if there is content on the line, so we don't have nulls showing.
View Replies!
View Related
Reset Cell Value Based On Two Conditions
I am trying to build a spreadsheet that tallies hours worked and hours available for the next day. The key to this spreadsheet is the number 70. A worker can accumulate no more then 70 hours in an 8 day period, however after any day with no hours worked the rule resets to 70 hours available again. I have attached a sample spreadsheet so you can see how this should work.
View Replies!
View Related
Sum Based On Multiple Conditions
I am trying to sum numbers based on three counditions. My problem the third condition needs to use a wild card. I have attached a sample file, in the last condition I am only wanting to sum numbers where the characters in the last column begins with bd* The yellow cell contains the formula I am using.
View Replies!
View Related
Selecting Values Based On Conditions
find a book with two sheets. One contains data and the other is the report that I must generate. In sheet one ull find the list of all the trucks received. I would like to see all trucks that I have received in the month of say June in the report sheet as per its arrival date when I change the month on the top of the report.
View Replies!
View Related
Calculate An If Value Based On A Number Of Conditions
I am trying to create on excel order form. I want customers to be able to input the item # (a range from 1 to 12), then I want the to price to be calculated based on the item # they input. For example. If they choose item #2 in A6 then the price in F6 will be recorded as $8.00. (the price would change for each item # they input). the formula I started out with was: =IF((A6=1),"$8.00") this worked for me if A6 did in fact equal 1. So I tried adding this equation to the formula. =IF((A6=1),"$8.00")*OR((A6=2),"$7.00")....this would continue on. I even pressed "command return" after the statement as if I was entering an array formula. I got the error #VALUE!
View Replies!
View Related
SUMIF Based On 2 Conditions From 2 Columns
Have had a search around the web forums for an answer to this and am not getting anywhere. In column A i have text - apr, may, jun etc In column E i have general format text - a 6 figure number in column M i have text - eg 886.97 (a currency, but in text format) i want to: where column a=apr and column E=212130 sum the contents in column M
View Replies!
View Related
Returning A Text Value Based On 2+ Conditions
I'm trying to lookup values that are a combination of text and numbers. The difficulty is I need to use two criteria to look it up. I've been trying to use a combination of Sumproduct and Index,Match but it doesn't seem to be working. I think I need to add some sort of text function in there. Below is some data for example purposes. A B C E F G M S Get value from G M S 5G M T M T 6M M U M U 7H M V M V 8K
View Replies!
View Related
Average Based On Multiple Conditions
Im currently trying to report on cycle times for a certain task that is carried out on a daily basis. I have used NETWORKDAYS to calc each rows cycle time in Cell R14:R512 the code is:- =IF((NETWORKDAYS(O14,N14)-1)*($AH$11-$AH$10)+IF(NETWORKDAYS(N14,N14),MEDIAN(MOD(N14,1),$AH$11,$AH$10),$AH$11)-MEDIAN(NETWORKDAYS(O14,O14)*MOD(O14,1),$AH$11,$AH$10)=0,"",(NETWORKDAYS(O14,N14)-1)*($AH$11-$AH$10)+IF(NETWORKDAYS(N14,N14),MEDIAN(MOD(N14,1),$AH$11,$AH$10),$AH$11)-MEDIAN(NETWORKDAYS(O14,O14)*MOD(O14,1),$AH$11,$AH$10)) This is returning the cycle time providing both the start date/time and end date/time are filled in, or it returns blank if nothing has been filled in. I have then tried to calc the average overall cycle time in Cell R12 by using the below formula = SUM(R14:R513) / (COUNT(R14:R513) - COUNTIF(R14:R513,0)) This seems to be working proved i have two rows of data filled in. My problem lies when all the cells are blank, it then returns the DIV error. I have tried using an if statement to ignore if the cell is blank but it still returns the DIV error. Im really at a loss on this and now im not even sure if i have gone about this in the right way or if there is a better way to approach the whole task? I have attached a sample workbook to try and better explain.
View Replies!
View Related
Add Sheets Based On Conditions
i am not able to solve this problem. 1- I have 3 tabs in this worksheet with the data - Tabs A , Master Data and refernce Table 2- Suppose column K in the tab " Master Data " has a record or number, they can be repeated as the new data us added every month. 3- Reference table has the list of the same data record ( numbers ) . Now the situation is if there is a new record in the column K of the master data sheet the Macro should do the following. a- Check for the record in the reference table , if doesnt exist then add the record in the reference table b- create another sheet same as the sheet " A" (duplicate of A) and name it the new record number b- Plug the new record number in the cell B2 of the new sheet c - Copy the row 8 from ( D8 to O8 ) in the new sheet from (D8 to O8)from sheet A
View Replies!
View Related
Return Data Based On Two Conditions
I have very limited vb experience and I believe it’s the only way I can do what I need to get done. I am working on creating an invoice template. I want the price to populate based on two conditions. The two conditions are invoice line quantity and month. Let me provide data ranges. The user will enter a quantity for each invoice line moving down B17, B18, B19, B20 etc up to 24 lines. (through B40). The user will enter a current date in F13. Away from the main body of the invoice: Range T5 thru T16 will be pre-populated with each month of year 2007. So T5 = 1/1/2007, T6 = 2/1/2007, T7 = 3/1/2007 etc. Range U5 – U16 will be pre-populated with the line price for each month if the line quantity is less than 10 Range V5 – V16 will be pre-populated with the line price for each month if the line quantity is 10 or more The price should autopopulate in G17 - G40 where a quantity is placed in the corresponding column range B17 - B40. The number of lines varies per invoice so I'm setting the template up with sufficient lines. As an example, the price should populate for each invoice line beginning in G17 to correspond to the month entered in F13 and quantity entered in B17 based on the corresponding month in T5-T16 and the price in either U5-U16 or V5-V16 given the quantity. So if the Month in F13 was February and the quantity in B17 was 25, the price that populates G17 would come from V6. If the Month in F13 is March and quantity in B17 is 5, the price that populates G17 would be from U7. I just don’t have enough experience to write this myself.
View Replies!
View Related
Copy Range Based On Certain Conditions
I have this macro to copy a range to another worksheet: Sub transpose_UPCID() ' Hace el copy y paste transposed en BAUCS de los numeros de UPC"s y ' las cajas ATR Dim rng1 As Range Dim rng2 As Range Set rng1 = Sheets("Sales-Inventory").Range("UPC", Range("MK_ID").End(xlDown)) Set rng2 = Sheets("Sales-Inventory").Range("Figure", Range("Figure").End(xlDown)) rng1.Copy Sheets("BAUCS").Range("C11").PasteSpecial Paste:=xlValues, _ Operation:=xlNone, SkipBlanks:=False _ , Transpose:=True rng2.Copy Sheets("BAUCS").Range("C37").PasteSpecial Paste:=xlValues, _ Operation:=xlNone, SkipBlanks:=False _ , Transpose:=True Application.CutCopyMode = True End Sub The only problem is that this code copies all the items and I need this code to look into Column A in the Sales-Inventory worksheet. There I have a data validation with a total of six options. I also have six differents worksheets where I need to copy the values based on that data validation. To give you and example, all items containing XX in column A copy to XX worksheet. Something like that.
View Replies!
View Related
Flagging Duplicates Based On Multiple Conditions
Flagging Duplicates based on Multiple conditions.. I have attached the file for reference with Dummy Data as the actual data runs in thousands... What I require is to flag Duplicates with some formula so that I can filter and then later delete those specific rows from the records... The Duplications has to be considered on Multiple criterions: 1. If the FNAme and LName is appearing for one Company more than once. 2. Sometimes there would be inconsistency in Data Entry, so the FNAme would be typed in the Column for LName and vice-versa.The code needs to understand the same. 3. Alongwith the above, if the Designation is different then the record with the Lower Designation based on the Weightage should be Flagged as "Duplicate". Ex: - 4. If there's a tie between the same designation then the record with the Maximum information across all the columns having Max info should be Unique. Ex:- The amount of details mentioned in the following columns would determine the record to be termed as Duplicate or unique 5. If still the records are identical then the first occurence can be unique... I have made this data to give an example as the actual data is very confidential. Please allow room for adding New Designations as the Designation and their Weightage needs to be Dynamic. Please refere the Word doc Duplication Criterion Explanation for the explanation.
View Replies!
View Related
Trying To Use SUMIFS To Sum A Column Based On Two Conditions
I would like to use a SUMIFS statement to sum up a column of numbers based on two conditions. The first condition is a word. I have this done. The second condition is going to be a two week date range, which I am having problems solving. Here is my formula that works so far. =SUMIF(Data!C:C,"Office",Data!D:D) Now I would like to SUMIF a second condition is met. The second condition is a date and time in this format. 1/9/2010 9:21:49 AM I am only concerned about the date. Time does not matter. I cannot figure out how to specify a date range for the second condition. I am trying to specify between 1/1/2010 and 1/14/2010 as a test. So here is what I have so far with a SUMIFS. =SUMIFS(Data!D:D,Data!C:C,"Office",Data!A:A,"Cannot figure out how to specify dates") Maybe my logic is wrong...maybe I need to do three conditions? Where column A has a date < 1/14/2010 and a condition that specifies a date > 1/1/2010.
View Replies!
View Related
Highlight Non Matching Rows Based On Conditions
I am having a problem finding or creating a macro for what i am needing to do. I have a workbook with 2 worksheets (2 months july and august) to figure out a billing process. I need to be able to First of all search each value in Column A on sheet 2 (august) to Column A on sheet1 (July). My sheet is set up like this where ID is a buyer and Products 1,2,3...are if they have purchased that product from us A B C D 1 ID Product_1 Product_2 Product_3 2 100 0 0 1 3 200 1 1 0 4 300 1 0 0 5 400 0 1 0 Better Picture representation attached Both worksheets are very similar but August may have some changes from July such as new ID's and changed prduct purchases. What I need to do is have each ID in Column A be compared to Column A in the July sheet, but it may not always be the same cell (because of new ID's added they are moved around)..so it need to search for the same ID first then compare. Once it finds the ID, I then need it to compare the rest of the row (the product info) for that ID to see if any products were added or changed to determine billing. And for any changes that are found in the comparison, I need them to be highlighted. Now in the case that a new ID was added...it wont be in the July sheet, so the whole row would need to be highlighted to notify of a new ID and new billing needs to be added. This way the billing person can look at the sheet, see the highlited changes and see what is new or needs to be added to a previous ID's billing. Currnelty they are looking at it manually to see if there are changes.
View Replies!
View Related
Hiding A Command Button Based On Conditions
I am using Excel 2003. I have created a workbook containing two sheets. The first sheet is designed as a form for our managers to complete. The fields they are required to complete are based on the selection they choose from a drop down field (set up through data validation). I have created a command button which when you click it opens up the second sheet of the workbook asking you to complete the individuals work pattern. I am trying to hide this button so that it only appears when you select certain options from the drop down field. I have looked back through posts on here and have tried adding the VBA code to the worksheet around commandbutton1.vissible = False in an IF statement but can't get this to work. A colleague has suggested that you can't hide command buttons because they are fixed items - is this the case.
View Replies!
View Related
|
TRACKER
