Hi,
I have a spreadsheet for filling student mark details.
And I am using the below code to create the workbooks that I got at here.
'Sub Michael_Create_workbooks()
Dim NoOfFiles As Long, source As Worksheet
Set source = ThisWorkbook.Sheets(1)
For i = 2 To [A65536].End(xlUp).Row...
Hi,
I want to create new workbooks based on given names in cell A2 to A21.
And in the newly created workbook on sheet1 in C5 should paste the stud no that i have mentioned in the attached workbook.
Like stud no, stud name should paste in C6.
Can you please help me to automate this work...