Search results for query: *

Hello. With regard to excel, in cell A1 I have a description of a product(SPAN2002 GR 1 SPANISH MATHEMATICS CALIFORNIA PUPILS EDITION) In cell A2 I would like to write a formula that would place the state inside cell A2. I've tried using the If function but can't seem to get it to work. Any...

Hello! If I have subtotal a spreadsheet in excel, can a code be created in order to allow a blank row to be placed each time the word total appears? This is a large spreadsheet with many various topics, therefore providing many "total's" throughout the spreadsheet. Can this be...

Joe, you have an enourmous amount of patience. Thank you! Below you'll find my initial inquiry. I hope I explained it well. If you had any idea how long it takes me to acquire the desired results, you'd understand why I'm in desperate need of assistance. Here it goes: Good morning. My...

Hello! If I send an excel file via email, how would I prevent someone from forwarding or copying that file to someone else? Can the code contain some type of username that only links to perhaps the receivers email, allowing only that person to open it? Any suggestions would be greatly...

Hello! Is there any way to add colors to Excel worksheet tabs? Cheers FB

I'm utilizing a shared file in which I want others to be able to run the query if necessary without gaining access to the code written in the query. I've tried all of MS Access security features along with disabling certain keyboard functions. When all is said and done, you can still expand...

Good morning. My initial description of the problem was incorrect which brings me back again with my dilemma. I’m almost there, so I just have a few more questions. I have a database consisting of 50,000+ lines of data, which are broken down into regions. e.g. East, West, Southwest.... and...

Hello to all! Is there any way to create a password in order to prevent others from viewing code that was utilized in a query? Thank You FB

Good morning. My initial description of the problem was incorrect which brings me back again with my dilemma. I’m almost there, so I just have a few more questions. I have a database consisting of 50,000+ lines of data, which are broken down into regions. e.g. East, West, Southwest.... and...

Good Morning! Is it possible to prevent someone from viewing the code that is placed in a query. Thanks FB

Good morning. I have a database consisting of 50,000+ lines of data which are broken down into regions. e.g. East, West, Southwest....and so on. I run a query by region, copy the results to excel and provide subtotals. Problem is this-there are certain account numbers that are not only...

Upon entering the following formula in a query:IIF(ROUND([Col1]/3,2)*3=[Col1],[Col1],ROUND([Col1]/3,2)*3) a message pops up indicating that I must enter a parameter value. Can someone please explain this to me? Thank You FB

I need to compare two reports which are taken directly from the internet as a Word doc. The reports contain both text and numbers. I've tried copy/paste, import/export and I've saved those Word documents every which way I can possible think of to try to get it into Excel. Is there something...

Hello to all! I have a database containing 40,000+ lines of data that gets updated monthly. Here is an example of what the results look like once I copy and paste them into Excel: Acc # COMP UNITS BUDGET SP186412a AB COMP 465 $56,258 SP186412c AB COMP 465 $69,569 SP186412r AB...

Hello to all. I have been given the responsibility of ensuring that thousands of numbers meet certain criteria in order for the calculations to be accurate. In a nutshell, these number MUST be divisible by three in order for this program to perform the calculations correctly. I've come up...