Automatic row inserted if cell contains certain data

G

Guest

Here's the problem:

I have a database of a stadium's seating purchases. The
database does not have each seat as a unique number in a
column. What I have is 5 columns: Sec, Row and "First
seat" and "Last seat" and "Number of seats purchased".

What I'm looking to do is "Concantinate" those 5 fields
into a "seat number" field. SEC. and ROW is easy but how
can I have excel look at the "Number of Seats" field,
grab that number, and insert rows underneath based on
that number?

So If someone bought 6 seats, I have a field showing "1"
and "6", I need excel to add 5 rows below this entry, and
I can have the cell generate the seat number
automatically by the range of cells 1-6.

Is this possible? if so, any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help? 1
how to format cells -fill color 2
How do I merge cells with different information? 1
automatically insert autoshapes when cells are updated? 0
access database design. HEEEELP MEEEEE!! 2
Multiple Unique data on each Page of a report 1
Function to autofill remaining width of a cell 5
query for values not in use 2

Top