Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post

    Need to create multiple files from a template.

    Hi Experts,

    I have a template in place and it needs to be filled with the data is saved in the sheet2. Is it possible to create separate file of the template and save it in the folder.

    Regards,
    Jaggi
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Hi Experts,

    Any views on the below thread.

    Regards,
    Jaggi

  3. #3
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Hi Experts,

    Please help me with the below request.

    Regards,
    JD

  4. #4
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post

    Post

    Hi Experts,

    I somehow started and reached here.
    Code:
    Sub sample()
    
    Dim i As Long
    i = Sheet2.Cells(Sheet2.Rows.Count, 1).End(xlUp).Row + 1
    For Each cel In Sheet2.Range("a2:a" & i)
    Sheet1.Range("I6:N6").Value = Sheet2.Range("a2").Value
    Sheet1.Range("I7:N7").Value = Sheet2.Range("b2").Value
    Sheet1.Range("B4:D4").Value = Sheet2.Range("c2").Value
    Next cel
    End Sub

  5. #5
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Hi Experts,

    Thanks I somehow managed to get this solved. Thanks.

    Regards,
    JD

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •