PDA

View Full Version : Sleeper: Transfering data value from 2 Wbook...



sal21
08-28-2005, 01:56 PM
I have 2 Wbook LISTA_2005 and LISTA_2004.
Into all 2 Wbook are present many sheets named with the alphabetical
letter A, B, C.... ecc.

All sheets named A, B, C ... ecc, contain the first 2 line with header (range
A to V).
From the 3th line are presents many value from range A to V.

I would want to transfer the data value from sheets letters from LISTA_2004 to every sheets letters into wbook LISTA_2005 in this mode:

All line (from A3 to V.....) from the sheet named A into LISTA_2004 into
LISTA_2005 into shest A, append source line if existis already other line into destination sheet
All line (A3 to V.....) from the sheet named B into LISTA_2004 into
LISTA_2005 into shest B, append source line if existis already other line into destination sheet
ecc...

lucas
08-28-2005, 07:10 PM
Hi Sal,
I think I understand what your trying to do, create a new file for 2005 from the 2004 book.....tell me if I'm wrong. Also I don't understand what you mean by this....

append source line if existis already other line into destination sheet

Just want to be sure I understand what your trying to do.:)

sal21
08-29-2005, 12:52 AM
Hi Sal,
I think I understand what your trying to do, create a new file for 2005 from the 2004 book.....tell me if I'm wrong. Also I don't understand what you mean by this....

Just want to be sure I understand what your trying to do.:)

Hi Lucas, tks for fast reply...

Expalin(in similar english;-):

Wbrkbook LISTA_2004 contain sheets named A, B, C, .... (source)
Workbook LISTA_2005 contain sheets named A, B, C, .... (destination)

All sheets into Workbook LISTA_2005 and Workbook LISTA_2004 contain a line with value (range A3:V...)

Example for the sheet named A

The sheet A into Workbook LISTA_2004 contain lines from A3:V100
The sheet A into Workbook LISTA_2005 contain lines from A3:V200

Add/apending the all lines (in this case 100 lines) from sheet A of Workbook LISTA_2004 into sheet A into Workbook LISTA_2005, after the first cell blank in column A (from the line 201).

After this operation the sheet A of Workbook LISTA_2005 contain 300 lines...

Make this for all shetts/letter