Copy heading and name to applicable sheet

[howard]

I have names in Col O in Sheet2


I need the header in (O1) as well as the name in Col O to be copied to Z1 on the applicable sheet for eg BR1 on Col O as well as the heading to be copied to Sheet BR1 Z1.


it would be appreciated if someone could kindly provide me with code to do this

Book1
	O
1	Branch Name
2	BR1
3	BR2
4	BR3
5	BR4
6	BR5
7	BR6
8	BR7
9	BR8
10	BR9
11	BR10
12	BR11
13	BR12
Sheet2

 

[howard]

Hi Mumps

Just to let you know, that I experimented with the code and eventually sorted out the problem. The code now works perfectly

 

[mumps]

items for BR3 that are 3 rows below it to be copied to sheet BR2

Did you mean to say: "items for BR3 that are 3 rows below it to be copied to sheet BR3"?

 

[howard]

Thanks for the reply.


I did mean to say: "items for BR3 that are 3 rows below it to be copied to sheet BR3


as mentioned in my earlier post, I amended your code and it has worked

 

[mumps]

Glad it worked out.