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

Powerful find word macro on spreadsheet

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
deddy81
Newbie
Newbie


Joined: 24 Jan 2012
Posts: 1

PostPosted: Wed Jan 25, 2012 4:09 am    Post subject: Powerful find word macro on spreadsheet Reply with quote

Hi all,

Since i have totally zero knowledge about macro, can someone give me idea of my problem ?
i have one worksheet with many sheet with every sheet contain thousand material price. i want to have macro that every time i run it show dialog box to find/search material name and i type what im looking for and wooosah..it shows every material that contain word that i type that i looking for in the next blank sheet with its price in a row

thanks and sorry for my bad english
Back to top
View user's profile Send private message
martin_p
General User
General User


Joined: 22 Feb 2012
Posts: 10
Location: Indonesia

PostPosted: Wed Feb 22, 2012 9:30 pm    Post subject: Powerful find word macro on spreadsheet Reply with quote

Maybe you don't need macro at all. Are your material lists still growing? Could you merge your data into a single sheet? If it is possible, you can simply use Data > Filter.
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 Macros and API 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