Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JMcVeigh

    Excel question - allowing entry in a cell based upon another cell

    anotherhiggins That is a great idea...can I do that?
  2. JMcVeigh

    Excel question - allowing entry in a cell based upon another cell

    Thank you Skip...that worked like a charm...
  3. JMcVeigh

    Excel question - allowing entry in a cell based upon another cell

    I am sorry if this is obvious, but I just can't seem to make it work. I have a question in my spreadsheet in one cell in Excel as to whether or not something is approved. If the answer is Yes (data validation turned on for this cell) THEN allow an entry in the project number field (which is a...
  4. JMcVeigh

    Summing values based upon rules

    That makes sense to me - now I just have to convince the powers that be, that we should do it that way. You guys/girls are great - thanks.
  5. JMcVeigh

    Summing values based upon rules

    Thanks for the help...but I am still not getting it. Here is a sample table, maybe it will help me ask my question better. Name 1/1 1/2 1/3 1/4 Vac Sick #1 8V 8V 16 #2 8V 4S 8S 8 12 I am looking to get the values under Vacation and...
  6. JMcVeigh

    Summing values based upon rules

    Ok, so I have a time tracking spreadsheet were the users enter in 8V for 8 Vacation Hours, or 4S for 4 sick hours on the day it was taken. Only one entry per day at this point...I have used validation to only allow for valid entries for time off. I have worked a way to get the totals for month...
  7. JMcVeigh

    need a prompt in a macro

    Ok, absolute beginner here with visual basic... I recorded a macro and I need to be able to answer a prompt each time I run it. Here is the macro: Selection.TextToColumns Destination:=Range("$M$86"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False...
  8. JMcVeigh

    Inserting prompt in Excel macro

    I recorded a macro and I need to be able to answer a prompt each time I run it. Here is the macro: Selection.TextToColumns Destination:=Range("$M$86"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False...
  9. JMcVeigh

    Data Validation using Dates

    I would like to have an error message pop up that warns the user that the end date is before the start date. Thought I could used Data Validation for this, but I can't seem to get the specifics correct. Does anyone know what I need to do? Cell A1 - Start Date Cell A3 - End Date If user enters...
  10. JMcVeigh

    Find text within a cell

    I have a list of last names that I need to find within a range on a different worksheet to see if those people also filled out a form. The people that filled out the form have their name listed on a different worksheet in the spreadsheet in one column. I tried using VLOOKUP, but with no luck...
  11. JMcVeigh

    Can't total values in detail section...

    Thanks for the suggestion, but when I right click on the formula that calculates the price per student, the option to Insert is not available (I am using 8.5). Even if I don't choose the field and go through the menu options, the formula field is not available to use for the summary and/or...
  12. JMcVeigh

    Can't total values in detail section...

    I have a view that holds the data per student per class that has attended a course. We charge a different rate for the first person than we do for the 2nd, 3rd, 4th and so on. The first person registered is at full price, but each additional student is 30% of the full value per class. So, what I...
  13. JMcVeigh

    Labels and page breaks

    I need to print only one label that is 5" wide and 3" long onto a tractor feed label. I have tried a few different options, but no matter what, each time I print one label, one prints and then it spits out 3 blank ones. I believe this is due to the page length setup of 11 1/2 inches -...
  14. JMcVeigh

    splitting a field into two separate field

    Thank you lbass - that is exactly what I needed.
  15. JMcVeigh

    splitting a field into two separate field

    Thanks for that, but I actually need to make two separate fields out of this and not one field that has a line break. (I can use this idea for something else - so thanks for that) The end result of the report I am writing is to create a delimited file. Is there a way to take the one field and...
  16. JMcVeigh

    splitting a field into two separate field

    I have a string field that has a / (slash) in the middle and I need to split it at the /. I do not need the / in the 2 resulting fields. any help is appreciated. Thanks.
  17. JMcVeigh

    using mailing label expert

    Thanks for the tips, but I don't have the option of creating a table. any other ideas?
  18. JMcVeigh

    using mailing label expert

    Hi I am running into the same sort of thing...I am using a table that has one instance of a record, but I need to set up a parameter for the number of copies that are needed. Can you share how you got yours to work? Thanks!
  19. JMcVeigh

    Parameters

    I am using a parameter to give the user a choice of how to group the information on the report. Each parameter allows for the choice of A, B, C, D or E (real names are not used for the safety of the choice-hehe) Is there anyway to limit the second choice to NOT include the choice they make for...
  20. JMcVeigh

    need help troubleshooting a formula

    Try getting rid of the "" around the word false

Part and Inventory Search

Back
Top