Dividing Data between sheets in a workbook

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?
 

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

MS Project Import Error Row 1 Column 5 2
Combining two sheets of data into one and sorting by value - using macros 5
Sharepoint not capturing staff name when automation runs 0
Extracting a cell value 2
External cell reference between two excel worksheets both in One Drive 0
Adding data to MS Access from csv file 0
Update several ppt documents from a single excel file 0
New computer, how do i move outlook 365 ENTIRELY? 0

Top