Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
michelleakalovey
 
Posts: n/a
Default A borrowing dvd spreadsheet

I am trying to save a who borrowed which dvd spreadsheet into my computer
however, after inputting all the dvd names then making sure its in
alphabetical order i put who borrowed it in.

Now what I want to know is what values I could use if the spreadsheet isn't
alphabeticalised and the dvd and the person who borrowed it is in there how
do i make it stick to that dvd until it is returned and no new bought dvd's
are out of alphabetical listing?
Basically i want to keep adding dvd's to my collection and have the person
who borrowed old dvds next to the dvd they borrowed and be able to keep it
all together in order when having it all alphabeticalised.
  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

select the row where you want the new DVD (select the whole row by clicking
on the gray label on the left). Then do Insert=Row

--
Regards,
Tom Ogivly

"michelleakalovey" wrote in
message ...
I am trying to save a who borrowed which dvd spreadsheet into my computer
however, after inputting all the dvd names then making sure its in
alphabetical order i put who borrowed it in.

Now what I want to know is what values I could use if the spreadsheet

isn't
alphabeticalised and the dvd and the person who borrowed it is in there

how
do i make it stick to that dvd until it is returned and no new bought

dvd's
are out of alphabetical listing?
Basically i want to keep adding dvd's to my collection and have the person
who borrowed old dvds next to the dvd they borrowed and be able to keep it
all together in order when having it all alphabeticalised.



  #3   Report Post  
paul
 
Posts: n/a
Default

or type in the new dvd title and resort your table,just make sure that you
select all your columns before you resort your title column
--
paul
remove nospam for email addy!



"Tom Ogilvy" wrote:

select the row where you want the new DVD (select the whole row by clicking
on the gray label on the left). Then do Insert=Row

--
Regards,
Tom Ogivly

"michelleakalovey" wrote in
message ...
I am trying to save a who borrowed which dvd spreadsheet into my computer
however, after inputting all the dvd names then making sure its in
alphabetical order i put who borrowed it in.

Now what I want to know is what values I could use if the spreadsheet

isn't
alphabeticalised and the dvd and the person who borrowed it is in there

how
do i make it stick to that dvd until it is returned and no new bought

dvd's
are out of alphabetical listing?
Basically i want to keep adding dvd's to my collection and have the person
who borrowed old dvds next to the dvd they borrowed and be able to keep it
all together in order when having it all alphabeticalised.




  #4   Report Post  
michelleakalovey
 
Posts: n/a
Default


Thank you Tom and Paul for your responses. Should have realised it was going
to be that easy to do.

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
Spreadsheet merging problems Sam B Excel Worksheet Functions 0 September 19th 05 08:05 PM
Spreadsheet Dilemma msbates2004 Excel Discussion (Misc queries) 1 May 27th 05 02:55 AM
Scan and copy cells from one spreadsheet to another. Mark Excel Discussion (Misc queries) 1 April 6th 05 06:45 PM
Some exported records do not show on spreadsheet vulcan88 Excel Worksheet Functions 0 March 30th 05 01:11 AM
Applying Existing Password to New Spreadsheet Vic Excel Discussion (Misc queries) 1 January 27th 05 12:37 AM


All times are GMT +1. The time now is 10:58 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"