i have two questions that are connected . i want to produce on 4 different
spreadsheets data from one spreadsheet to work out commissions. A consultants
bonus is paid and worked out quarterly.The more fees earnt in a quarter the
higher the bonus. At quarter end the calculation starts again I want one
spreadsheet to capture every sale. So columns one will be "sales date"
,column 2 "revenue", column 3 commission rate, column 4 commission.

Then the other spreadsheets will be quarter periods.So quarter one is
Jan-March, the next spreadsheet is April-June and so

i want to write something in spreadsheet 2 so that it puls from the main
spreadsheets all rows of information that have a sales date 1st Jan-31st
March and then copy the columns.If the date is 1st April ,it sends this
information to Spreadsheet 3 and so on.Then , in the quarter spreadsheets i
can write a if statement to calculate.I am struggling to write something that
copies the data to the correct spreadsheets

i hope that makes sense
--
nick