copy data from excel 1 to excel 2 when different dates and columns
 

4 3 3
Joe Sam Fred
2-Apr 250.00 6-Apr 250.00 5-Apr 250.00
3-Apr 1,100.00 8-Apr 1,100.00 7-Apr 1,100.00
11-Apr 22.00 11-Apr 22.00 8-Apr 22.00
15-Apr 256.32

Excel 2003
This sheets data is provided by program code from several workbooks titled
Joe, Sam €¦€¦€¦.
The data is provided daily and could fill a 100 rows and from at most 25
workbooks
The problem is taking this data and placing it in the correct column and
dated row on sheet 2
I got this far but getting data from 1 to sheet2 has be stumped.
Code bypassing sheet1 completely and placing proper data on sheet 2 would be
best.
Have sample workbook that I can forward. Thanks for any help rendered
--
Jim at Eagle

copy data from excel 1 to excel 2 when different dates and columns
 

Hi Jim -

Before forwarding your workbook, could you:

1. Post the code that produces Sheet 1, and
2. Describe (or show) the format you want in Sheet 2.

Maybe we can suggest code modifications to bypass Sheet 1 once we know your
output format.

--
Jay

"Jim at Eagle" wrote:

4 3 3
Joe Sam Fred
2-Apr 250.00 6-Apr 250.00 5-Apr 250.00
3-Apr 1,100.00 8-Apr 1,100.00 7-Apr 1,100.00
11-Apr 22.00 11-Apr 22.00 8-Apr 22.00
15-Apr 256.32

Excel 2003
This sheets data is provided by program code from several workbooks titled
Joe, Sam €¦€¦€¦.
The data is provided daily and could fill a 100 rows and from at most 25
workbooks
The problem is taking this data and placing it in the correct column and
dated row on sheet 2
I got this far but getting data from 1 to sheet2 has be stumped.
Code bypassing sheet1 completely and placing proper data on sheet 2 would be
best.
Have sample workbook that I can forward. Thanks for any help rendered
--
Jim at Eagle