| Thread | Last Post | Replies |
|
| Change Language | 21 Oct 2006 21:37 GMT | 1 |
I created a text page in excel in the english language, I want to copy this page and change it to spanish text, so I will have one in english one in spanish. Can this be done
|
| sorting by series | 21 Oct 2006 21:21 GMT | 2 |
Is there a quick way I can sort a worksheet by a series like Mon thru Fri or Jan thru Dec instead of alphabetically? I want to sort a data list that contains days of the week from Mon thru Sat and then subtotal them. Thanks,
|
| suming instances in pivot table | 21 Oct 2006 21:04 GMT | 1 |
i have uploaded screen shot of my pivot table at http://www.sunagusa.com/pivot_exampls.gif in pivot table in the row area i want to count the occurance of sales_doc_#.
|
| Evaluate command | 21 Oct 2006 20:35 GMT | 9 |
I received a suggestion to use the Evaluate function in a prior note (subject "named range question") and it works well. One problem, the evaluate command does not seem to recalculate when related cells are changed. I have to stimulate that recalculation by clicking the
|
| Pasting Table Info from Word to Excel | 21 Oct 2006 20:05 GMT | 13 |
Using Office 2003. I have created a table in Word where the first column is address information on 3 lines in one cell (Name, Address, City State Zip) Before going further with this Word table, I decided I really wanted to track the information in Excel. Having trouble pasting ...
|
| excel man | 21 Oct 2006 19:33 GMT | 2 |
I need to calculate dates, with Sunday (only) being skipped. Example: I want to enter a date in a cell, and have excel add 5 days to it, skipping over Sunday (if needed) and print the result date in another cell.
|
| Updating links to Password protected files | 21 Oct 2006 18:53 GMT | 1 |
I have a Password-to-open protected file. I paste-link 3 separate selections of data into three files which are used by three subordinates. When they need to update the links they are asked for the password to the "Master" file. Is there any way to let them have the updates ...
|
| euro millions | 21 Oct 2006 17:49 GMT | 2 |
hello peeps, i'm trying to make a euro millions checker in excel, ive got it to check the five balls ok but having problems with checking the 2 lucky stars cell g4 = 3 ( lucky star 1 camerlots No.) cell h4 = 6 ( lucky star 2 camerlots No.)
|
| My Documents include Excel & Word | 21 Oct 2006 17:25 GMT | 3 |
I would prefer to have separate folders for Excel & Word. Is this possible, advisable or not advisable & how do I do this?
 Signature Sadie
|
| Can my xls remain protected even if someone paste it to a new work | 21 Oct 2006 17:03 GMT | 1 |
Excell 2003 I protect my workbook with a password but when i copy and paste it to a new file becomes unprotected. I want to know if there is a way my work to be protected always.
|
| Results from blank linked cells | 21 Oct 2006 15:08 GMT | 2 |
I am linking cells from different worksheets in the same workbook, using the copy/paste/link cell method. How can I get a blank space (as opposed to the zero I am presently getting), in the destination, if the source cell is blank. I am linking a input sheet to several forms ...
|
| Combobox/data validation | 21 Oct 2006 13:55 GMT | 1 |
I have a combobox that I need to pick up a list which is determined by another combobox. i.e combobox1 is criteria A, I then need all the data in another sheet that one column matches this criteria to be available in combobox2. I have too many records to manually sort and is not ...
|
| Joining Spreadsheets | 21 Oct 2006 11:30 GMT | 1 |
Is there a way of joining two spreadsheets with similar information on them e.g. I have one workbook with students id and student name another workbook with student name and some results.
|
| I need a Macro that will open workbooks and run a different Macro. | 21 Oct 2006 06:28 GMT | 8 |
Is there a way for a macro to open all workbooks in a folder and then run another macro? I have the 'other macro' written already, I just need a macro that will open 200 spreadsheets - (they are not in the same folder but I can move them if
|
| Show grid lines when printing? | 21 Oct 2006 03:52 GMT | 4 |
I have a few exported reports from Access but I cant get the Grid lines to print. How do I go about this? I have colums but no gridlines. Please help!
|