I am looking for advice here. This is the situation. I am working at a company that maintains a large spreadsheet on all the employees - roughly 30 columns for each of the nearly 2000 employees. One column holds a number representing the department within the company that the employee works for. There are 33 different areas within the company and we're trying to find a better way of pulling the information for each department into its own spreadsheet (within the same workbook is fine or into a new workbook if that turns out to be easier). Right now it's a matter of sorting/filtering and then copy/paste to different sheets. I would like to create a formula (or macro if someone understands that better) that will scan through all department numbers and then pull the emtire rows of information to a new spreadsheet. (eg. department numbers are in Column Y, so I want to identify everyone in the department numbered 12345 and then pull the entire row of information for anyone matching that department into a new sheet.
Also, is there a way to compare to spreadsheets (not side-by-side comparison) for differences? They update this "master" sheet all the time and expect people to handy-dandy pull new changes out at the drop of a hat, but there's no way of seeing what's changed without having to do a side-by-side comparison... which is horribly inefficient when you're talking about doing side-by-side to scan every cell on a roughly 35x2000 spreadsheet. Any tips on this would also be greatly appreciated.
Also, is there a way to compare to spreadsheets (not side-by-side comparison) for differences? They update this "master" sheet all the time and expect people to handy-dandy pull new changes out at the drop of a hat, but there's no way of seeing what's changed without having to do a side-by-side comparison... which is horribly inefficient when you're talking about doing side-by-side to scan every cell on a roughly 35x2000 spreadsheet. Any tips on this would also be greatly appreciated.
