keydorme

Can anyone please tell me how to do the following?? It's making me crazy. Firstly I'm doing this using VB6 app.

Spreadsheet1(excel):
Date / Time / CallingID / CalledID / Data

-The above spreadsheet is open by the user in my form. User will specify the followingate started,Date ended,CallingID and CalledID
-So far, I managed to design the app until all the data keyed. i also managed to create another excel with following columns:

Spreadsheet2(excel create at runtime)
Date Started / CallingID / CalledID / Data
......
......
Date Ended


My problem is that I'm struggling to list the data column in spreadsheet2 based on data column in spreadsheet1, WITH the parameters selected in spreadsheet2 is SAME as the spreadsheet1's row list. I hope you all understand what I mean here.

For example, if user select 2nd Nov 2002 for date started, 4th Nov 2002 for date ended, 10 for callingID and 33 for called ID, the data in spreadsheet1 which carries the matching parameters in rows will be 'copied' to data column in spreadsheet2.

For your info, I must create this app result in excel. CallingID and CalledID is not unique.

Thanks for any help that comes..

trental

you said the output has tro be excel - but do you have to use vb6?

sounds like an access database would be much easier.. although i am sure there are people here who will help you solve this in vb.

database tasks:
import the original spreadsheet
show it on a form
asks user for parametes
execute a query based on the parameters
export the query results as excel file
open the excel file.

good luck. hope someone comes up with the info you need