| Thread | Last Post | Replies |
|
| Monthly Expindature | 29 Jun 2007 21:49 GMT | 1 |
Hi I download Bank statement every month. I want to know if there are withdraws 4 times a month it should show me 1 withdrawl and total , same if i make deposits it should show me deposit only once
|
| viewing problem in Excel | 29 Jun 2007 21:31 GMT | 1 |
I work with spreadsheets at work and I have a problem with viewing the templates that are set up. There are certain cells that are shaded Grey which I Tab through to enter data but the Grey isn't showing whilst I need to enter the data but when I enter print preview all the ...
|
| formula rather than result displayed | 29 Jun 2007 20:50 GMT | 3 |
I am adding formulas to a spreadsheet that was downloaded from another program (each cell appears to be a text formatted cell) but rather than the formula result being displayed the formula is being displayed. I've done the CTL+~ and also the Tools|Options|View methods
|
| Conditional Formatting Excel 2007 | 29 Jun 2007 18:19 GMT | 2 |
Part 1 I have a series of variable numbers in Columns B, C and D (approx 100). I want to be able to shade cells in both cols B and C when the value in the Col C cell is greater than the value in the corresponding Col B cell.
|
| Variable in Object Name | 29 Jun 2007 17:58 GMT | 2 |
Good morning all, I have some code that uses a variable in a object name. Actually, it doesn't use it yet, but I'd like it to. I have the following code that I've tried in several different variations, but I
|
| convert one field into two | 29 Jun 2007 15:56 GMT | 1 |
I have a name field with a first name and lat name in it. I'd like to create two new fields and convert it to be first name and last name individually. is there a way to do this w/o having to do it manually? thank you!
|
| How to copy from one worksheet to another | 29 Jun 2007 15:11 GMT | 1 |
I have a worksheet that contains several worksheets. I would like to get the information on tab Sheet 1 and copy cells (A2:O2) in a tab name Sheet 2. Can someone share the code to do that ? Or inform me where can I go to
|
| How to copy from one worksheet to another | 29 Jun 2007 14:08 GMT | 1 |
I have a worksheet that contains several worksheets. I would like to get the information on tab Sheet 1 and copy cells (A2:O2) in a tab name Sheet 2. Can someone share the code to do that ? Or inform me where can I go to
|
| Formula to enter month and year in workbook | 29 Jun 2007 11:44 GMT | 12 |
I have a yearly workbook with 12 sheets, one per month. Each sheet has a header cell (assume A1) that shows the month and year for that specific sheet. Assuming I manually enter (for example) 'April 2007' in the month/year cell
|
| Stop opening multiple versions of Excel when click on xls files | 29 Jun 2007 11:42 GMT | 8 |
Excel 2002 SP3 Win XP HE Hi, If I click on an xls file in Windows Explorer, it properly starts Excel
|
| show time difference | 29 Jun 2007 11:31 GMT | 5 |
i would like to create a spread sheet that would show a time difference between two cells ie time due actual time if late 04:00 04:05 ?
|
| colour cell according to if criteria met | 29 Jun 2007 09:00 GMT | 2 |
HI Is it possible to highlight the colour of a cell dependent upon it meeting certain criteria. I want to show all cells which are greater than 0 as green and those less than 0 as red. Is this possible? All help appreciated.
|
| Help comparing data in 2 columns and finding same data in both | 29 Jun 2007 08:18 GMT | 21 |
I have a 2 column spreadsheet with numerical data in each column. I need to compare columns and note which numbers are in both columns (preferably in a third column) example:
|
| dudas excel | 29 Jun 2007 07:11 GMT | 2 |
Como se seleccionan las celdas
|
| Custom format macro? | 29 Jun 2007 07:10 GMT | 8 |
Can I write a macro to format a number? I have a bunch of cells containing time intervals stored as floating point numbers in units of days. These are not dates, but are stored in the same format. Some examples:
|