[RESOLVED] Devide line by step of aumont...

[luca90]

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...

[Siddharth Rout]

step of range for extraction of lines

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?

[luca90]

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?

[Siddharth Rout]

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

Hi I got that part but what i mean is...

Does 0 refer to data in the 2nd row? and does 100 refer to data in row 102 in your workbook?

[luca90]

Hi I got that part but what i mean is...

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...

..."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"

[Siddharth Rout]

"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

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...

[luca90]

I am sorry but i still didn't understand you

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 english

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....

[Siddharth Rout]

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

[luca90]

Is this what you want?

attaching a file...

click the commandbutton on sheet TABELLA

Hope this helps...

Nice and excellent code!
Tks.

[Siddharth Rout]

glad to help

sorry for not understanding it earlier...

[luca90]

glad to help

sorry for not understanding it earlier...

no prob... sorry to my for terrible english.

.. hummmmm have idea for:http://www.vbforums.com/showthread.php?t=448385
tks.