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

Increment Cell Value +1 with a macro

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


Joined: 11 May 2012
Posts: 2
Location: Albania

PostPosted: Fri May 11, 2012 12:45 am    Post subject: Increment Cell Value +1 with a macro Reply with quote

Hello:

I am brand new to this website and i was looking for your help Smile.

I really hope to have some help with this as i am very basic at VBA i can run them but not create Razz!


Maybe I will not be the best to explain but please let me know if you need further explanation.

I have different workbooks (around 20) and they give the information about different products for the branches, so in all those workbooks the code and the name of the branch and the info starts at B8:B52 and goes on on F8:F52 so for each branch the starting cell number is 8..now I want to do a summary for each branch with those information on the 20 workbooks. I do the first branch that starts at 8 so i go =workbookx, d8 and so on and then copy this one to the other sheet, and as there the common value is 8, i go CTRL F, find 8 and replace with 9 but at the same time keep the 20 workbooks open and it does replace all the values so make the changes for the righ branch that starts at 9...and i go on with the same paste the first one so with value 8, and i go replce with 10 and so on....this is an easy way that I did found but i would like to do it with a macro as it will not be a boring job and will same me a lot of time and to be honest i love what macro do .

but what i would like is that if i do the first sheet ready with the info, i want the macro do save the next sheet with the code of the branch, where it will copy it let's say B8 and the name at the top of it the branch name.

Please, if you need a sample i can attach it.

P.S I did search in the internet about it and i looked at around 20 links but still, but i can't find what i look for.

Thank you a lot.
_________________
Try always and you find the soluation!
Back to top
View user's profile Send private message
patel
Power User
Power User


Joined: 14 Apr 2012
Posts: 54
Location: Italy

PostPosted: Fri May 11, 2012 4:38 am    Post subject: Re: Increment Cell Value +1 with a macro Reply with quote

Dpocahontas wrote:

Please, if you need a sample i can attach it.
attach it please
_________________
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
Dpocahontas
Newbie
Newbie


Joined: 11 May 2012
Posts: 2
Location: Albania

PostPosted: Fri May 11, 2012 5:19 am    Post subject: Reply with quote

Sorry I can't find attachement maybe i am so tired and i don't see it but i try to look at FAQ but is says nothing about it!! I will look it at home when i am more relaxed and do the attachement. sorry...!
_________________
Try always and you find the soluation!
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