HopefulGJL
Board Regular
- Joined
- Nov 28, 2008
- Messages
- 100
Hello,
I have the below code that runs everything in the referenced code.
What I'm looking to do is have it loop through a list, perform everything in those two codes one-by-one. The list is in an external workbook. I'll try to clarify this:
Take the name in Sheet1 B1 of the other workbook and paste in to this workbook Sheet1 A1.
Now do both of the below codes.
Next take the name in Sheet1 B2 of the other workbook and paste in to this workbook Sheet1 A1.
Now do both of the below codes.
Keep going until each is completed.
I have looked at many examples from online searches, but just can't find something that copies the cells one by one from another workbook to do codes in this workbook and then continue to the next.
Thanks in advance for any assistance you can provide.
I have the below code that runs everything in the referenced code.
What I'm looking to do is have it loop through a list, perform everything in those two codes one-by-one. The list is in an external workbook. I'll try to clarify this:
Take the name in Sheet1 B1 of the other workbook and paste in to this workbook Sheet1 A1.
Now do both of the below codes.
Next take the name in Sheet1 B2 of the other workbook and paste in to this workbook Sheet1 A1.
Now do both of the below codes.
Keep going until each is completed.
I have looked at many examples from online searches, but just can't find something that copies the cells one by one from another workbook to do codes in this workbook and then continue to the next.
Thanks in advance for any assistance you can provide.
VBA Code:
Sub Main()
AutoFilterColumnCellValue
BreakLinksandSave
End Sub