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.

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.

Thank you that is so kind of you. I send it today when I go home the files.

Hope you can help as is the only thing that I am not finding in internet, i did quite a research!!

have a nice day.

I did send them :). thank you!