Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Automatic Sort sheets in excel 2003 workbook

Comment:

Ok I am kind of new to this site and have been trying to figure this out for a while... I need to sort a worksheet in a workbook by the acount number 1st and then by completed date...the cell numbers for these two colums are currently.. i for the account number M for completed date Currently I use this formula in VB Scripts Private Sub Workbook_Open() Dim c As Range Set c = Worksheets("Work History").Cells c.Sort Key1:=c.Range("A1"), order1:=xlDescending, Header:=xlYes End Sub This script works to sort the worksheet by account number (if i copy the account number to Column A), but I would rather have it sort column i and M....

Data integration open sou...

Paradox 9 BLOB Field MS ...

Summary: Hello Everyone, I am new to this forum, so thank you for all of your assistance. Here is what I am tring to do. I have created a worksheet in excel '03 for ticket logging. The worksheet consists of a ...

Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I have a table of Assets called tblAssets, im trying ...

Summary: I am setting up a database of invoices to pass on to a colleague at work. I am looking for a formula in Excel 2003 that will replace part of a set, repeating hyperlink in one column with a correspondi...