Moving data to sheets
You might find what you want at Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html Look for: 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 "Who B. Askin" wrote: Hi I have an Excel sheet with customers data and I want to copy each row to the corresponding sheet according to the value of the "customer" column, so that all rows for customer 1 would be copied to "customer 1" sheet, all for customer 2 would be copied to "customer 2" sheet, etc. I considered making links and using filters, but the data sheet will grow every day and I don't want to go making links for the new rows. I want to write a script to do it automatically, either the links creation or just the row copying. Could you show me a little example of code of how to do this? Thank you very much! Oscar. -- Dave Peterson |
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com