Search results for query: *

Skip, I'm sure you could design a very sophisticated system to handle the information in question, but in kjv's real world situation, it seems that a K.I.S.S. approach might be more advantageous, at least for the time being. If the person working with the system either cannot understand how to...

kjv, When I saw that post you referenced, it reminded me of the vacation accrual sheet I had already designed several years back. If you decided on that type layout, I figured it would give you a good starting point to try out some sample data rather than having to start completely from scratch.

I also have a version of a vacation accrual for your perusal. It is set up for a $$ basis of vacation cost, but could be altered to use time in hours instead. additional columns can be added for department breakdown, etc. Maybe, if you get enough input, the correct answer will make itself...

Make the entire column showing percentages green to start with, and use conditional formula to change percentages less than 96.00 = "red".

zelgar, your formula does not consider the occasional sale at less than cost (a loss). WillieMaykit's formula, and my suggested formula, both allow for such a possibility. Why is everyone trying to make this so difficult??? I'm curious as to why we haven't heard anything from ladyck3 if any of...

combo, while it should be obvious with a blank cell in the Profit/Loss column that the item has not yet been sold, you would be able to show that in the Profit/Loss column without adding another column by amending the formula to =if(I19>0,I19-E19,"not sold"). This would not affect the summation...

mintjulep, there IS a need for a conditional test... to test whether or not the item has as yet been sold. An alternate to WillieMaykit's formula (which looks fine) would be =if(I19>0,I19-E19,""). The profit/loss column will show only results for items that are already sold, and can be summed...

Skip, I responded before I saw your last correction. NOW it works as I needed. Thanks for your help on this. I want to give you a star, but I don't see where to do so... has that been eliminated?[thumbsup2]

Hi again Skip, This formula works if the only word in the description is "TOTAL", but not where there are ADDITIONAL words in the description. I need a "contains" function within the formula to make the formula work. Thanks for your help. Ken

Hi Skip, I believe I need to write a formula within the Conditional Format rule that identifies the description cell and then applies the correct format to a different cell next to it. I don't know the correct syntax for writing that formula, but in pseudo syntax, I believe it should be...

I am using Excel 2007 and I want to use conditional formatting to make a number in various cells in column M bold where a text description next to it in column L has the word "TOTAL" within the line of text. I am able to make the text in column L bold for descriptions that contain the word...

Your bank may have an online download process in .csv format that directly loads into Excel. Have you explored that possibility? It would certainly save the hassle of converting from pdf.

Since your information is already in Access, why not bypass Word altogether and build an Access report in letter format that will allow you to insert your fields as needed. The multiple tracts issue would be easily handled within the Detail section of the report, and the Header section would...

Couldn't you put your control for the summation in the detail, then sum the control in a group footer grouped on "div", and set the detail as not visible or "cancel print"? That way only your group totals would print.

Format your formula cell as a number and your answer will be accurate using the =H2-Today() formula. Then Conditionally format that same cell as color red for value less than zero.

Have you tried applying an AutoFilter to the column containg your bracketed information? Click on the "Custom" selection and type "[ce" or "[K", etc. for your criteria to search for. This will list all information that meets your criteria.

See if this solves your problem. If column A contains the numbers you wish to sum beginning with row 2, type this formula in column B starting with cell B2: =if(A2>0,B1+A2,0) Copy this formula down as far as you have rows. You will have a running summation for each group. If you don't want...

Skip, That is precisely what I needed. Thank you so much for your help!

Sub copyformula() ' ' copyformula Macro ' Macro recorded 6/3/2011 ' ' ActiveCell.FormulaR1C1 = "=IF(RC[-20]<>R[-1]C[-20],RC[-1],0)" Selection.AutoFill Destination:=Range("W2:W200") Range("W2:W200").Select End Sub

As I explained in my follow-up message, I want to copy the formula placed in the cell "W2" down that column for as many rows as there are lines of data which will vary from day to day. If done manually, this can be accomplished by simply double-clicking on cell "W2"'s handle. I don't see what...