mudcat.org: BS: Another Excell spreadsheet ?
Lyrics & Knowledge Personal Pages Record Shop Auction Links Radio & Media Kids Membership Help
The Mudcat Cafeawe

Post to this Thread - Sort Descending - Printer Friendly - Home


BS: Another Excell spreadsheet ?

Deckman 20 May 14 - 06:51 AM
Backwoodsman 20 May 14 - 07:14 AM
Deckman 20 May 14 - 08:05 AM
GUEST 20 May 14 - 08:29 AM
Dave the Gnome 20 May 14 - 08:30 AM
Dave the Gnome 20 May 14 - 08:31 AM
Deckman 20 May 14 - 09:04 AM
Backwoodsman 20 May 14 - 09:56 AM
GUEST,mg 20 May 14 - 12:23 PM
GUEST,Ed 20 May 14 - 12:29 PM
GUEST 20 May 14 - 01:36 PM
Bonzo3legs 20 May 14 - 04:12 PM
GUEST,John P 21 May 14 - 10:09 AM
Lyrics & Knowledge Search [Advanced]
DT  Forum
Sort (Forum) by:relevance date
DT Lyrics:



Subject: BS: Another Excell spreadsheet ?
From: Deckman
Date: 20 May 14 - 06:51 AM

You folks solved a problem I was having with data entry in the Excell spreadsheet format. I appreciated that very much. I now have another problem:

I'm establishing an alphabetical list of my active song list. I'm approaching 400 songs. I've made several columns "A", "B", etc. The "A" column is the song title. Column "B" is my source for that song. Column "C" tells me if I've recorded it already, etc.

Here's the problem: when I hit "data" and alphabetize the song list in column "A", the other columns do not stay with the matching entry in column "A". This means that as I have to re-enetr the matching data all over again.

Is there a solution for this?

Thank you in advance for taking your time on my delemma. bob(deckman)nelson ... in the Seattle area.


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: Backwoodsman
Date: 20 May 14 - 07:14 AM

You need to select all of the columns and sort on Column A. The data in the other columns will then follow the re-sorted column A data.


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: Deckman
Date: 20 May 14 - 08:05 AM

Thank you very much ... bob


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: GUEST
Date: 20 May 14 - 08:29 AM

If you do make a mistake like that again, try Edit/Undo.


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: Dave the Gnome
Date: 20 May 14 - 08:30 AM

And you probably already know this but if you do something, like your sort, that does not do what you want, rather than re-enter the data just choose Edit - Undo. Saved my skin, and patience, many a time :-)

Cheers

DtG


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: Dave the Gnome
Date: 20 May 14 - 08:31 AM

Simultaneous posts!


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: Deckman
Date: 20 May 14 - 09:04 AM

Thanks team!   bob


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: Backwoodsman
Date: 20 May 14 - 09:56 AM

It's a pleasure Bob! :-)


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: GUEST,mg
Date: 20 May 14 - 12:23 PM

I have had this happen numerous times and the edit undo just would not work once it had sorted. The other time it won't work for me is when it changes dates into some number..it won't change them back..so work out of a copy.

What you probably need is an access database but they require a lot of knowledge which I don't have and is pretty hard to do on your own . You can enter stuff in excel and import into database that someone has set up for you. It becomes very easy to run various reports then but you need help from someone who is better acquainted iwth the program.


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: GUEST,Ed
Date: 20 May 14 - 12:29 PM

the edit undo just would not work once it had sorted.

You probably have auto save switched on. Undos are only available up to the last save.


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: GUEST
Date: 20 May 14 - 01:36 PM

No particular need to go to an Access DB - you can use the raw data on Sheet 1 as the source and some querying on it in Sheet 2, using the external data query tools.


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: Bonzo3legs
Date: 20 May 14 - 04:12 PM

A trick I use to always have the facility to backtrack to where I started from is to insert a column and number each row consecutively. Include this in the data/filter range. All you need to do is sort this row "smallest to largest"!


Post - Top - Home - Printer Friendly - Translate

Subject: RE: BS: Another Excell spreadsheet ?
From: GUEST,John P
Date: 21 May 14 - 10:09 AM

The biggest help for speadsheets that go wonky: Save often.


Post - Top - Home - Printer Friendly - Translate
 


You must be a member to post in non-music threads. Join here.


You must be a member to post in non-music threads. Join here.



Mudcat time: 17 January 7:48 AM EST

[ Home ]

All original material is copyright © 1998 by the Mudcat Café Music Foundation, Inc. All photos, music, images, etc. are copyright © by their rightful owners. Every effort is taken to attribute appropriate copyright to images, content, music, etc. We are not a copyright resource.