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

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