D
Dpocahontas
I really hope to have some help with this as i am very basic at VBA
can run them but not create !
Hi Excelers.
Maybe I will not be the best to explain but please let me know if yo
need further explanation.
I have different workbooks (around 20) and they give the informatio
about different products for the branches, so in all those workbooks th
code and the name of the branch and the info starts at B8:B52 and goe
on on F8:F52 so for each branch the starting cell number is 8..now
want to do a summary for each branch with those information on the 2
workbooks. I do the first branch that starts at 8 so i go =workbookx, d
and so on and then copy this one to the other sheet, and as there th
common value is 8, i go CTRL F, find 8 and replace with 9 but at th
same time keep the 20 workbooks open and it does replace all the value
so make the changes for the righ branch that starts at 9...and i go o
with the same paste the first one so with value 8, and i go replce wit
10 and so on....this is an easy way that I did found but i would like t
do it with a macro as it will not be a boring job and will same me a lo
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 th
info, i want the macro do save the next sheet with the code of th
branch, where it will copy it let's say B8 and the name at the top of i
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 2
links but still, but i can't find what i look for.
Thank you a lot
can run them but not create !
Hi Excelers.
Maybe I will not be the best to explain but please let me know if yo
need further explanation.
I have different workbooks (around 20) and they give the informatio
about different products for the branches, so in all those workbooks th
code and the name of the branch and the info starts at B8:B52 and goe
on on F8:F52 so for each branch the starting cell number is 8..now
want to do a summary for each branch with those information on the 2
workbooks. I do the first branch that starts at 8 so i go =workbookx, d
and so on and then copy this one to the other sheet, and as there th
common value is 8, i go CTRL F, find 8 and replace with 9 but at th
same time keep the 20 workbooks open and it does replace all the value
so make the changes for the righ branch that starts at 9...and i go o
with the same paste the first one so with value 8, and i go replce wit
10 and so on....this is an easy way that I did found but i would like t
do it with a macro as it will not be a boring job and will same me a lo
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 th
info, i want the macro do save the next sheet with the code of th
branch, where it will copy it let's say B8 and the name at the top of i
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 2
links but still, but i can't find what i look for.
Thank you a lot