| Thread | Last Post | Replies |
|
| Extract some fields from a Row to a column | 23 Sep 2004 06:27 GMT | 1 |
Hi! Apreciate your help in advance. This is my problem I have a Database w/ four columns but in my firs column starts row A, Co. Name, RowB Address, Row C Phone #. I
|
| Grade Book | 23 Sep 2004 00:46 GMT | 1 |
I am looking for a grade book template any one know where I can get one?
 Signature Andrew C. Cooper Who Would Al-Qaida Vote For?
|
| Outputting from HTML to excel? | 22 Sep 2004 22:59 GMT | 2 |
I would like to use the output from html forms and gather it in excel can anyone tell me how easy this is? Rob
|
| Remove space | 22 Sep 2004 22:42 GMT | 3 |
I have: Sub TRIM_EXTRA_SPACES() Dim cell As Range For Each cell In Selection
|
| Calculate a Percentage | 22 Sep 2004 22:27 GMT | 2 |
I know this is probably a silly ? but I'm a newbe. I have 3 fields #1 Total Costs #2 Total Sales #3 Profit
|
| Highlighting duplicate entries | 22 Sep 2004 22:22 GMT | 1 |
I'm trying to highlight duplicate entries in a column. Right now, I'm using the formula found at http://www.cpearson.com/excel/duplicat.htm, which works as follows: My column has a column name in the first row (set to PartID). What I'm doing
|
| Another Macro Problem! (dave where are you!) | 22 Sep 2004 22:06 GMT | 1 |
Okay, You guys have helped me in the past, and I need you again. I am using Excel 2000. I have a worksheet that I saved as a template. The user opens the template
|
| Vlookup to retrive HOW CAN I UPDATE | 22 Sep 2004 21:47 GMT | 1 |
Background - Three worksheets (COVER, LOOKUP and LOG) are in sam workbook (file). COVER worksheet has area (in column format) that I put in info and marco inserts a row, copies and pastes this info onto the LOG shee
|
| Set Focus | 22 Sep 2004 21:43 GMT | 1 |
I am using the Worksheet_SelectionChanged event to show a ComboBox on the selected cell so the user could select an item from the list, note that using datan validation didn't work because the worksheet zoom factor is 60%.
|
| Can you have a static file location in a formula? | 22 Sep 2004 21:13 GMT | 1 |
I would like to have a static file location that does not change if email the workbook to somebody. Is this possible? Here is an example of what I would like to do. =IF(L8=TRUE,'C:\Documents\Football\Week 3\[Pool Score Sheet.xls]Scorin
|
| COPY FROM SEARCH | 22 Sep 2004 21:11 GMT | 1 |
BY INTERNET DO YOU MEAN INTERNET EXPLORER OR WINDOWS EXPLORER? I KNOW THAT I CAN COPY AND PASTE ANYTHING FROM THE INTERNET BUT I WANT TO COPY A LIST OF FILES AND PASTE IT INTO EXCEL. THANKS.
|
| COPY FROM SEARCH NEW | 22 Sep 2004 20:54 GMT | 3 |
MAYBE MY QUESTION WAS CONFUSING BUT I DON'T WANT TO COPY FROM INTERNET EXPLORER BUT RATHER FROM WINDOWS EXPLORER (MY COMPUTER). IS THIS POSSIBLE. IF YOU CAN'T COPY AND PASTE TO EXCEL, CAN YOU PRINT THE LIST OF FILES?
|
| Workbook Open Event | 22 Sep 2004 20:22 GMT | 1 |
Upon opening a workbook i want to do a check to see whether the date i cell A1 in Sheet1 is equal to today. If it isn't equal then display a msg box saying that the "index price are out of date please update".
|
| Copy columns into rows | 22 Sep 2004 20:18 GMT | 3 |
Can anyone advise me how to copy columns of contiguous cells, into a much easier to read row of contiguous cells?
|
| Searching cells for hard coded data vs formulas | 22 Sep 2004 19:08 GMT | 1 |
Can anyone tell me how to define a Find query in cell which will fin all the cells in a sheet which have constants in them (i.e. =2, 2, A2+ etc). That is, I want to build an audit function which checks cells t make sure there are not any hard coded constants in any cells. Th
|