Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2014, 05:50 AM
steveyjohn steveyjohn is offline Please Help. I need to sort Data A-Z not sure if i need to use Macros Windows 7 32bit Please Help. I need to sort Data A-Z not sure if i need to use Macros Office 2010 32bit
Novice
Please Help. I need to sort Data A-Z not sure if i need to use Macros
 
Join Date: Nov 2014
Posts: 1
steveyjohn is on a distinguished road
Default 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.
Attached Files
File Type: xlsx sample.xlsx (12.0 KB, 9 views)
Reply With Quote
  #2  
Old 11-14-2014, 06:19 PM
macropod's Avatar
macropod macropod is offline Please Help. I need to sort Data A-Z not sure if i need to use Macros Windows 7 64bit Please Help. I need to sort Data A-Z not sure if i need to use Macros Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,953
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Please Help. I need to sort Data A-Z not sure if i need to use Macros 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
Please Help. I need to sort Data A-Z not sure if i need to use Macros Sort Data rkeles Excel 6 02-04-2012 01:31 PM
Sort Macros boutells Excel 1 07-16-2009 11:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft