| Thread | Last Post | Replies |
|
| replacing value in formula from outside worksheet? | 24 Mar 2008 23:17 GMT | 4 |
We know we can start up a spreadsheet from the command prompt: excel <spreadsheetname>. We've seen batch files which allow one to specify a replacable parameter in the batchfile from the command line. I'm trying to do
|
| when i press TAB key in an excel sheet nothing happens? | 24 Mar 2008 22:49 GMT | 3 |
this was a sheet that was sent to me so i dont know what settings were played with. it is Quite annoying as the TAB doesnt move to the next cell like usual i know how to change the way ENTER behaves but cannot find a setting for the
|
| change cellpointer | 24 Mar 2008 22:38 GMT | 1 |
how can one change the standard cellpointer cross of a spreadsheet to an arrow that remains an arrow everywhere in the spreadsheet
|
| Change Formula on Multiple Workbooks | 24 Mar 2008 22:33 GMT | 3 |
Here is the macro that I have and have used to change a test folder with test workbooks. Not all of the sheets have the same same but they are all sheet1. Can you help me amend this to have it go to sheet1 of each workbook?
|
| How do I get date/time to wrap (format - wrap text doesn't work)? | 24 Mar 2008 22:09 GMT | 2 |
I have cells in the format of date and time with 2 spaces between the date and time. I want to wrap them so that the date is on top, and time on bottom, but they will not wrap. The only thing I can do is individually enter "alt+enter" for each cell. Any suggestions?
|
| Dynamic Range Name Macro | 24 Mar 2008 22:04 GMT | 3 |
Learning from this comunity, I am using dynamic range names when importing data through our ODBC connection, and then creating a pivot table that uses the range name. I works great. In fact, I create new applications like this frequently; so much so that I've created a macro to ...
|
| Importing Data | 24 Mar 2008 21:43 GMT | 1 |
I'm importing data into excel my question is two fold. I'd like the data points to start at 0, and I would also like to be able to retain the format I was using while importing a new series of data (e.g. I import data make it look the way I want crunch numbers what ever, then I ...
|
| Multiple Bars | 24 Mar 2008 21:23 GMT | 1 |
I have some charts using the data below. I want to have one column showing four (4) colors on top of each other for critical; high; medium and low. Can do Jun-07 Critical High Medium Low Unknown TOTAL CRs Created TOTAL CRs Closed
|
| MINIF? Like SUMIF and COUNTIF | 24 Mar 2008 21:12 GMT | 3 |
Is there a function that would behave similarly to the SUMIF and COUNTIF functions to find the minimum value in Column B where Column A equals a specified value?
|
| Need help with rounding | 24 Mar 2008 20:57 GMT | 4 |
I have a rounding question. i need to do the following: Round: $#.00 - $#.09 round up to $#.09 $#.10 - $#.49 round up to $#.49
|
| Capture user ID... | 24 Mar 2008 20:20 GMT | 2 |
Is it possible to capture the user ID for anyone that accesses or edits an Excel file? Or is it possible to setup a sheet with multiple user passwords?
|
| Copying formulas with relative references | 24 Mar 2008 20:00 GMT | 2 |
I want to copy a formula to multiple worksheets with part of the formula referencing the value of a cell in the previous worksheet without having to manually change the worksheet name in the formula each time I paste it. Is there a way that excel will automatically reference the ...
|
| Formulas - Skipping Cells | 24 Mar 2008 19:51 GMT | 1 |
Not sure if this is possible... my boss wants to create a spreadsheet that will calculate a couple of cells.... but skipping some .... is this possible?? If so....can you help?? :):):) Thanks
|
| Charts in Excel 2003 spreadsheet seem to be shrunken down when vie | 24 Mar 2008 19:47 GMT | 2 |
Charts in Excel 2003 spreadsheet seem to be shrunken down when viewed. For example on machine x52870 the charts appear shrunken and are not clearly visible. On device x61897 the charts are as they should be. User has not checked versions or revisions as a possible reason for ...
|
| Creating a Fill In form that populates a table | 24 Mar 2008 19:22 GMT | 1 |
Hi, I am trying to create a front end user form that then poplulates into the columns on the next tab with a macro. I can get the macro to take the first line of data over to the next tab, but
|