parking

  1. S

    Move row to specified sheets based on multiple cell values in column F

    Good day, I have code, Private Sub Worksheet_Change(ByVal Target As Range) 'Version 2 If Not Intersect(Target, Range("F:F")) Is Nothing Then If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub Dim Lastrow As Long Lastrow = Sheets("Completed").Cells(Rows.Count, "F").End(xlUp).Row + 1 If...
  2. djl0525

    How can I restrict number of entries?

    I have two tables, Employees and Parking. Each employee can have up to 3 hangtags issued by the parking department so my tables have a 1:M relationship. My question is, what is the best way to restrict the number of hangtags to 3? In other words, how do I make sure that an employee is not...
  3. P

    =COUNTIF not counting for me please help

    Hi I have the code below where I am trying to count words located in column H, I used the code below but it doesn't count anything just comes up with (0), can you help me please with this? any help will be greatly appreciated. =COUNTIFS(Northants!H:H,"2 man ladder...
  4. A

    Rotating Parking List

    Hey, So, I'm trying to create a monthly parking list for my office. we got X employees, and 2 parking spots. I got 2 sheets: 1. Employee Details - List of employee names, list of license plate, and if the employee wishes to use the parking or not. 2. Results - A list that should be field with...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top