# seat

1. ### Seat Allocation formula

Hi, need help on how to use Excel to meet below requirement. Below sample is just small population of total seatings so would need to automate. Appreciate your help please, thank you!!! =) Requirements: 1. Allocate the Box capacity following the Position hierarchy, such that "Head" starts to...
2. ### Parentheses Problems

Hello...My name is Devin, and I am planning to host a dinner among friends and acquaintances at a large dining hall within the next two weeks. I am playing around with a formula that will allow me to seat people who I think MIGHT be a good match for conversations(maybe); people who I think WILL...
3. ### Help with ISERROR function.

Hello all. Here is the scenario. I am using Excel to track the inventory of desk phones(among other things) This screenshot is row 8. Here is what I currently have for the H Column =IF(G8<>"",INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"") The phones are assigned to a particular seat or...
4. ### Assigning sequence of numbers to visible cells only using VBA code (avoid hidden rows)

Hello, I am having difficulty with assigning a specific sequence of numbers (seat numbers listed below) to specific records whilst keeping the order. For context, I have a running order of graduands and those known to be attending are marked as attending in column C as well as the row being...
5. ### Simplifying Code

Hi, First of all thanks in advanced for your help. I'm fairly new to coding VBA in Excel. so I have managed to create the following code (which works as intended) and I am curious to know if there is anyway to simplify it as I need to add more lines to it. The intended result is that when a...
6. ### Help with IF statements and updating multiple cells.

Hi, I am creating a spreadsheet in which I need to have the user basically book seats and have excel update those results on another sheet within the workbook. On Sheet 1 I have the list of destinations they chose from and the seat class they would like. On sheet two I have a tracker which...
7. ### IF statements and updating other sheets

Hi, I am creating a spreadsheet in which I need to have the user basically book seats and have excel update those results on another sheet within the workbook. On Sheet 1 I have the list of destinations they chose from and the seat class they would like. On sheet two I have a tracker which...
8. ### Maybe VLOOKUP? Help sorting based on dates

So, I'm trying to get the latest information based on dates for flying. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 113px"><col width="147"><col width="170"><col width="100"><col width="152"><col...
9. ### Pivot table data layout

This is embarrassing but hope this is because I've been a bit rusty on excel vs it being an excel issue. Here's the data set I'm trying to make a pivot table out of the following data set.... <tbody> Time on Seat Did you like onboarding? Did you do your hw? Was he helpful? Did He help when...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...