VBA: copy one column to another for various sheets (Loop)

[Tarek78]

Hi Everyone,

I have tried to copy my sheet using XL2BB.

I have a workbook with multiple sheets ("Beginning", "A", "B", "C", "End").

For all the sheets from Beginning until the end (I might include some new sheets from one month to another), I want to copy the column B to Column C.

Is that something we can do using a loop?

Thanks

Book1
	A	B	C
1	ACCOUNT	REVENUE	REVENUE
2	ABC	10
3	ABC	12
4	ABC	12
5	ABB	11
6	ADD	11
Beginning

 

[Tarek78]

Hi ,

Thanks I trust you. I am sure it will work fine. I will try it at work on Monday and let you know. Thanks again so much for your help

 

[My Aswer Is This]

Hi ,

Thanks I trust you. I am sure it will work fine. I will try it at work on Monday and let you know. Thanks again so much for your help

The script asks you what sheet number you want to start with and what sheet to stop looking
Like 1 to 5 or 3 to 6
Or 1 to 1 or 3 to 3