Beginner Question

[jeffwest1]

I have used VBScript in Excel, but not for a while, so excuse the rather long winded question.

I have a crystal report that quite happly will export out the data I need into excel, this data contains a single entry for a number of users, each with a unique number.

I want to add the data into individual spreadsheets for those people, so want to have a macro to examine the export data, and populate a series of spreadsheets from that data based on a unique identifer.

Although for January I may have 75 people, Feb I will have 100, while these are in identifer number order becase there may be gaps i.e.
Jan 1,2,3,5,7,9
Feb 1,2,4,5.6.7.9

I cannot just hardcode links from output spreadsheet to individual spreadsheet, as they may not be in the same place each time, anyone know or give me a clue as to how VB code can do a search and populate accordingly.


--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.

 

[SkipVought]

Is this really a VBScript question or is it a VBA forum707 question.

Either way, we need to know more about the report (yuk! I hate most reports, as they are not in true tabular format) to know if we have to do acrobatics to analyze the data or built-in Excel functionality, that, in most cases, is a breeze.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[jeffwest1]

Possibly a VBA question

Report is like this
Jan
1 25
2 56
3 78
5 99
7 56

Feb
1 43
3 22
4 29
5 67
6 65

Down the list until it finishes.

The numbers on the left hand side are the unique staff identifer, the number on the right is a calculated value.

As I said, the numbers on the left may be different from month to month as different members of staff do work that this report is based around.

This is to be done around 6 measures, which I need to populate a spreadsheet per staff member (approx 150 staff), each month.

The crystal report bit is fine, crystal delievery will export the data into excel, but it's getting that data into the individual spreadsheets, without doing it manually, that is causing the issue.

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.

 

[SkipVought]

Yuk! Again. A typical REPORT output that is nearly useless!

In order to be able to use Excel features, the data needs to be beaten into a tabular format like...
[tt]
Mo ID Valu
Jan 1 25
Jan 2 56
Jan 3 78
Jan 5 99
Jan 7 56
Feb 1 43
Feb 3 22
Feb 4 29
Feb 5 67
Feb 6 65
[/tt]
So that ought to be your first order of business. I'd get the output done the way you need from CR. It would be a snap!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[jeffwest1]

Cheers for that, need to look at this in a bit more detail and see if i can get the report amended.

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.