| Thread | Last Post | Replies |
|
| Converting time from text to numeric | 21 Mar 2008 19:56 GMT | 4 |
I have a column of time logs ranging from: 1:00:00:00 to 0:01
|
| How do I pull certain data out of spreadsheet and import into another? | 21 Mar 2008 19:12 GMT | 5 |
I am attempting to pull data that meets certain criteria out of spreadsheet and have it imported into a blank spreadsheet. I have 5,000 records in Excel 2003 with fields for the Company Name Address, City, State, and Zip.
|
| How do you have the cells highlight changes? (no track changes) | 21 Mar 2008 18:29 GMT | 1 |
I have a speadsheet that will require many people to review and make changes to it. I need to be able to know what those changes are. Without using track changes, is there a way to format the cells in such a way that will either highlight the cell and/or change the font color ...
|
| Compare Col A and Col M, if Match, Copy Col N to Col E | 21 Mar 2008 17:57 GMT | 1 |
I'm trying to get this macro to compare values in Column A and Column M, starting in Cell(2, 13), and if there is a match, copy the value from Column N (that corresponds to Column M) into Column E. For instance, 4/1/2008 is in Cell A1 (and the dates go down consecutively). I ...
|
| macro for inventory/shipping labels | 21 Mar 2008 17:56 GMT | 1 |
I have seen alot of posts for address labels & mail merge (which I have been frantically using), but I have been trying to (unsucessfully) merge inventory descriptions and amounts to make inventory labels. Any help would be appreciated.
|
| return maximum text "value" | 21 Mar 2008 16:24 GMT | 1 |
Is there a function to get in a cell the maximum text "value" of a list (e.g. T1, T2a, T2b). Like MAX for numbers, part of this functionality is embedded in the sort/filter commando's.
|
| macros with functions | 21 Mar 2008 15:00 GMT | 3 |
I am using excel 2000. I have created a macro that will clear my "Invoice" and post pertinent information to the first row of an "Invoice Log" that I have created in the same workbook, but on another tab. I would like to have the macro do a "VLOOKUP"? or some other function to ...
|
| Solver problem | 21 Mar 2008 10:05 GMT | 4 |
Hi, I am playing with learning solver and using a test case that I found I think on the MS Site A company produces Radios, CD Players and Speakers. These products are made from common parts: speaker cones, power supplies, electronics, laser parts
|
| Divide month into two payroll periods | 21 Mar 2008 08:06 GMT | 5 |
I am trying to display rows by pay period. The dates would be from the 1st to the 15th or 16th to the end of the month. I am using a calendar control to select the start date. The calendar control inserts the pay period start date into A11. Then
|
| MS Excel Data Validation, Ignore Blanks in List | 21 Mar 2008 03:44 GMT | 4 |
I have a problem utilizing the Data Validation tool in Excel. If I have a list in one column with the following, for example: ----------------- Dog
|
| How do I sort the whole row at once in Excel? | 21 Mar 2008 03:30 GMT | 2 |
Here's what I have. I have a document used to record and track dog licenses in my city. There are 11 columns in the document. One column contains numbers as currency (not set up as text). I want to sort the document in two ways. I want to be able to sort so they are listed ...
|
| Complicated lookup/match formula help needed! | 21 Mar 2008 01:39 GMT | 2 |
Hi-- I have a sheet called "ClientList" where column A has a list of ID numbers. In another sheet called "Clinicians", these ID numbers are in columns BA:BJ. There is other information (for example # visits
|
| TIME SHEET | 21 Mar 2008 01:29 GMT | 1 |
Can anybody help me out to manually create a time sheet using the cells to calculate the time? I any samples, I greatly appreciate it. Thanks
|
| Julian date - find next highest date/number | 21 Mar 2008 00:38 GMT | 1 |
Hello, I need a quick answer, i have cells with dates as numbers next to a number as below: A B
|
| Blank Row | 20 Mar 2008 23:23 GMT | 9 |
I need to paste data from one worksheet into another. The copying of the data is not the issue. How do I determine the location of the first blank cell in a Column A to paste the data?
|