| Thread | Last Post | Replies |
|
| Finding the right kind of tmplate | 01 Apr 2004 00:57 GMT | 3 |
I am trying to find a template that will allow me to schedule multiple employees on one schedule, on a biweekly basis that will caculate the hours for me. The only must is that it has to handle at least 13 employee, ahow scheduled work times and calculate the reg. time, over time ...
|
| selection of fields from Excel based on color and outputting the selected fields to new excel sheet | 01 Apr 2004 00:54 GMT | 1 |
i need to write a visual basic program to perform the analysis of Excel price list to analyze the line and column headings and copy them along with the prices into a sheet . the program should react to the colors as shown .
|
| Creating a front to link all worksheets in a workbook. | 01 Apr 2004 00:51 GMT | 1 |
I have created a workbook with several genealogy related worksheets in it. Each worksheet represents information on a different type of genealogy source. What I want to do is to create a home page like environment where I could place a link to each type of data worksheet. In ...
|
| One worksheet through mail | 01 Apr 2004 00:42 GMT | 8 |
I had a excel file containing 5 worksheets. I need to send someone only the 2nd worksheet through e-mail. How can i send it? Please suggest.
|
| password protection | 01 Apr 2004 00:18 GMT | 4 |
I have passworded one of my spreadsheets but i cannot remember the password on this so i cannot edit it anymore is there a way around this?
|
| Macro - File Save As | 01 Apr 2004 00:03 GMT | 1 |
I made a button at the end of a form. The button should save th workbook named for a unique identifier in a cell contained within th workbook...MACRO HELP If I could just record, it would be save as = to cell $b$14...but i
|
| Adding Numbers on 1 Column based on the Value of another Column | 31 Mar 2004 23:34 GMT | 3 |
Hey Everyone, I am creating a budget sheet for myself. One of the columns is "credit" or "debit" and another column is the amount. What I am looking to do is tally up all the credits and all the debits in 2 separate cells. What is the best
|
| Sorting text-compiled on master sheet | 31 Mar 2004 23:17 GMT | 1 |
I would like to sort some text from several other sheets onto a maste sheet. For Example: Multiple sheets, Column B and C (which might contain several differen entries and duplicates) like:
|
| first workday of a time period | 31 Mar 2004 20:21 GMT | 2 |
Hi I need some help writing some formulas to produce the date of the firs workday in four different time periods. In cell A1 i have today's date =TODAY(),and the four formulas that
|
| [Newbie] time to minutes conversion | 31 Mar 2004 20:12 GMT | 3 |
here is my problem : I've got a field that contains a time in the format hh:mm (by example 01:30) for one hour and a half. I would like to make a calculation with this (a cost, knowing the price for an hour) so I need a macro that converts 01:30 in a decimal format (01:30
|
| Need help creating reports | 31 Mar 2004 19:57 GMT | 1 |
I am working on a temporary job for a company that is tracking it's employee training. Each row in my spreadsheet has the area director's name, the employee first name, the employee last name, the class code, class description, start date, end date, and some other colums as well.
|
| Need to sort large number of data | 31 Mar 2004 18:52 GMT | 1 |
I need to sort the data which are in 15 column and 1000 rows , the data should be sorted accroding to the minimum difference between of 0.09 one rows of data to another set of data also while sorting it should assign the original idetity of data which
|
| Can't edit cells in my rectangle | 31 Mar 2004 18:33 GMT | 3 |
I have an old spreadsheet with several rectangles on it. The rectangles are "hollw", in that I can edit cells inside them. I can copy those rectangles and edit them to make new ones. But if I create a new one from the Drawing toolbar, the cells inside are inaccessible. Instead, ...
|
| list direct debit info if entered > 12 times | 31 Mar 2004 16:38 GMT | 1 |
Excel query I have a spread sheet that list monthly direct debits per person. The spreadsheet is cumulative, so the same name will appear more than once. My query is, is it possible to create a report or list that will flag up a
|
| formula results into zero | 31 Mar 2004 16:00 GMT | 3 |
My officemate has experienced the following: When she adds two cells, the result shown in the cell is zero. But when you press F2 you can see the correct result. What is the cause of this? Even changing the cell format does not
|