macro to sort data in worksheet by specific date
We are getting timesheet information from a bar code system that goes into
access and from there we download to excel so we can data sort.(not an access user). one of the sorts we do is to get the most current day and sort by employee to see if they charged time that day for all the time they were at work. We have numerous columns for: start time start date stop time stop date job no /quantity worked on etc. etc. would like to have a macro that would automatically sort in excel the most recent day with all data in the row and hide previous days info. our spreadsheet is getting really large and other data sorts are used for job no. etc. so we can't just remove the previous days data to keep the spreadsheet small. any ideas? IT's possible it would be better to work in access where the data starts but no one here is familiar with it. -- joey |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com