OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How do you autopopulate? Copy/paste automated.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
gorillam
Newbie
Newbie


Joined: 16 Feb 2012
Posts: 1

PostPosted: Thu Feb 16, 2012 3:46 pm    Post subject: How do you autopopulate? Copy/paste automated. Reply with quote

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
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Fri Feb 17, 2012 3:00 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group