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...
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.
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...
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).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.