View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim at Eagle Jim at Eagle is offline
external usenet poster
 
Posts: 83
Default 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