I wouldn't do the updating automatically. Too many things can go wrong.
Instead I'd refresh those separate sheets whenever you needed. (Personally, I'd
rebuild them from the consolidated sheet each time.)
These may help:
Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm
Or:
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
Joy wrote:
I have a master sheet with details of quotations for different clients. Is
there anyway to copy the rows of information for each different clients' name
onto seperate worksheets, and then as more quotations are entered onto the
master these would then be automatically placed into the relevant worksheet
for that client.
Hope you understand what I am trying to do. Many thanks for any response.
Joy
--
Dave Peterson