Recent content by JMcVeigh

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

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

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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 -...

Thank you lbass - that is exactly what I needed.

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...