Printable View
I want to devide the record in DATABASE in this mode:
(in sheet TABELLA are the step of range for extraction of lines, the index of search value is in column O)
Copy in TEMPLATE all line from DATABASE from 0 to 100 rename TEMPLATE in DA_0_A100, go to next line of TABELLA, copy in TEMPLATE all line from DATABASE from 101 to 200 rename TEMPLATE in DA_101_A_200, ... ecc
Hope i am clear...
Before to extrat lines preventing i order all record in DATABASE from column O...
I couldn't understand what is 0 to 100? does it signify a loop and does 0 refer to data in the 2nd row?Quote:
step of range for extraction of lines
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....Quote:
Originally Posted by 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?
Hi I got that part but what i mean is...Quote:
Italian "da" english=from
Italian "a" english=to
Does 0 refer to data in the 2nd row? and does 100 refer to data in row 102 in your workbook?
Sorry me for my wrong explain...Quote:
Originally Posted by koolsid
..."Copy in TEMPLATE all line from DATABASE, until value in range of column O is in tange: 0,00 to 100,00 rename TEMPLATE in DA_0_A100, go to next line of TABELLA, copy in TEMPLATE all line from DATABASE until value in range of column O is in range: 101,00 to 200,00 rename TEMPLATE in DA_101_A_200, ... ecc"
I am sorry but i still didn't understand you :confused:Quote:
"Copy in TEMPLATE all line from DATABASE, until value in range of column O is in tange: 0,00 to 100,00 rename TEMPLATE in DA_0_A100, go to next line of TABELLA, copy in TEMPLATE all line from DATABASE until value in range of column O is in range: 101,00 to 200,00 rename TEMPLATE in DA_101_A_200, ... ecc"
Okay let's go thru it all in a different way... :)
1) you want to copy the first 100 rows(starting from row2) from DATABASE to TEMPLATE and then rename it to DA_0_A_100.
2)then you want to copy the next 99 rows from DATABASE to TEMPLATE and then rename it to DA_101_A_200.
3)and then you want to copy the next 299 rows from DATABASE to TEMPLATE and then rename it to DA_201_A_500.
4) and finally you want to copy the remaining rows from DATABASE to TEMPLATE and then rename it to DA_501_A_TO_THE_MAX.
Is that correct?
sorry once again for not understanding...
Yes! Finally you have understand me, sorry for my terrible englishQuote:
Originally Posted by koolsid
Note: but you consider the step of range to copy line?
Understand you this sheet are dinamicly and for example the first step of aumont for example 0,00 to 100,00 it can have many lines not perfect 99 lines...
for example the step of aumnot is in the range of 358 lines , or 5478 lines, ecc....
Is this what you want?
attaching a file...
click the commandbutton on sheet TABELLA
Hope this helps...
[Edit 25/03/2007] : Since the post is resolved.. deleting the attachment as my total attachements have crossed the allowed limit
Nice and excellent code!Quote:
Originally Posted by koolsid
Tks.
glad to help :D
sorry for not understanding it earlier...
no prob... sorry to my for terrible english.Quote:
Originally Posted by koolsid
.. hummmmm have idea for:http://www.vbforums.com/showthread.php?t=448385
tks.