Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Archer------------> @discussions.microsoft.com>
 
Posts: n/a
Default how do I reverse the asending A Z Button

I pressed the asending button If I am right in saying that, The button that
has an A over Z with an arrow next to it in Excel, On my data base and I
moved all the Names (600) 0f them about down about 8 rows, they are
missmatched with the zip's and address's. Can some one help me get back where
I was otherwise I have a whole lot of work ahead of me.

Thanks
Bill
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
can't you copy the old range and copy it to a new column or is the sorting
completely wrong. If yes, probably nothing you can do after you have saved
this result

--
Regards
Frank Kabel
Frankfurt, Germany

Archer------------ wrote:
I pressed the asending button If I am right in saying that, The
button that has an A over Z with an arrow next to it in Excel, On my
data base and I moved all the Names (600) 0f them about down about 8
rows, they are missmatched with the zip's and address's. Can some one
help me get back where I was otherwise I have a whole lot of work
ahead of me.

Thanks
Bill



  #3   Report Post  
Archer------------>
 
Posts: n/a
Default

Thanks frank But the names moved down 8 spaces and I think the zip codes
moved also I need to move them back up 8 spaces keeping the first colum in
place as in aligning the names with the correct address's

"Archer------------" wrote:

I pressed the asending button If I am right in saying that, The button that
has an A over Z with an arrow next to it in Excel, On my data base and I
moved all the Names (600) 0f them about down about 8 rows, they are
missmatched with the zip's and address's. Can some one help me get back where
I was otherwise I have a whole lot of work ahead of me.

Thanks
Bill

  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
but then again: Try copying for ecample cells B9:C100 to the cells D1:E92
and afterwards delete B9:C100

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks frank But the names moved down 8 spaces and I think the zip
codes moved also I need to move them back up 8 spaces keeping the
first colum in place as in aligning the names with the correct
address's

"Archer------------" wrote:

I pressed the asending button If I am right in saying that, The
button that has an A over Z with an arrow next to it in Excel, On my
data base and I moved all the Names (600) 0f them about down about 8
rows, they are missmatched with the zip's and address's. Can some
one help me get back where I was otherwise I have a whole lot of
work ahead of me.

Thanks
Bill



  #5   Report Post  
Archer------------>
 
Posts: n/a
Default

Thats what I was just trying I was copying to a new file the address 's line
up with the names but not the zips, I get them
thanks

"Frank Kabel" wrote:

Hi
but then again: Try copying for ecample cells B9:C100 to the cells D1:E92
and afterwards delete B9:C100

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks frank But the names moved down 8 spaces and I think the zip
codes moved also I need to move them back up 8 spaces keeping the
first colum in place as in aligning the names with the correct
address's

"Archer------------" wrote:

I pressed the asending button If I am right in saying that, The
button that has an A over Z with an arrow next to it in Excel, On my
data base and I moved all the Names (600) 0f them about down about 8
rows, they are missmatched with the zip's and address's. Can some
one help me get back where I was otherwise I have a whole lot of
work ahead of me.

Thanks
Bill






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button VBA code Dave Peterson Excel Discussion (Misc queries) 2 January 25th 05 11:28 PM
Macro to simply bring up the Find dialogue box?? marika1981 Excel Discussion (Misc queries) 14 January 14th 05 10:47 PM
How to assign a macro to a commnd button Mickey Blue Eyes Excel Discussion (Misc queries) 2 January 4th 05 02:15 PM
command button moves Stuart Excel Discussion (Misc queries) 2 December 15th 04 05:56 PM
How do I setup a spin button in excel Andy K Excel Discussion (Misc queries) 1 November 26th 04 09:08 PM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"