Hi there.

I have a workbook with 2 sheets in, 1 is a lookup sheet and 1 is a data
sheet. the lookup sheet's 1st column matches column2 in the data sheet and
then there are 2 columns with different info on the lookup. I am trying to
get the rows from the data sheet to populate 2 worksheets dependant on the
info that is in column 2 of the lookup and the worksheets to be named after
the info in column 2 ( this column only has 2 options "branch" or "ISG")then
i need to add subtotals to the new worksheets based on column 3 of the lookup
worksheet.

any help will be greatly appreciated

Paul