Total Nube

[Woodyexcel]

Hello Excel masters,

I am totally new to VBA and and working with an Excel document that has all
the information input to a master sheet. I want to sort a single column from
the master sheet to multiple sheets(in the column is one of seven entries.) I
want each of those entries to go to a separate sheet.

I tried recording and using the advanced sort.....just not sure how or where
to begin on this one. Thanks in advance.

Woody

 

[Smitty]

Welcome to the Board!

You can apply Dat-->Filter to narrow your criteria, then Goto-->Special-->Visible Cells only and copy the range to the appropriate sheet. If you record doing that once you get the hang of it you should be able to set it up to loop through all seven entries.

HTH,

 

[Woodyexcel]

Thanks for the welcome! I will attempt to practice thoses tricks. Thanks
for the tips.

Woody

 

[Smitty]

Great! Feel free to post back if you have any problems.

Note that I should have typed "DATA-->Filter". My bad, so I wanted to clarify. If you're not familiar with it, the helpfile documents it pretty well.