| Thread | Last Post | Replies |
|
| Aged Debt - grouping values by date range | 18 Dec 2007 16:39 GMT | 2 |
I have a range of values with corresponding dates. I want to group and total values by date range. Effectively I'm trying to produce an aged debt summary.
|
| Create daily plan in Excel for tasks of weekly, monthly frequency | 18 Dec 2007 15:54 GMT | 2 |
I have tasks that need to be completed at weekly, monthly, quarterly etc frequencies foreach of my industrial machines. How can I create a daily list of such tasks for the guidance of my technicians
|
| Graphing time (In weeks) | 18 Dec 2007 15:51 GMT | 2 |
I have a graph of time (Weeks) along the X-Axis and settlement (mm) along the Y- Axis. A unit along the X -Axis would be say 21/10-28/10/06, this is the 21st of Octoeber to the 28 of Octoeber 2006, which represents a week. The next point is the 28/10/-28/11/06, this is the 28 of ...
|
| formula request.... | 18 Dec 2007 15:48 GMT | 1 |
...for a total column to show when a number is less than previous i.e: 1951 previous 1912 latest 39.46 total (but want this to show as minus in brackets (39.46)?
|
| removing first character in cell | 18 Dec 2007 15:46 GMT | 2 |
Hi I have acolumn and i need to remove the first charatcter of each cell in this column. is there an easy way to to do this please? A
|
| Retrieving Overwritten Excel File | 18 Dec 2007 15:19 GMT | 3 |
I accidentally overwrote a file after I had entered new partial data in to it. Is there a way to retrieve the original file without the overwrites? Thanks.
|
| start Word and Mail Merge the data from excel,system will restart | 18 Dec 2007 15:15 GMT | 2 |
customer PC having Mail Merge cause the System to reboot. Problem: When she run the Membership program on reminder, the program will export the data to Excel, they will start Word and Mail Merge the data from Excel.
|
| Open file from address in a cell | 18 Dec 2007 15:01 GMT | 1 |
Let's say that the value of cell A1 was "C:\Work Documents\David's Folder\Schedule.xls" and I wanted to click a button to run a macro that open's the file referenced in A1. Is that possible and if so how can it be done?
|
| Totals and #Value! | 18 Dec 2007 14:58 GMT | 2 |
I think this ia a very straightforward question. I have a column of the number of items sold, each month a new column is added. at the bottom of each column is a grand total for the month in the form of
|
| Signature in Excel | 18 Dec 2007 14:47 GMT | 2 |
I have to fill out my hours on Excel which has Macros in it.(I did not create the form - work did) anyway there is a section to sign my name. To do this i have to print the form off, sign it then rescan the form back in and email to my company. i can scan the signature onto my PC ...
|
| Simplifying statistical spreadsheets | 18 Dec 2007 14:47 GMT | 5 |
Please can you provide me with some ideas. I am trying to create a spreadsheet which shows the throughput of a team of 7 people and calculates weekly and monthly totals keeping manual input to a minimum. We deal with 25 different types of tasks on the team and what I need to do
|
| Is there a maximum of the number of worksheets in a workbook? | 18 Dec 2007 14:46 GMT | 6 |
I want to make worksheets for the entire yr of 2007 in a workbook by doing it weekly. How many worksheets are allowed in a workbook or is it indefinate?
|
| hyperlink font | 18 Dec 2007 14:42 GMT | 1 |
when i give hyperlink to a text in a cell, font of that text xhanges but i want entire file in same font, how can i change a font of hyperlinked text? does anybody can help me? thanks..
|
| VLOOKUP | 18 Dec 2007 14:33 GMT | 1 |
I am building a spreadsheet to detail work assignments. Each person could have a primary, secondary, and/or tertiary assignment. I want a summary sheet in the workbook which will pull in everyone assigned to a certain task.
|
| Import into excel 2003 from Peachtree 2004 | 18 Dec 2007 14:32 GMT | 3 |
How do I import from Peachtree Complete Accounting 2004 into excel 2003 The excel button in Peachtree is not highlighted even though it is supposed to be supported by excel 97 and later
|