• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    How to Update only Sheet1 of a workbook template

    Thanks to Tweedle! Here is the answer! Sub Smart1() Dim src As Workbook Dim dst As Workbook SavePath = ActiveWorkbook.Path Set src = ActiveWorkbook For Each C In Range("Names1") i = C.Row Name = Cells(i, 44).Value PSFFAll = Cells(i, 45).Value CLSFall =...
  2. T

    How to Update only Sheet1 of a workbook template

    Here is my working code: Sub Smart1() Dim src As Workbook Dim dst As Workbook SavePath = ActiveWorkbook.Path Set src = ActiveWorkbook For Each C In Range("Names1") i = C.Row Name = Cells(i, 44).Value PSFFAll = Cells(i, 45).Value CLSFall = Cells(i, 46).Value CLSWin = Cells(i...
  3. T

    How to Update only Sheet1 of a workbook template

    I have this code to copy data from a range in one workbook to Sheet1 of a specific template. ( The data from Sheet1 then populates a second sheet in the template file.) Each file is created and named for the names in the dynamic named range “names1”. This seems to work perfectly, but I need it...
Back
Top