Can anyone please tell me how to do the following?? It's making me crazy. Firstly I'm doing this using VB6 app.
Date / Time / CallingID / CalledID / Data
-The above spreadsheet is open by the user in my form. User will specify the following
ate 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
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..