Hello. I have a workbook with 180 Sheest. I need to copy sheet name and paste to column Name.
In the Column Year write 2013.Finally I need to all sheets as show below in in Sheet Farms.
Doing this one by one is time consuming and with error risk. I think a loop can do this,
nevertheless, I donīt Know how to do it. Your help is really appreciated.
Column size can be different in each Sheet
Sheet name Famr1
Cod Name Year Desc Total1 Total2 Prov Cnt
1234 Apples 200 xxx yyy zzz
3412 Bananas 400 xxx yyy zzz
2358 Oranges 500 xxx yyy zzz
8956 Pines 800 xxx yyy zzz
...
...
Sheet name Famr2
Cod Name Year Desc Total1 Total2 Prov Cnt
2345 Apples 200 xxx yyy zzz
4126 Bananas 400 xxx yyy zzz
...
...
Sheet name Famr3
Cod Name Year Desc Total1 Total2 Prov Cnt
2345 Apples 200 xxx yyy zz
4126 Bananas 400 xxx yyy zz
5698 Peanuts 650 xxx yyy zz
8756 Grapes 350 xxx ppp zz
5698 Olives 280 xxx ppp
5879 Pear 150 xxx rrr
....
....
Sheet Farms
Cod Name Year Desc Total1 Total2 Prov Cnt
1234 Farm1 2013 Apples 200 xxx yyy zzz
3412 Farm1 2013 Bananas 400 xxx yyy zzz
2358 Farm1 2013 Oranges 500 xxx yyy zzz
8956 Farm1 2013 Pines 800 xxx yyy zzz
2345 Farm2 2013 Apples 200 xxx yyy zzz
4126 Farm2 2013 Bananas 400 xxx yyy zzz
2345 Farm3 2013 Apples 200 xxx yyy zz
4126 Farm3 2013 Bananas 400 xxx yyy zz
5698 Farm3 2013 Peanuts 650 xxx yyy zz
8756 Farm3 2013 Grapes 350 xxx ppp zz
5698 Farm3 2013 Olives 280 xxx ppp
5879 Farm3 2013 Pear 150 xxx rrr
....
Bookmarks