Hello all,
I have a macro that looks in A and finds a name, then finds a word of text in a cell the copies information.
I would like it to keep finding the word cells until it reaches another word cell:
Example:
Can anyone help?
Adrac
I have a macro that looks in A and finds a name, then finds a word of text in a cell the copies information.
I would like it to keep finding the word cells until it reaches another word cell:
Example:
Code:
Cells.Find(What:="Bob", After:=ActiveCell).Activate
Cells.Find(What:="Inbound", After:=ActiveCell).Activate
ActiveCell.Offset(0, 2).Range("A1").Copy
ActiveCell.Offset(0, 16).Range("A1").Select
ActiveSheet.Paste
***this ia where i want it to go to***
do this command above until it finds the word 'Wrokgroup' in a cell then next command (person)
Can anyone help?
Adrac