Somewhere out of left field........

[DiscoPistol]

This may prove handy http://j-walk.com/ss/excel/files/dlgwiz.htm

Thanks!

Although it will probably take less time to rewrite the Spreadsheet than it will take IT to give me permission to download the file

 

[Oorang]

So when was the last thing that you guys found something that left you both open mouthed and with a inane geeky grin on your face?

The last thing of awesomeness I found was LSet/RSet could copy values in UDTs back and forth no matter what the types were, as long as they have the same number of bytes. A lot of things I used to use RTLMoveMemory can be accomplished this way. Below is a trivial example:

Option Explicit
Private Type TypedLong
    Value As Long
End Type
Private Type Color
    'Has to be in this order
    Red As Byte
    Blue As Byte
    Green As Byte
    PadByte As Byte
End Type
Sub Example()
    Dim clr As Color
    Dim lngClr As TypedLong
    lngClr.Value = 10905400
    LSet clr = lngClr
    MsgBox Join(Array(lngClr.Value, "Red:=" & clr.Red, "Blue:=" & clr.Blue, _
        "Green:=" & clr.Green), vbNewLine)
End Sub

 

[SydneyGeek]

Is that directed at me?

Hi Bob, Yes -- I would love to know. Sounds like something I could definitely get some use out of.

Denis

 

[xld]

Denis,

Here are my notes that I use, based on Excel 2003. Hopefully it is self-explanatory

Menu>Data>PivotTable and PivotChart Report
Select the Multiple consolidation ranges option
Next
Select the option to create the page fields yourself
Next
Select the source table (or that part of) to be changed, and click the Add button
Next
Pick a location for the pivot table, AND THEN click the Layout button
In this dialog drag both of the Column and Row buttons out of the pivot schematic, leaving just the 'Sum of Value' data field
OK
Finish

This should create a single item pivot
Double-click the cell that contains this single item total, and Excel will create a new sheet with the original data flatfile form
Change the column headings to something more meaningful

 

[Richard Schollar]

Double-click the cell that contains this single item total, and Excel will create a new sheet with the original data flatfile form

Gaarrrgghhh!! I knew I'd forgotten something!! I was copying & pasting values over the PT and then manipulating the formatting of the data

Thanks Bob!

 

[SydneyGeek]

Bob, that's a great trick!

Going to add it to my toolkit...

Denis

 

[Fazza]

John Walkenbach's site has had that tip for some years, I believe.

http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/

 

[lenze]

Although it will probably take less time to rewrite the Spreadsheet than it will take IT to give me permission to download the file

You never ask IT to let you download a file. You have your boss's boss tell them to download it for you. Always worked for me
lenze