How can I populate text accross worksheets?
How can I copy the content of a row within a worksheet
to another worksheet if a certain criteria is met. For example: If the value of A2 is "sales", then copy the content of row 2 to worksheet 2. If the value of row 3 is "marketing", copy the content of row 3 to worksheet 3. Brian |
I'd steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html 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 Brian Foss wrote: How can I copy the content of a row within a worksheet to another worksheet if a certain criteria is met. For example: If the value of A2 is "sales", then copy the content of row 2 to worksheet 2. If the value of row 3 is "marketing", copy the content of row 3 to worksheet 3. Brian -- Dave Peterson |
All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com