ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   transfering data value from 2 Wbook... (https://www.excelbanter.com/excel-programming/338367-transfering-data-value-2-wbook.html)

sal21[_68_]

transfering data value from 2 Wbook...
 

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 heade
(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 every letter sheets fro
LISTA_2004 to every sheets letter into wbook LISTA_2005 in this mode:

All line (from A3 to V.....) from the sheet named A into LISTA_200
into
LISTA_2005 into shest A
All line (A3 to V.....) from the sheet named B into LISTA_2004 into
LISTA_2005 into shest B
ecc...

Naturally ad into bottom of every destination sheet the record fro
source....

For example if existis 200 into sheet A copy after line 200 the sourc
value..

--
sal2

-----------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=39926



All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com