VBA Invoices print with Name change from Table list

[RasGhul]

Hello All,

If someone could help with an VBA solution for my sheet please. I have a list of clients in a Table, ([MembersTBL[Name]) and a sheet tab called Invoice which is a generic invoice template.

I would like VBA code to grab each name from the list and change the client name in the generic invoice template then print each client's invoice

The Sheets("Invoice").range("F7").value is where the name field is for the invoice.

Any help would be much appreciated.

Regards

Jason

 

[Osvaldo Palmeiro]

Hello, ,Jason.
Try this, please.

Sub PrintInvoices()
 Dim c As Range
  For Each c In Sheets("SomeSheetName").Range("A2:A" & Sheets("SomeSheetName").Cells(Rows.Count, "A").End(3).Row)
   Sheets("Invoice").Range("F7") = c.Value
   Sheets("Invoice").PrintOut
  Next c
End Sub

 

[RasGhul]

Fantastic thanks for the help