View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Syd
 
Posts: n/a
Default Auto transfer rows from 1 sheet to another by account code.

I have a worksheet that I enter all of my monthly invoices into that I enter
in an account code. I also have seperate sheets for each account within the
workbook. I want to be able to enter data into my monthly sheet and have it
automatically transfer all of the information into the corresponding
worksheet for that account. How do I do this?