On Wednesday, October 1, 2014 11:35:26 PM UTC-5, JasonL wrote:
Would like some help on what formulas to use to have my payroll

worksheet feed into two seperate worksheets.



Basically I have a worksheet where the header is set as one of two

companies. Under this will be an incremental run number, then columns

with relevant payroll data.



Example below.



Company AXB ATA ATA ATA AXB

Run 1 2 3 4 5

PayData 5555 6666 777 888 999

PayData 5555 6666 777 888 999

PayData 5555 6666 777 888 999



Basically I want one worksheet for company AXB, and one worksheet for

company ATA, with data copied into each based on the company heading, so

only the main worksheet with both companies is fed data. Am using excel

2003.









--

JasonL

Easiest way is to NOT make a separate sheet but just use datafilterautofilter to filter by the company desired and print.