Search results for query: *

Yep...that worked. I merely multiplied each cell value times 1 in a new column and it did the trick. Thanks.

That did work, however, there are different dollar values in each cell. Doing the above changed all the dollar values to equal the main cell highlighted.

I have a spreadsheet that was developed by exporting from a database (I don't have access to this database and cannot have the information re-ran). One of the columns has currency data, however, I cannot add or change the format. An example of the data within a cell appears as $45,652.32 when...

Bam!!! I changed the ScollArea properties within the Workbook's Open event and that did the trick. Thanks

I have a spreadsheet that someone else created, and he somehow limited how far I can scroll both vertically & horizontally within the worksheet. How is this done? Basically, you can only scroll as far as there's data that you're allowed to see. I know there's more data but I cannot scroll...

I played with that option as well but kept getting an error stating there was an overlap problem. I'm not certain, but believe this feature is used to combine worksheets with like labels where my data is all on the same worksheet. I ended up using an Access query to group & sum my data which...

It seems like this should be a simple task in Excel. But I guess my only option is to import it into an Access database, group it by a query, then export back to Excel.

P.S. I know that I can Subtotal, but unfortunately that won't work for what I need to do next.

Sorry about that, I'm using Excel.

I've already tried VLookUp, but it will only pick the first match. DLookUp doesn't seem to be an option. I only have LookUp, VLookUp, & HLookUp.

I have the following: Account Desc 2004 2005 100200 CASH $3,000 $4,000 100200 CASH $2,000 $5,000 103500 BONDS $10,000 $6,000 104110 STOCK $1,000 $0 And would like to have: Account Desc 2004 2005 100200 CASH $5,000 $9,000 103500 BONDS $10,000...

That did the trick.... thanks! That's the first time I've ever used that tool.

I need to have a report shown in the following manner: Dept1 Dept2 Dept3 Dept4 Total Element 1 $300 $40 $0 $100 $440 Element 2 $1,000 $500 $500 $200 $2,200 Element 3 $400 $20 $0 $40 $460 Total $1,700 $560 $500 $340...

Two areas contribute to a particular program each having different contribution levels and limits. As payments are made, each contributor should be charged their portion of the payment. The user need only enter the total payment amount and a formula porates the amount accross the two areas...

In playing around with my video drivers, I somehow royally messed up everything. I first tried using the system restore feature within XP, but even though I could see Windows on my monitor, it still wasn't back to normal. The very last (very stupid) thing that I did was disable my video card and...

Computer: XP Professional Pentium IV 2.25GHz processor 512MB RAM GeForce2 MX 400 (Gateway) 64MB Video Card Problem: I won't run Halo: Combat Evolved. Rather, it state "Your Computer's video driver is known to have serious issues with this game. A newer version that is compatible may be...

Kudos...Kudos... Thanks for your help. It did the trick.

Thank you for your help; that definately did the trick. However, now I'm having a problem of a different sort. I'm now getting the error "Data type mismatch in criteria expression" for the following line: rst.FindFirst strCriteria The field ACRID in the tblAgents table is an AutoNumber which...

Can anyone tell me why I might be getting the error "Method or data member not found" when using the FindFirst Method in a procedure? It works fine in another database I've built. And both databases are using the same Reference Libraries. Below is an excerpt of my code: Set dbs = CurrentDb...

Is there an easy way to calculate the number of days in a month or range of months? The NETWORKDAYS formula doesn't include the weekends and the DAYS360 formula is based on 360 days. I need it to be based on a 365 day calendar year (i.e. actual days).