| Thread | Last Post | Replies |
|
| Excel 2003 - VBA - Vlookup generation | 20 Dec 2007 14:41 GMT | 4 |
Today just doesn't look like it is going to be MY Day. It seems that I am leaning on this group heavily today, so thanks alot! This is what I have and what I need: Column 1 is the Key name to look up.
|
| Changing worksheet name within a formula (automatically) | 20 Dec 2007 14:37 GMT | 5 |
Hello please help, I have a summary worksheet with a formula taking data from another worksheet. Simply ='worksheet'!G34. At certain times of year I have to change the worksheet name to equal the current period in all of the cells in the
|
| Checkbox to Bold Adjacent Cell | 20 Dec 2007 13:39 GMT | 2 |
I have 4 sets of 6 Checkboxes adjacent to text items across the page for a total of 24 items. When a box (A7) is checked I want the text (B7) to become BOLD. I have the checkbox A7 linked to itself A7 and font and background the
|
| File path listing and analysis | 20 Dec 2007 13:36 GMT | 3 |
I have two main folders with many sub-folders and files, one has to be combined into the other ensuring that the most up to date file is adopted whenever appropriate. In order to do this I thought the best way would be to down load or transfer complete filepaths and certain file ...
|
| Excel Macro | 20 Dec 2007 12:47 GMT | 10 |
I have written a macro that hides several rows on a spreadsheet. The problem is that when I insert rows above those that are to be hidden as a part of the macro, the row numbers in Visual Basic do not change, thereby the incorrect rows are hidden.
|
| Sales analysis and projection for pharmaceuticals | 20 Dec 2007 12:42 GMT | 1 |
I have 12 months sales data, product-wise. I need to project sales at least for the next 3 months. Is there any formula available. K.Ganapathy
|
| Stop UK-style dates changing to US-style dates when mailmerging. | 20 Dec 2007 12:35 GMT | 1 |
Using Office 2007. When I use Excel as the database and mailmerge in Word, all my UK-style dates (eg 25/04/2003) change to US-style (eg 04/25/2003). Does anyone know, please, what can I do to format the dates, either in Excel or Word, to ensure they keep the UK format?
|
| text with a numeric funtion | 20 Dec 2007 12:11 GMT | 2 |
I am very new to xl and am trying to create invoices for my business. And on these invoices I have a terms list showing "On Reciept, Net 30, and 2% 10 Net 30." I also show a Invoice date and a due date.
|
| File name in the footer/header | 20 Dec 2007 12:06 GMT | 2 |
Is there a way to insert the file name in a footer/header without the ".xls" in the name? Basharat.
|
| How to convert numeric(1) to alphabet (One) in Excell | 20 Dec 2007 10:39 GMT | 1 |
I want to connvert the numbers to alphabet form like 1 To One in excell, or 12 to twelve, what is the command for this.
|
| Autocopy formula in tables | 20 Dec 2007 10:06 GMT | 1 |
How do I STOP my formula being copied down on each row when I'm using a table?
|
| I want to use a fill series to copy down a pattern of dates. | 20 Dec 2007 09:18 GMT | 1 |
I want to use fill series to copy a pattern of dates down a column. The catch is that I want it to have a date show up three times in a row, in separate cells. So the end products would have three of the same date in the first three column cells, three of the next date in the ...
|
| Importing Excel file into Outlook | 20 Dec 2007 08:44 GMT | 1 |
I am using Excel 2003. I am trying to import an Excel csv file (containing contacts) into Outlook 2003. From there I will export it to a website (point2homes.com) that will maintain these contacts for me and allow me access. I am following their instructions: In order to preserve ...
|
| Sorting in group | 20 Dec 2007 08:25 GMT | 3 |
How do sort this b 111 2222 33333
|
| extract data from multiple workbooks | 20 Dec 2007 08:05 GMT | 1 |
I have 293 excel files, each comprised of a number of worksheets, and each containing statistical information on a different area (the same type of information, but obviously each area has different values; the same naming conventions are used for each file/worksheet). What I ...
|