Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default can i sort certain entries from a big excel sheet

I have made a no. of entries while entering the names of files and registers
in a department. I have entered in an alphabetical order eg. Audit file in
'A', Budget (B.Sc.), in 'B', admission registers in 'A', security money
register in 'S'. Now i want all registers to be shifted under alphabet 'R'.
Is there any way this could be possible.
Thanks in anticipation, jay
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default can i sort certain entries from a big excel sheet

Hi
"...Now i want all registers to be shifted under alphabet 'R'. "

So you have things identified as Registers in various columns and you
want to put them all into the R column? Is that what you mean?
How are Register entries to be recognized - do they all have the word
register on the end? Do they have a word like register in them
(Register, register, Registers, Reg. etc) - what are those words?
Do entries start in R1? Are there entries in the R coulmn that now
need to be removed from that column or do you want to add to what is
already there? Where do column entries start - the second row? How
long is each column or can it be any length?
regards
Paul

On May 13, 10:41*am, Jay wrote:
I have made a no. of entries while entering the names of files and registers
in a department. I have entered in an alphabetical order eg. Audit file in
'A', Budget (B.Sc.), in 'B', admission registers in 'A', security money
register in 'S'. Now i want all registers to be shifted under alphabet 'R'.
Is there any way this could be possible.
Thanks in anticipation, jay


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
Why can't I sort new Excel entries after I exceed 1115 lines? Merv Excel Discussion (Misc queries) 1 September 28th 07 03:23 PM
Checking a database/excel sheet for new entries [email protected] Excel Programming 2 June 25th 07 07:09 PM
Checking a database/excel sheet for new entries [email protected] Excel Programming 2 June 25th 07 03:49 PM
any way to alphabetically sort text entries in EXCEL? JTMVOL Excel Discussion (Misc queries) 1 November 27th 06 08:19 PM
how can I sort alphanumeric entries by number in excel beasleyb Excel Worksheet Functions 1 October 27th 05 10:17 PM


All times are GMT +1. The time now is 04:22 AM.

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"