| Thread | Last Post | Replies |
|
| Newbie - Unusual DATE question | 29 Dec 2004 20:03 GMT | 4 |
I have a spreadsheet that is little more than a list of PO #'s that shows what orders are done and ready to ship for a particular customer. We upload the file every day to a website where the customer can view it whenever they want.
|
| Help With Macro Modification | 29 Dec 2004 20:02 GMT | 11 |
I have this macro which will copy a group of non-contiguous cells to another sheet. What I would like to know, is it possible to also make it when it paste to new sheet, paste it as a "paste link". I need to be able to change info on original sheet, but udate cells on other ...
|
| FIFO / LIFO Inventory | 29 Dec 2004 20:02 GMT | 1 |
I'm trying to set up an inventory tracking spreadsheet, that can do FIFO and LIFO costing. Anyone have any idea as to how to do it? grep
|
| Phantom Macro | 29 Dec 2004 20:01 GMT | 4 |
Every time my spreadsheet is opened, a dialog box comes up and ask if macros should be 'enabled' or 'disabled'. There are no macros in this spreadsheet. How do I stop the dialog from appearing? Using Windows XP & Excel 2002.
|
| XY plot in pivot charts | 29 Dec 2004 17:42 GMT | 2 |
Is there a way to do XY Scatter plots from a pivot chart? If I try to build a pivot chart with XY Scatter, Excel complains that XY Scatter is not allowed. If a chart is built, then a right click on the chart and "Source Data" is grayed out. Under VB, in a SeriesCollection, ...
|
| Cell to accept checkmark or "x" | 29 Dec 2004 17:09 GMT | 3 |
Is there anyway to set up cell in way that I have seen a pdf document where a left click on the cell will activate an "x" or a checkmark in that cell?
|
| VB Automation is Whacking out my Excel Environment | 29 Dec 2004 15:49 GMT | 2 |
Set m_AppExcel = New Excel.Application m_AppExcel.Caption = "MyExcelViewer" m_AppExcel.IgnoreRemoteRequests = True After running my application containing the three statements above, Excel
|
| Wrong weeknumber 2004 / 2005 | 29 Dec 2004 15:45 GMT | 4 |
Why this:? Date Weeknumber 28-12-2004 53 29-12-2004 53
|
| How to get the PivotTable report info that feeds another PivotTable report. | 29 Dec 2004 15:04 GMT | 2 |
A pivot table can get it's data from another pivot table as so: Right click in the pivot table and select PivotTable Wizard Click the < Back button Click the next < Back button
|
| about advance filter | 29 Dec 2004 09:41 GMT | 1 |
I have many problem about advance filter, sometime answering . sometime not ?? I wonder why ? please help me .
|
| Display summary sheet with Now or Today data. | 29 Dec 2004 08:45 GMT | 5 |
I would like to display daily data, accumulated from a 12 month calendar on a SUMMARY sheet at the end. This data is hours worked in the "last" 30 days, 90 days and 365 days, stored in cells AN10:AP40 for each month.
|
| HOW DO I USE A CUSTOM LISTS | 29 Dec 2004 06:53 GMT | 1 |
i have created a custom lists and now i want to use it in a worksheet. how do i get the cutom list onto the worksheet
|
| Progressive Dating of Columns | 29 Dec 2004 05:07 GMT | 4 |
Ok, if I want to date successive column headings to return progressive dates, I can use Today (), Today() + 1, Today + 2, etc. What if I want this progression to skip weekend and holiday dates?
|
| Exit sub procedure | 29 Dec 2004 00:41 GMT | 13 |
How to make a sub routine exit totally when a it call another sub routine? E.g if abc = 99 then filter sub routine will exit, but how do I make the total() sub routine exit as well? Sub Filter()
|
| tattslotto numbers | 28 Dec 2004 22:39 GMT | 10 |
Hi I have (and bet not the only one) about 72 games in this big tattslotto entered in cells 6 across and 72 rows I would like to have excel check the winning numbers for me. A:1 to F:1 holds the individual game
|