So I've been trying to Copy Column C from Each Sheet that starts with "STU" to Sheet("Target") starting at "A2", there will be other sheets not starting with "STU" but if add additional sheets starting with "STU", I want to enter only the new info to the next blank column stating at row 2.. I'm using the sheet names as the A2 header, then filling in the info under the header, A3.
I've manage to copy the code, use only the sheets i wanted, but it i ran the code a secong time, it just adds all the sheets again, I've tried using application.worksheetfunction.match, tried coping sheet names first, then check cell values against sheets, but am unable to figure it out..
here's the code I've butcher, please don't laugh too hard, I'm trying
there's other code, all under workbook, but it doesn't functionPlease Login or Register to view this content.
and heres the workbook
StuTest V1.xlsm
Bookmarks