This is a little tricky I think, but hopefully one of you whizzes can help me
So I have some code the cycle through files in a directory. Right now, it open each book, copies the “Summary” tab over to ThisWorkbook, closes the book and goes on to the next. This piece works beautifully.
Now the tricky part. When it opens each workbook, I also want it to do the following:
•Copy range(“a1”) and paste into the first unused cell in column A of sheet “Analysis” of ThisWorkbook after row 5.
•Into column B, put the first 2 characters from the workbook name.
•Into column C
oIf filename contains “abc” Then put “abc” in column C
oIf filename contains “def” Then put “def” in Column C
•Repeat this for each worksheet in workbook
•I want to skip sheets that are named “Summary” and that begin with the word “Sheet”
I’ll take anything I can get. Thanks so much!
So I have some code the cycle through files in a directory. Right now, it open each book, copies the “Summary” tab over to ThisWorkbook, closes the book and goes on to the next. This piece works beautifully.
Now the tricky part. When it opens each workbook, I also want it to do the following:
•Copy range(“a1”) and paste into the first unused cell in column A of sheet “Analysis” of ThisWorkbook after row 5.
•Into column B, put the first 2 characters from the workbook name.
•Into column C
oIf filename contains “abc” Then put “abc” in column C
oIf filename contains “def” Then put “def” in Column C
•Repeat this for each worksheet in workbook
•I want to skip sheets that are named “Summary” and that begin with the word “Sheet”
I’ll take anything I can get. Thanks so much!