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

Can this happen

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


Joined: 10 Feb 2006
Posts: 40
Location: Michigan, USA

PostPosted: Thu Feb 16, 2006 7:25 am    Post subject: Can this happen Reply with quote

I have columns A1:A500, B1:B500, and C1:C500. I need to extract the contents of a few of the rows and put them in 3totally seperate columns, except one right after the other. Lets say I need A:32, B:32, and C:32, A:55,B:55, and C:55, and A:98,B:98, and C:98 extracted to 3 seperate columnsbut in a consecutive row. (This is a much smaller scale than I am working with). I could copy each row and paste one right after the other but with the size of the spreadsheet it would take a long time. Any way to do this? Thanks much.
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Thu Feb 16, 2006 7:30 am    Post subject: Reply with quote

I think the method for this will depend on how you have identified which rows you want to extract. Do all the relevant rows have special values in them, or do they have a "Yes" in the adjacent cell, or do you have a list of the specific row numbers, or something else?

If you can tell us this, I'm sure there's a way.
Back to top
View user's profile Send private message
Athalon
General User
General User


Joined: 10 Feb 2006
Posts: 40
Location: Michigan, USA

PostPosted: Thu Feb 16, 2006 7:34 am    Post subject: Yes abd No Reply with quote

There is no relation between the cells I want to extract, but I did put column D next to columns A,B, and C. If there is a "Yes" in cell in column D, then that is the row I want to extract. To sum, Yes, there is a ryme or reason for which rows I want to extract, but it has nothing to do with themselves, but with whether the cells next to them in column D have a "Yes" in them. Did I explain this correctly? Thanks a bunch.
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Thu Feb 16, 2006 7:46 am    Post subject: Reply with quote

Is this the same as in the other post

http://www.oooforum.org/forum/viewtopic.phtml?t=31998&sid=532b1bc342cdcc58dc300f8b4e0a3455

or a different but related question?
Back to top
View user's profile Send private message
Athalon
General User
General User


Joined: 10 Feb 2006
Posts: 40
Location: Michigan, USA

PostPosted: Thu Feb 16, 2006 7:48 am    Post subject: Same One Reply with quote

Yes- The same one. I tried to explain it better.
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