Re: Increment Cell Value +1 with a macro

On Friday, May 11, 2012 3:35:10 AM UTC-5, Dpocahontas wrote:
> I really hope to have some help with this as i am very basic at VBA i
> can run them but not create :P!
>
> Hi Excelers.
>
> 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.
>
>
>
>
> --
> Dpocahontas

Send your file to dguillett1 @gmail.com along with at least one of the source files and a complete explanation and examples.