| Thread | Last Post | Replies |
|
| Time conversion & adding | 29 May 2008 13:00 GMT | 5 |
Hi there, I have a stats sheet that records how many minutes a basketball player plays during a game. This same sheet also tracks each game, so I have a column that shows playing time for numerous games:
|
| How to create a form on one sheet that enters data into another | 29 May 2008 12:58 GMT | 4 |
Hi - new to VBE & macros, otherwise comfortable with Excel. I'd like to create a form on sheet1, which will resemble a paper form that is used to gather info. I'd like for this info to be entered into a row on sheet2, and eventually have some totals and other summary info ...
|
| how do i draw up a table to do my own 5 generation dog pedigree | 29 May 2008 12:32 GMT | 1 |
i need to draw up a 5 generation dog pedigree and i cant do it.does anyone know how i would do this by knowing what one looks like in the first place?
|
| Converting comments attached to cells into data | 29 May 2008 11:30 GMT | 2 |
I thought I'd try again to get an answer to this problem. I have a spreadsheet set up and in one particular column, each cell has a comment attached. Is there some way that I create a new column and copy each of those comments into the cells so that they become part of the data ...
|
| Converting comments to data | 29 May 2008 11:25 GMT | 5 |
I have a basic spreadsheet set up and in one particular column, each cell has a comment attached. Is there some way that I create a new column and copy each of those comments into the cells so that they become part of the data in the spreadsheet? I don't want to cut and paste ...
|
| Automatically Highlight every 22nd row | 29 May 2008 10:37 GMT | 2 |
I have a sheet of over 750 rows of data and need to pick out every 22nd row for an audit. Is there a way to get Excel to highlight every 22nd row in steed of manually counting every 22 row and highlighting Thanks,
|
| averaging formula from three cells | 29 May 2008 10:03 GMT | 2 |
i must make a formula to average a column of numbers but only the numbers which are narrowed down from two other columns. for example: Production Calendar (sheet 1)
|
| Search and Replace Entire Cell Content | 29 May 2008 09:37 GMT | 4 |
I want to search for text within a cell, and if that text is found anywhere within that cell, replace the entire cell with a given text string
 Signature JerryG
|
| character map | 29 May 2008 09:27 GMT | 1 |
I have a spreadsheet that has tick boxes in them that I cant delete or cut. Please can anyone tell me how to do this and they are no longer required.
|
| Fill repeating Numbers | 29 May 2008 09:27 GMT | 8 |
Is there a way to fill a repeating set of numbers. I have students listed by their daily schedule. 1st period - 8th period. I want to create a period column and have it fill in 1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8 all the way down the column to the last student. I ...
|
| how can you let macro determine to where to copy | 29 May 2008 08:15 GMT | 1 |
I've got several sheets with the same info but in a different layout in columns. The column headers are identical. The sheets have a different number of rows.
|
| count text appear how many times & put in respec col??eg 1st times | 29 May 2008 07:53 GMT | 3 |
Need to found out the text eg Movie appeared how many times in a worksheet. If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc
|
| IF blank!! | 29 May 2008 06:03 GMT | 9 |
I have an IF statement which I want to identify if it has a blank cell or not. So I do one formula if it is empty and one if it has a value I have managed to do it with multiple columns using =istext but I want the formula all in one cell. I have tried if cell=null and variations ...
|
| Limit on number of comments in a worksheet | 29 May 2008 06:02 GMT | 2 |
Good day! I've written a macro that validates the cell values in a worksheet, and writes the error messages as comments in each cell. The problem I'm having is that if there are too many rows (at least 2000) and too many errors, writing
|
| Need magic Excel formula for Date calculation | 29 May 2008 05:08 GMT | 2 |
Problem: Need to determine the total number of days to process a product, including the number of days each section took to do their part. Column "D" is actually one cell providing a SUM of C1:C4.
|