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

[Guest]

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

 

[Guest]

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.