I have a main sheet followed by 15 tabs
I want to copy paste as values say D10 to E11 in each item tab
The normal VB code is to activate each tab and wirte the code
Is there anyway I can loop and write a code such that the copy paste as values is performed in each tab one after the other.The 15 tabs could be mentioned in the main sheet in a range for example A1 to A15
Please help me out with this
Bookmarks