Printable View
Hello All,
I am creating a project where I need to create a Excel spreadsheet containing two different columns I am wondering how this can be done. This is how table will look
Start Time: End Time: Username Site ID: Description: SAP Ticket# Resolution: Medium
Second part
Start Time: End Time: Contact: Description: SAP Ticket# Resolution:
Please help.
Thanks,
Amit
Can you put them on different sheets rather than different columns?
Arv
I am unclear as to what you are trying to do...
You have...
Code:A B C D E F
Start Time: End Time: Username Site ID: Description: SAP Ticket# Resolution: Medium
Start Time: End Time: Contact: Description: SAP Ticket# Resolution:
Is this what you are trying to end up with?
... where col C would have "dual use" and col F might or might not be used?Code:A B C D E F
Username Site ID:
Start Time: End Time: Contact: Description: SAP Ticket# Resolution: Medium
1 9:30 9:40 Site ID 1 desc1 res1 medium1
2 9:45 9:59 Contact 1 desc2 res2
Spoo
Sorry...Its my mistake. OK let me try to explain you in a better way. We get data for different databases...Lets say Oracle, SQL and access. And each person keeps getting data simultaneously. Someday I might get data related only to Oracle then it would come in part one...If I get data for SQL it should go to part 2 similarly I have part 3 for access and so on. As of now what we do is we enter it in excel sheet and then collate data all users together. Different users enter data from different machines. So basically here it can be first 10 rows for oracle, next 10 rows for SQL and next 10 for Access depending on how many records each person enter which differs.
Arv
OK, that helps. You have 3 posssible "data sources"
1 - Oracle
2 - SQL
3 - Access
But, am I correct in assuming that under any of the above 3
scenarios, you always want to reuse the same cols A thru F?
If so, then it doesn't seem to be too difficult. All you would need to "know"
is which of the 3 data sources you are currently dealing with. Thus
1. Adopt a "common" set of columns that covers all cases (perhaps per my 2nd example)
2. Have 3 branches (one for each data source) to allocate data to the appropriate columns
3. Possibly add another col, say G, to contain the data source (Oracle, SQL, Access)
Does that seem to work?
If so, can you take if from here, or do you still have questions?
I assume that you want to automate this process using VB6.
Spoo