Worksheet Event Copy & Update Data

[ayazgreat]

Hi,
My first sheet is called seats and it is divided into 3 sections left side, center and right side data. In all three sections, there are different seat numbers assigned to different people, and I am manually obtaining and setting each seat number on the sheet "Seating by Alpha" as well as the sheet "Seating by Rows".

I am seeking to make the process of reserving seats and editing seats easier and easy so Whenever I reserve seats and edit seats in three sections in sheet Seats, they will automatically update in "Seating by Alpha" and "Seating by Rows"

[Keebellah]

Hi, hos is your VBA knowledge?
I am asking this because you will need some coding knwoledge to do it with VBA.
Since the versions of Excel at home and office are pre-2021 adn365 some of the newer functions are unavailable
I'll see if I can come up with a solution for you. For straters, you can use the worksheet_Change event

[ayazgreat]

Yes I do have some knowledge of VBA and I am using office 2021

[Keebellah]

Okay, your profile does not mention 2021, that's why I asked

[ayazgreat]

Ok thanks Keebellah. I hope that you will come up with a solution

[Keebellah]

I have taken a look at your file and have many questions and also wonder why your approach is selecting a seat in the Seats worksheet.
I would suggest one sheet just like to other two with all the seats in a table and next to each seat you fill in the name of the person, and whatever information you want.
Then just a formula in all the other worksheest that lookup this seat and fill in the entered names.
I don't know if this actually a seat gegister or jusr a seating reporting app.

[ayazgreat]

My need is just for seating reporting as I was unable to resolve it through formulas, so I asked for a VBA solution

[Keebellah]

is the Seats page the one you want to show as a report or one of the other worksheets?
Since you're using Office 2021 there is a way with formula's.
I'm asking this because the information in the seats sheet is just showing the name and surname in some cases while the information in the other one is moer extensive.
I'll put one formula inthe seats that I think might help.
Upload the file later today

[kvsrinivasamurthy]

This is worksheet event code. This is updating data for 'Seating by Alpha' sheet. When you add data in 'Seats' sheet it will up date in Seating by Alpha sheet and also sorts on column A.
When Data is deleted that particular data is removed in Seating by Alpha sheet.
Try this and come back. If it is Ok we will go to next sheet.
Note the changes in Seating by Alpha sheet.
For column C no data in Seats Sheet.

Please Login or Register  to view this content.

[ayazgreat]

Thanks for your response, I have just checked it and found an error while removing data at this line

DelRo = Evaluate("Match(""" & Ro & St & Sec & """,'" & .Name & "'!D:D&'" & .Name & "'!E:E&'" & .Name & "'!F:F" & ", 0)")

And stop working when I make any change it does not work

[kvsrinivasamurthy]

This is because data mismatch between 'seats' and seating by 'alpha' sheet.
Row 56 is having Stage F56=Stage.
Pl confirm that all data in sheet 'seats' is available in 'alpha' sheet and exactly match. No extra data should be available in any of the sheets.
Try for Few data.