| Thread | Last Post | Replies |
|
| Transfer of Data Between Sheets | 21 Feb 2007 23:53 GMT | 1 |
Hi All. I hope I can explain this clearly. Here is what I would like to do: I have created a large worksheet that contains, in part, all the projects I'm doing for different departments. Say, for example, I get
|
| How do I increase a spread sheet by 10% | 21 Feb 2007 22:47 GMT | 1 |
I Am doing a spread sheet, I have completed it they are for four years - I need to increase the last three years each by 10% - anyone know what I do or the formular? Thanks
|
| VLOOKUP formula searching multiple worksheets ?? | 21 Feb 2007 22:05 GMT | 8 |
Does anyone know how to search for info from multiple Excel worksheets using the VLOOOKUP formula or any other formula. I have my VLOOKUP formula(column B) and list of values(column A) (sorted in ascending order) on Worksheet 7 and I need to search for
|
| Adding subtitles to chart title | 21 Feb 2007 20:18 GMT | 1 |
I am trying to add a subtitle centered below the title on a pie chart in Excel. How do I do this?
|
| How to calculate age from today's date? | 21 Feb 2007 19:37 GMT | 6 |
Using =TODAY() in O1 cell, how do I calculate ages based on birthdates? Thank you.
|
| How many rows are occupied by data: How to find that? | 21 Feb 2007 19:08 GMT | 3 |
I am using Excel automation in my vbasic project. I wonder whether there is a workbook (or worksheet) property returning number of rows occupied by data. If not, what will be the best method to find that number?
|
| time-stamp | 21 Feb 2007 18:36 GMT | 2 |
Anyway that I can quickly input data into an excel worksheet and have a timestamp? Ex. Input data in A1--->ENTER-->and have a timestamp record when that data was input into A1 (put the time I in cell B1)...and repeat.
|
| Some questions about Borders in Excel 2007 | 21 Feb 2007 18:16 GMT | 1 |
1. Is it possible in some way to "undock" the borders button from the ribbon, similar to how I was able to do in Excel 2003? 2.. Is there a way to create my prest border button (for example, I'd like a group of cells to have thin internal borders but a thick line
|
| Extracting Data To New Worksheet | 21 Feb 2007 17:53 GMT | 1 |
I am attempting to filter a large data source to a new worksheet without much success. I want to filter the data by multiple paramenters. I have built a Macro that sorts the data by value and then pastes in the new
|
| How to Filter two alternative Column in the excel sheet | 21 Feb 2007 17:28 GMT | 6 |
I am trying to filter two columns in the excel sheet.But it is not allowing me to filter it.So please advice.
|
| hyperlinks and email addresses as links from CSV | 21 Feb 2007 16:35 GMT | 10 |
I have a program that outputs a CSV file. The contents include fields with hyperlinks and email addresses. However, when I open the file in Excel, neither the hyperlinks or email addresses are active links you can click on. I tried adding "mailto:" in front of the
|
| Who can help me with a VBA | 21 Feb 2007 16:21 GMT | 7 |
Who can make a VBA code for me??? I have an sheet called "insertsheet", in cell B8 people can fill in 1 till 10 with validation. In a other sheet called "Dataprocessing" I want row 23 is visible when
|
| Referring to other worksheets... | 21 Feb 2007 15:28 GMT | 2 |
I have a feeling that I’m making this overly complicated. I know I could use a Constant, but I’m trying to avoid that. Each month a report forecasts out 30, 60, and 90 days - Feb07, Mar07, Apr07, etc. There are tabs for each month labeled “Feb07 Rel”, “Mar07 Rel”, etc.
|
| Automatically move row from one tab to another.. | 21 Feb 2007 15:13 GMT | 2 |
He there, I have a question. I'm working on a salessheet. The first tab is a summary of al offers I make to the customers. For every offer I have the option of giving them a status: Pending,
|
| Countif and Time fields | 21 Feb 2007 15:00 GMT | 3 |
I have a list of times. The column is formated for "Time 13:00" format and it is calculated from two other fields. The calculation to create this time is correct and the format is correct. I want to be able to count the # of times that a time is listed between two
|