How do you autopopulate? Copy/paste automated.

gorillam · Newbie Joined: 16 Feb 2012 Posts: 1

Basically what I have is an excel spreadsheet with the following,

Name Address Phone Quantity

Joe Blow ; 232Lane DR ; 555-5555 ; 5
Jeff Blow ; 232Lane CR; 444-4444 ; 3

And what I want to happen anywhere in the spreadsheet is this,

Joe Blow ; 232Lane DR ; 555-5555
Joe Blow ; 232Lane DR ; 555-5555
Joe Blow ; 232Lane DR ; 555-5555
Joe Blow ; 232Lane DR ; 555-5555
Joe Blow ; 232Lane DR ; 555-5555
Jeff Blow ; 232Lane CR; 444-4444
Jeff Blow ; 232Lane CR; 444-4444
Jeff Blow ; 232Lane CR; 444-4444

The example what I used sounds retarded but I am doing something similar that needs to be done, not the exact example above but exact same principal.

Please help.

Thanks,
Andrew

ken johnson · Posted: Fri Feb 17, 2012 3:00 am Post subject:

Hi Andrew,

Attached doc (Auto Copy_Paste.ods) shows one way using a combination of the INDEX and MATCH functions referencing a helper column that has zero at the top then a formula that produces an accumulating sum (plus 1) of the Quantity values...
http://www.mediafire.com/view/?7jxm66w0e867nbv
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).