I have a main sheet followed by 15 tabs.
A range os cells in all 15 tabs should be copy pasted as values using macro.
I deally I can activate one tab at a time using VB and copy paste the desired ranges of cells as values.
This means that I need to activate 15 tabs one after the other and write a huge code.
Can i use a loop to perform the copy paste and navigate to the next item tab and perform the same function
Bookmarks