![]() |
#1
|
|||
|
|||
![]()
I have an Excel Spreadsheet for the club that I manage. For each member I have data in 5 rows and 16 columns. I would like to be able to move those 5 rows and 16 columns as one "unit' for want of a better word. It would be helpful if I could sort the entire "unit" using different criteria (cells) at different times. Is this possible with very limited Excel knowledge. Thank you for your help
Stephen |
#2
|
||||
|
||||
![]()
Your current layout is probably going to be an issue. You would be better served if your data was normalized. If you upload a sample (dummy up confidential data) and a mocked up solution so that we can understand completely your need, then we might be able to help. Not enough current information to offer up a workable solution. 5-8 records should be sufficient.
|
#3
|
|||
|
|||
![]()
Having 5*16=80 cells of data for every member? This really looks like design issue!
Options: Have all those fields in single row in data table on data entry worksheet. Have a report sheet(s) (you can have any number of different ones), where you can select a member from data validation list (or any other set of filter conditions), and all info about this member, or whatever condition set you determined,is read from data entry sheet(s), and displayed in design you want; In case there is some info in several cells, which can be grouped (e.g. address info), have this info entered into different table on separate sheet, along with some field from main entry table which identifies the member (e.g. full name). You'll display this info in those reports only, where this is needed; In case there is some info in several cells, which really is of same type (you have SomeHeader1, SomeHeader2, etc.), have this info entered into different table on another sheet row-wise, and calculate a entry number for member the entry is linked to (a table with headers like Member, SomeHeader, MemberRow). You'll display this info in those reports only, where this is needed; You have some info which is calculated by formulas? If yes, do you really need those fields in data entry table. If not, then calculate and display this info in those reports only, where this is needed. |
#4
|
|||
|
|||
![]()
If you have either the member name or membership number as the first column entry in each row, and for example the date of transaction in the second column, you should be able to keep the member's data together in a sort, if you sort by Column A first, and whichever column makes the most sense next. But, as said, there may be an easier way to organize your data.
SMITH, BOB 9/1/2022 Membership Fee Paid $2,000.00 SMITH, BOB 11/15/2022 Purchase Gift - Shirt $30.00 etc. |
![]() |
Tags |
combining multiple rows, sorting |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Locking several cells and columns into one unit or block | Taras49 | Excel | 5 | 03-27-2023 02:05 PM |
![]() |
ColtonYYZ | Excel | 2 | 10-31-2022 11:46 AM |
how to create a block text and when click on the title of block hide and unhide the block | labasritas@free.fr | Word | 4 | 09-17-2017 01:17 PM |
![]() |
RoyLittle0 | Word VBA | 1 | 04-14-2013 12:13 AM |
Connecting two or more messages | napoleon007 | Outlook | 0 | 10-05-2010 03:07 AM |