ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
I have made some tables but having an issue trying to sort them.
Some info for you.
Worksheet is called INFO
Tables have headers in row 1
GRASS NAME CV2:CV16
GRASS ADDRESS CX2:CX16
GRASS PAID CZ2:CZ16
GRASS MILEAGE DB2:DB16
What im looking to do is place a macro on a button which will sort the names in column CV & keep the correct data in the other columns assigned to each name.
As i add more info to this list the macro would need to update itself with the new range.
Many thanks
I have made some tables but having an issue trying to sort them.
Some info for you.
Worksheet is called INFO
Tables have headers in row 1
GRASS NAME CV2:CV16
GRASS ADDRESS CX2:CX16
GRASS PAID CZ2:CZ16
GRASS MILEAGE DB2:DB16
What im looking to do is place a macro on a button which will sort the names in column CV & keep the correct data in the other columns assigned to each name.
As i add more info to this list the macro would need to update itself with the new range.
Many thanks