muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
Hey all,
I deal with a lot of ticket rolls in my industry and was wondering if there's a way to simplify counting the number of tickets used for a venue.
On sheet 1 i'd like to have column a be a starting value of ticket #, column b the number of tickets in the roll (i.e. 1000 or 20000) and column c be the venue. On sheet 2, i'd like column a to be filled with row 1 the starting value and all rows filled with the series of numbers up until the value of column b in sheet 1. Column b (in sheet 2) to be filled with 1 - (value of column b sheet 1), and column c filled with the venue.
Sheet 3 eventually is my lookup tool for starting number vs ending number using vlookups to find the number of tickets used for a particular venue on a particular day.
example below
sheet 1:
<tbody>
</tbody>
sheet 2:
<tbody>
</tbody>
Any other suggestions on how to tackle this would be much appreciated as well. Thanks in advance
I deal with a lot of ticket rolls in my industry and was wondering if there's a way to simplify counting the number of tickets used for a venue.
On sheet 1 i'd like to have column a be a starting value of ticket #, column b the number of tickets in the roll (i.e. 1000 or 20000) and column c be the venue. On sheet 2, i'd like column a to be filled with row 1 the starting value and all rows filled with the series of numbers up until the value of column b in sheet 1. Column b (in sheet 2) to be filled with 1 - (value of column b sheet 1), and column c filled with the venue.
Sheet 3 eventually is my lookup tool for starting number vs ending number using vlookups to find the number of tickets used for a particular venue on a particular day.
example below
sheet 1:
100001 | 2000 | xyz |
70001 | 1000 | abc |
125001 | 2000 | 123 |
<tbody>
</tbody>
sheet 2:
Row Number | Ticket Number | Ticket Number 2 | Venue |
1 | 100001 | 1 | xyz |
2000 | 102000 | 2000 | xyz |
2001 | 70001 | 1 | abc |
3000 | 71000 | 1000 | abc |
3001 | 1250001 | 1 | 123 |
5000 | 1270000 | 2000 | 123 |
<tbody>
</tbody>
Any other suggestions on how to tackle this would be much appreciated as well. Thanks in advance