method to split data rows to multiple worksheets.
From a master spreadsheet, I would like to break the rows out to
multiple worksheets based on matching criteria of two columns. As an example, If column A = xxxx and column B = yyyy, the associated rows would move to sheet1. Can anyone recommend the best method to accomplish this? |
method to split data rows to multiple worksheets.
have a look at debra's site - there are some good examples you can download
that use advanced filter - copy that should help you. one example: http://www.contextures.com/AdvFilterRepFiltered.zip -- jb "dhermus" wrote: From a master spreadsheet, I would like to break the rows out to multiple worksheets based on matching criteria of two columns. As an example, If column A = xxxx and column B = yyyy, the associated rows would move to sheet1. Can anyone recommend the best method to accomplish this? |
All times are GMT +1. The time now is 07:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com