For Each..Cutty Pasty Loop?

  • Thread starter Thread starter Michael Smith
  • Start date Start date
M

Michael Smith

Ugh...don't know the easiest way to do this..Here's what I got...at each
change of data in a column on my sheet, I need to separate that chunk of
rows into a new worksheet. If someone can get me started I can probably
take it from there.

TIA!
 
Maybe you could steal some code from Debra Dalgleish's site:

http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb
 
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

Problem with a loop and column references 27
loop to copy paste 5
List sheet names in "pop-up" box for users to select 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Search other sheets for numbers & color them 10
Exclude header row when copying autofilter results? (XL2003) 1
Loop from left to the right 5
For Each Next Loop behaving in unexpected manner 13

Back
Top