| Thread | Last Post | Replies |
|
| Macro Help for Saving a file | 12 May 2006 17:16 GMT | 3 |
Anyone, and everyone I have a macro to save my spreadsheet. (I am saving it several times with diffrent names based on the data the macro pulls) The code is as follows:
|
| Several worksheet tally by name | 12 May 2006 17:03 GMT | 1 |
I have a worksheet that has several layers: Tardy, Absent, Jan, Feb, Mar, Apr etc., etc. I have the employees listed on the first two with a reference of their initials:
|
| Adding Text from seperate columns | 12 May 2006 16:49 GMT | 2 |
I have delimited a column of data that had a list of peoples names including their title to several columns. Unfortunately the format was not uniform in the column so some included their first and middle initials and they either separated it by a space or a period - so some
|
| Help - Auto update from multiple spreadsheets | 12 May 2006 16:49 GMT | 5 |
Problem: I have multiple tabs in one spreadsheet that get updated by many different people. Current methodology: I send the spreadsheet out to people, they each update their tabs and send it back to me. I then open each spreadsheet that is
|
| big list of values to averaged smaller list? | 12 May 2006 16:36 GMT | 3 |
Hi, I just can't figure out how to do this so I'm hoping someone could give me a little help. I have a big list of measurements taken every 10 minutes. Column A has the date/time
|
| Merging 2 cells together and prefixing | 12 May 2006 16:27 GMT | 7 |
I hope someone can please help me with a problem that I have as shown below:- OK, I have a telephone number which is split into two separate cells. The first cell is the dialling code (STD code) and the second cell is
|
| Macro command control by date | 12 May 2006 16:26 GMT | 2 |
I am using macro command (button) to access next worksheet or workbook. It is possible or not if I want set command can be access by date. e.g after this date (10 May 2006) the command not working or access denied. TQ
|
| Most Current Date | 12 May 2006 16:18 GMT | 4 |
I have a worksheet that I keep track of quotes submitted. I have columns: Customer, Submit Date, Award Date, Price Quoted, and Won/Lost. I have another worksheet that is linked that keeps a cumulative total of the quotes that are lost. On that worksheet I have Last Award Date, ...
|
| excel export | 12 May 2006 16:08 GMT | 1 |
why can't I see the commas in my .csv file?
|
| INDEX / MATCH problem | 12 May 2006 16:03 GMT | 9 |
Sheet 1 has 3 columns: grade, step, NBS Sheet 2 has 3 columns: SM, grade, step I want to add a column NBS to sheet 2 for that exact grade and step, from the data on sheet 1.
|
| How do I calculate the midpoint date between two dates. | 12 May 2006 15:49 GMT | 3 |
Can anyone help! I have August 2006 (start) and August 2008 (end). I need the midpoint between those two months and provided in QTR-YR.
|
| Ascribing Values to Symbols | 12 May 2006 15:44 GMT | 1 |
Am seeking assistance. How would I go about ascribing a value to a symbol in Excel? For example if I wished to use ticks and crosses from WingDings and have them represent a 1 and Zero value respectively so that they could be used with basic formulas.
|
| Results of conditional formatting not what desired. How do I corr | 12 May 2006 15:18 GMT | 8 |
My formula produces a dd-mmm-yyyy result which is correct. Cell L55 formula results are: 17-May-2006 Conditional formatting is set to: Formula is: =L55<=TODAY() With background pattern set to red.
|
| How to select automaticly the last cell not empty of a area? | 12 May 2006 14:50 GMT | 1 |
I don't find how to find automaticly my last data (non blank cell) inside a table thanks
|
| Linking 2 workbooks | 12 May 2006 14:48 GMT | 11 |
How do you link a cell to another cell in a different workbook? for example: Book1 Sheet1 cell A1 to Book2 Sheet2 cell A2
|