I did this much coding and i am stuck out here can you help on how to
approach from here.
Sub seating()
Dim inputrow As Integer
Dim seatNum As Integer
Dim seat As String
Dim name As String
inputrow = 3
Rowadd = Left(seatNum, 1)
ColAdd = Right(seatNum, 1)
Dim OutRow, OutCol As Integer
OutRow
Your task is to write a small macro that converts the seat list into a
seat chart in table 2.
First, the names in table 1 are in Last_Name, First_Name format. You
need to convert them into First_name Last_name format to place in
table 2. To do this, you need to write a function called ConvertName