Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I maintain columns when I copy JMP data into Excel? | Excel Discussion (Misc queries) | |||
How to Copy and Paste Several Columns of Data into Excel... ? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |