Sorting Spreadsheet to Different Tabs

M

Meredith

I have a spreadsheet that has rows of information, and say for example one
item in each row is the month. I would like to have tabs in my workbook for
each month, and have each row go into the tab of its respective month (but
also remain in the main spreadsheet). This is probably an easy vlookup. Any
help is greatly appreciated! I am trying to do this without any macros or
Visual Basic coding. Thank you.
 
D

Don Guillett

Why not just use data>filter>autofilter>filter by the month.
is greater than equal 12/1/2008
is less than equal to 12/31/08
 
M

Meredith

Because in those separate tabs I want to have summary tables generated and
people want to look at the individual tabs as well with all the information
already there.
 

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

Password protect individual tabs in an excel spreadsheet 1
Move list to different tabs 2
sum the number of rows in a spreadsheet given 2 criteria??? 3
Tracking RANK 2
formula for spreadsheet/tabs 1
rename tabs 5
How do I filter master list to multiple sheets? 2
Merging New Column Into Spreadsheet Each Month 2

Top