$$Excel-Macros$$ Seating Chart- vba exccel

2009-04-28 Thread ronnie
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

$$Excel-Macros$$ Seating Chart

2009-04-23 Thread ronnie
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