#1
|
|||
|
|||
Please Help. I need to sort Data A-Z not sure if i need to use Macros
Hi Guys,
I have created a holidays management spreadsheet for staff. 80 people in total. I have used 13 sheets. 12 for months ( Jan - Dec) and 1 for Data entry sheet. Data entry sheet to be used to enter employee name, start date end etc. However if there is a new starter when I add new employee in the list of names in Data entry sheet the name stays in the bottom, however if i sort it it a-z the name changes in all the sheets but it doesn't change the information in all the months. Every person have different days booked. I want to sort names A-Z in Data entry sheet and to automatically affect all the other sheets to update all the information for that specific name. Sorry guys tried to be as clear as possible. I have created a simple sample. When I add new name in data entry sheet and alphabetically sort it , it sorts all the names in data entry sheet and Jan sheet but doesn't change the information inputed against names in Jan sheet. |
#2
|
||||
|
||||
Is there a good reason for not having everything on a single sheet (e.g. dates for every day of the year in column A and Employees in Columns B-CC or dates in columns B-NC and Employees in Column A)? Having a separate sheet for every month just makes it unnecessarily hard to work with.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help sorting data in columns that will sort by number of Xs | brenna.at.work | Excel | 8 | 04-12-2014 07:00 AM |
When I sort my data, the sumif report changes | amaka | Excel | 6 | 03-19-2014 04:55 AM |
sort data in excel | cabot | Excel | 1 | 08-17-2012 09:41 AM |
Sort Data | rkeles | Excel | 6 | 02-04-2012 01:31 PM |
Sort Macros | boutells | Excel | 1 | 07-16-2009 11:48 AM |