Search results for query: *

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

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.

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

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!

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

Try getting rid of the "" around the word false