corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel guru's


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel guru's
Jambo
Member

Registered: 8th Sep 01
Location: Maidenhead, Drives: VXR Arctic
User status: Offline
24th Nov 11 at 16:43   View User's Profile U2U Member Reply With Quote

This might be a really stupid question, but ive been trying to do this for the last 20minutes and the internet has been no help.

Working on a spreadsheet that has columns with dates in it. For E.g 2001,2002,2003,2004,2005 across the top. The sheet has been compiled by a coleague who now wants the date ranges to read the reverse.

i.e the rows and data to stay the same, but the columns back to front? i.e 205,2004,2003,2002,2001

I literally cannt see a way of doing this. I have tried sorting but it just does not work unless im being thick (which is quite possible)

Help!
Jambo
Member

Registered: 8th Sep 01
Location: Maidenhead, Drives: VXR Arctic
User status: Offline
24th Nov 11 at 16:52   View User's Profile U2U Member Reply With Quote

figured it out. Thanks,

heres one for the search engine

http://stackoverflow.com/questions/524844/how-to-reverse-the-order-of-a-selected-range-of-excel-columns-using-vba
Simon L
Member

Registered: 24th Mar 02
Location: Glasgow
User status: Offline
24th Nov 11 at 19:26   View User's Profile U2U Member Reply With Quote

The sort function also lets you sort columns horizontally, rather than vertically. Easier than VBA.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
24th Nov 11 at 19:31   View Garage View User's Profile U2U Member Reply With Quote

I would have said transpose and sort.

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
is there a program that...... chris_uk Geek Day 6 1894
16th Jun 05 at 00:47
by Dan B
 
MS Excel question --Dave-- Geek Day 15 325
16th Aug 06 at 12:59
by Shelly
 
Excel Help AndyKent Geek Day 3 1451
6th Oct 07 at 10:22
by aPk
 
need an excel like programme (for free) Shane Geek Day 12 1770
13th May 08 at 14:55
by pow
 
Microsoft Excel strick206 Geek Day 10 1478
6th Jul 11 at 14:46
by Sam
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel guru's 28 database queries in 0.0093129 seconds