Making a Macro to create a report in word

Hi, I have a multi-tabbed excel sheet that i would like to pull a report from the workbook is a work log for my technicians and i need to be able to range it by a start and end date. And if possable I would like it broke into to the set titles for the report sections I have 4 fields. all the sheets are formatted the same.

Thanks
Dennis

Hi Dennis and welcome to he board
Can you show us how far you already got ?
Can you post a sample of your data and an example of what you want?

One easy method is to use FormFields. Here is an example.

'http://www.mrexcel.com/forum/showthread.php?t=333200
Sub FillForm()
  Dim wdApp As Object, wd As Object, rn As Long
  rn = ActiveCell.Row
  On Error Resume Next
  Set wdApp = GetObject(, "Word.Application")
  If Err.Number <> 0 Then
  Set wdApp = CreateObject("Word.Application")
  End If
  On Error GoTo 0
   
  Set wd = wdApp.Documents.Open(ThisWorkbook.Path & "\Car Information Page.doc")
   
  wdApp.Visible = True
  With wd
    .FormFields("Brand").Result = Cells(rn, "B")
    .FormFields("Model").Result = Cells(rn, "C")
    .FormFields("Chasis").Result = Cells(rn, "D")
    .FormFields("Engine").Result = Cells(rn, "E")
    .FormFields("Color").Result = Cells(rn, "F")
    .FormFields("YearMonth").Result = Cells(rn, "G").Value & "/" & Cells(rn, "H").Value
  End With
  
 Set wd = Nothing
 Set wdApp = Nothing
End Sub

I tried a few scripts and none of them pull from all tabs. The data I need is in column "B" the report is pulled by the date range in "A" and it would pull the hole row for the records that match.

Dennis

You have not provided enough details to know what you are doing.

Are you making a one record document or will it be like a mailmerge where multiple records create a many page document?

In any case, I don't know how to help if I don't know your rules.