Search results for query: *

Does anyone know what causes the error message "Cannot shift objects off sheet" in Excel? The help system has nothing on it. I get the error when I try to hide details in groups by using the little 123 grouping buttons in the top left corner. I'm not sure which objects it is trying to...

Hi Skip, I wish I could give you 5 stars for this. It was a simple thing but it's been driving me nuts and the "Definitive Guide" I bought must have this little tidbit buried in the middle somewhere. I made one minor modification. Instead of $D8:$J8 I changed it to just D8. That way it...

I have two ranges, one call PNames and the other is Sch_Date. PNames goes from A2:A10. Sch_Data goes from D2:J10. I'm trying to code a line in VBA that will look at the value in A2 (to see if it has the word Total in it) and if so will then conditionally format the cells in Sch_Data that are...

Hmm.... Thanks for the responses, but I must still be missing something as I can't get it to work. Below is the code I'm using in macro form. ' CondFormat Macro ' Range("Sch_Data").Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression...

I've created two buttons. One adds subtotals to a worksheet and conditionally formats the sheet to highlight any totals that don't add up to 100. The other removes the subtotals and resets the formatting to normal. The reset option is working fine, but I can't get the function that formats...

Hi Folks, Thanks for the replies. I had tried the things mentioned but was hoping that I had missed something like an option setup that said "insert new rows with formulas" or something like that. I will be doing this a lot, but all of the formulas use relative references so there's not much...

I thought there would be an easy way to insert a row and keep the formulas from the rows above, but if there is, I haven't found it. No faqs or previous posts seem to have covered it. What is the best way to do this? It's funny that conditional formatting does seem to work for newly inserted...

Awesome! That's just what I needed. So I'm giving you a star for pointing me in the right direction. Thanks a ton!

I'm trying to build a dynamic list that functions as follows. A normal list with the numbers 1 through 6 enters a value into column A. Another list in column B needs to look at the value in column A to be able to present a subset of options that only purtain to the value in A. The various...

That should work pretty well for what I need. I hope to control the number of rows through optimizing the design of the data storage. Thanks for sharing your knowledge. Cheers

Hi Again, Yes I would really benefit from knowing how to hide and show details for a particular group. As well, how about that question of showing and hiding for all groups in a named range? Is that possible. Thanks again, Glenn

I figured out how to do the same thing in VBA code. The following seems to work: ActiveSheet.Outline.ShowLevels RowLevels:=4 So my final wrinkle is: If I have two ranges named and I have groups created in each range, is there any way to only open the groups for one particular range? Is...

Hi Glenn, Thanks for the Outline tip. I actually had it turned on, just never noticed it before. Now do you know how I could accomplish the same thing in VBA code? I need to create some buttons that do similar things. Thanks again.

I've got a range defined that includes a series of groups that were created manually. I'd like to be able to Show Details and Hide Details for all of the groups in the range (or in the entire worksheet) at once. Does anybody know a fast way to do this in VBA code? I'll be using it in a...

Sounds like it's definitely time I get familiar with pivot tables. Thanks for the great lead.

Hi Keith, I think you're right. The more I think about it a filter probably isn't the best method to do this. I do need to keep this spreadsheet in this particular layout for the visual aspects, but maybe I should use command buttons instead of filtering? It's been years since I've done any...

I'm trying to create a "visual scheduler". I have a series of narrow columns each of which represents one day in a calendar. Down the first column I have a list of names of people who will be assigned to projects on specific days. Above all of this I have several rows that show the project...

I don't know if this applies to your situation or not but I had a similar problem with Windows 2000 whenever I worked from home using a VPN connection. As it turned out the problem was with the network protocols that were being used. It seems that Office likes to know about all of your...

Does anybody know of any good tools for tracking people working on projects by their specific skills? An MS Project add-in or even an Excel spreadsheet might do the trick but I haven't found one yet. My scenario is that I have a pool of developers working on multiple projects which make up...

This is really basic but I'd appreciate some help. I have a table called tblDetails that has a field called QorA, which holds either the letter Q or the letter A (big surprise, eh?). The field defaults to Q as per the table setup. Whenever data is entered into that table using a certain form...