Create Worksheets Based Upon Changing Column Values in XP
I'm trying to find a way to create new worksheets, and populate it
with values, everytime a specific column value changes. I've sorted the master worksheet by driver name. Now, I'd like a routine or add-in that creates a new worksheet everytime the driver's name changes. Worksheet name should be driver's name, and column headers (row 1) should be included at the top of each worksheet. There are 15 or so columns of data, and that data should be copied over as well. It sort of reminds me of the Subtotal routine, but instead of subtotals or page breaks between groups, I'd like a new worksheet for each manager. I'm running Excel XP. I need to distribute in Excel because most of our driver's don't have Access or Snapshot Viewer installed. I've searched and searched the newsgroups, the Microsoft KB, as well as a few great Excel sites and haven't found anything that addresses this problem. Any ideas or pointers are appreciated. Gary www.storkoccasions.com |
Create Worksheets Based Upon Changing Column Values in XP
You may want to run a macro whenever you need the extraction.
Debra Dalgleish's has some code that does this kind of thing: http://www.contextures.com/excelfiles.html There are a couple of files you may want to steal from: Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb Gary wrote: I'm trying to find a way to create new worksheets, and populate it with values, everytime a specific column value changes. I've sorted the master worksheet by driver name. Now, I'd like a routine or add-in that creates a new worksheet everytime the driver's name changes. Worksheet name should be driver's name, and column headers (row 1) should be included at the top of each worksheet. There are 15 or so columns of data, and that data should be copied over as well. It sort of reminds me of the Subtotal routine, but instead of subtotals or page breaks between groups, I'd like a new worksheet for each manager. I'm running Excel XP. I need to distribute in Excel because most of our driver's don't have Access or Snapshot Viewer installed. I've searched and searched the newsgroups, the Microsoft KB, as well as a few great Excel sites and haven't found anything that addresses this problem. Any ideas or pointers are appreciated. Gary www.storkoccasions.com -- Dave Peterson |
All times are GMT +1. The time now is 10:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com