Hello Excel Expert,
I found the below code in this forum and with little amendment I brought it into my work.
What I need is that it starts copying data from Column "B2" and in Column "A2" it fills the name of Workbook using wildcard. Like if the file name isPlease Login or Register to view this content.
"ABCDEFGH-XXXXXXX-XXXXXXX-DF-memory-insight". then i need it fills "ABCDEFGH" in the column A parallel with the number of records.
If the last used row is "B2:B15" then it should fill the worksheet name using wild card from range "A2:A15".
Can anyone help me with this!
Bookmarks