Quote Originally Posted by koolsid
I couldn't understand what is 0 to 100? does it signify a loop and does 0 refer to data in the 2nd row?

What I could make out is you want to copy data from the sheet DATABASE based on step of range for extraction of lines and paste them in sheet TEMPLATE and rename the sheet to DA_0_A100 and so on..... Is that correct?
Hi koolsid....

Italian "da" english=from
Italian "a" english=to

yes! you have understand perfect for this:"What I could make out is you want to copy data from the sheet DATABASE based on step of range for extraction of lines and paste them in sheet TEMPLATE and rename the sheet to DA_0_A100 and so on..... Is that correct?