Macro that copies range to new sheet

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I'm trying to get a macro to copy rows in column A to new sheets based
on the value in row A. I really could use some help! Thanks so much.


For example

original sheet has the values:

Column A, Column B
Red, 123
Red, 234
Red, 111
Blue, 124
Blue, 453
Yellow, 234
Yellow, 531
Yellow, 123

.... and the macro makes three new sheets:

New sheet1:
Column A, Column B
Red, 123
Red, 234
Red, 111

New sheet2:
Column A, Column B
Blue, 124
Blue, 453

New sheet3:
Column A, Column B
Yellow, 234
Yellow, 531
Yellow, 123
 
if you are familiar with VBA, then you could use some sample exce
sheets from debra's website www.contextures.com to hit the groun
running.

go over to the Files link, and download two sample files CopyToWkbk.xl
and ExtractUnique.xls. you could tweak and combine the two to get a cod
which fits your requirement
 
Back
Top