+ Reply to Thread
Results 1 to 3 of 3

Automatically increase rows based on cell data

  1. #1
    Registered User
    Join Date
    07-16-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Automatically increase rows based on cell data

    Hi - hoping this is a relatively simple query for a real excel newbie.

    We are running a raffle where people submit 2 per entry. If they submit 10 - they get five entries.

    We can export this into excel, but we are manually adding rows for each person for the draw - so if you get five entries, we manually drag down and copy your row five times.

    I know how to obviously divide the cell data by two to show how many entries there are, but not how to get around the manual dragging down to increase rows.

    Is there a way to add a formula that will see the number five, then automatically copy the row five times, then move down to the next row etc.

    It will also remove human error I guess!

    any advice welcome

    thanks

    BCC

  2. #2
    Registered User
    Join Date
    07-15-2015
    Location
    South East England
    MS-Off Ver
    2010 & 2013
    Posts
    72

    Re: Automatically increase rows based on cell data

    This can't be achieved with a formula I'm afraid

    It would require some VBA, can you post an example of the data?

  3. #3
    Registered User
    Join Date
    07-16-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Re: Automatically increase rows based on cell data

    The data is as simple as this

    name 1 name@email.com donation raffle entries
    BCC BCC@harlan.com 10 5

    RG RG@marshhals.com 20 10

    cheers

    BCC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically increase cell value daily
    By CupNHandle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-18-2015, 09:25 AM
  2. [SOLVED] incremental increase in a cell based on value increase in another cell
    By umuni in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-18-2014, 05:23 AM
  3. Replies: 1
    Last Post: 05-04-2013, 06:42 PM
  4. Replies: 1
    Last Post: 05-03-2013, 11:38 AM
  5. Automatically move rows of data to different worksheets based on cell criteria
    By Kaz09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 12:49 PM
  6. [SOLVED] Automatically insert rows based on lookup of data
    By linksavage in forum Excel General
    Replies: 0
    Last Post: 12-21-2010, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1