Increment Cell Value +1 with a macro

D

Dpocahontas

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

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
 
D

Don Guillett

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.

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

Dpocahontas

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

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

have a nice day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top