Search results for query: *

I believe I have basic understanding of PivotTables and how to manipulate specific data from my PivotData within Excel 2010. Some fields within my PivotData are: - Bid Date - Bid Year (calculated off of Bid Date) - Office - Our Bid Amount - Placement (1, 2, 3, etc) - Low Bid - High Bid -...

Some of the information on my spreadsheet is actually export data out of our estimating program. We're needing to convert some information (which I'm doing through numerous formulas in Excel) in order to import into our accounting program.

Thanks, that's what I thought the formula should be, but originally I wasn't getting anything when cell F4 "looked" blank. Found out my cell actually contained a space and wasn't actually blank. Your confirming my formula finally helped me to see that. Thank you very much

Having problems figuring out my IF formula. If the value in cell F4 = "???" or if F4 is empty, I want to "LS", else I want the value that is in F4 to be returned. Believe I need to use the ISBLANK formula for F4 being empty, but can't seem to get the right formula put together.

Thanks! Can't believe it was that simple all this time.

I have a couple of general questions about Excel 2010. 1. In Page Setup, I often change the Scaling to Fit to 1 page wide by 100 tall. Then, no matter what printer document gets printed to, all columns are kept together for our documents. QUESTION: Whenever I turn around and use the "Row to...

I've done numerous formulas like that in the past, don't know why I didn't think of using it in this particular case. However, I'm still thinking about using Deniall's suggestion on some of my more complicated templates that I create for everyone to use. Even though I've added text into the...

SkipVought, you've sparked by interest with the Override. Where do I enter the Override values--do I create a cell for the Override's?

I agree with comments that you don't want to overwrite formulas, but there are instances where that's exactly what my various bosses want done. And the formulas being overwritten vary and there is no consistency in how they want them overwritten.

Thanks Deniall for your help. This is exactly what I was looking for. I agree with other comments, that you don't want to overwrite any formulas.

Went into Developer, View Code, and created the code you noted. Now how do I use this is my conditional format? I'm assuming it would be Conditional Format "Use a formula to determine which cells to format", but apparently I'm not writing my formula correctly, as I'm not getting anywhere.

Sorry, I should have added that I don't want to protect the sheet. Reasoning is that ocassionally we want to overwrite the formula for some special reason. Weeks or months later, someone opens the worksheet and revises a couple of numbers, but they forgot they overwrote one formula so now things...

I would like to add a conditional format to cells that currently have formulas, so that if a person enters a value over the formula, it would be easy to detect which parts of a worksheet would no longer be calculating. Is this a possibility? I'm using Excel 2010, and loving it.

We recently upgraded to Access 2007. My understanding from using help is that MicroSoft removed the AutoFill feature due to many users not liking the feature--sorry, we liked it. Due to having numerous jobsites, we still use paper purchase orders (PO) that we track in Access. We track each...

Thank you to both of you. I was thinking that I needed to move over to the VBA forum now to complete my searching and implementing. I'll be totally new to this, but am willing to keep learning--just wish I had more hours in the day.:)

Yeah, at least I know it is possible. Now I just have to figure out how to write the code or macro--any ideas on how to do this?

We are updating our Word and Excel company templates (Office 2007) and have two different office locations. Currently, we have two separate templates for each master form (one for each office location). Does anyone know of a way that I could have one template in which upon selecting the...

I create numerous templates for our office, and when using Word 2003, I had often protected specific sections of the document. Now that we're in Word 2007, I figured out how to insert a new section break; however, when I go to protect the document, I don't get an option to only protect specific...

I don't want to uncheck the "can grow", because I only want to take up one line height worth if these fields are all "null". I do like the idea of changing my font size for the longer length firm names though and will give that a try. Thanks!

Working in Crystal 9.2 I have a text field that contains three fields on two lines. {1FirmName} {2FirstName} {3LastName} The size for this text field on my report is currently one line high and has the ability to grow. What I don't like about this is that sometimes the {1FirmName}...