Dividing Data between sheets in a workbook

  • Thread starter Thread starter Jenny
  • Start date Start date
J

Jenny

I have a master list of information on one sheet with each row being one set
of information. I want to divide the rows into different sheets in the same
workbook based on certain critera such as a date. The information on the
master list will constantly be added to so copy/ paste is not really an
option. I can use an "if" statement to check one cell at a time but I need to
move entire rows of information. Is this something that can be done is excel
and if so, how?
 
Why not just leave all on one sheet and filter
data>filter>autofilter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transferring data from multiple sheets in workbook to one sheet 5
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Multiple criteria in 2 different columns for a sum in a 3rd column 6
dynamic data copying between worksheets 0
Excel IF Formulas 2
find and Summarize data in a table from a different sheet? 2
using the =page! feature to transpose a row to column 0
REPT FUNCTION FROM WORKBOOK TO WORKBOOK 1

Back
Top