Moving data between worksheets in VBA
Hi all,
I'm trying to evaluate a list in a column. When I reach a row that contains
a "=", I'd like to create a new worksheet and cut and paste all the entries
following into that new sheet.
For example:
Sheet 1:
Monkeys
Cinnamon
Car Keys
=
Root Beer
Sheet 2:
Root Beer
Any thoughts on the best way to approach the code?
Thanks in advance, this forum is amazing!
Mike
|