JohnB01012001
New Member
- Joined
- Jul 27, 2007
- Messages
- 1
I need help to generate a report and I'm hoping there's someone out here who can spare a moment. I'm not sure how to do this.
(Sorry, I'm on a managed machine and cannot download any software from the web site).
Column 1 is a list of programs.
Row 1...Col 1: Value "Prog A"
Row 2...Col 1: Value "Prog B"
Row 3...Col 1: Value "Prog C"
Row 4...Col 1: Value "Prog D"
Columns 2 - 4 are a list of systems (Same spreadsheet tab).
Row 1...Col 2: Val: "Sys 1"....Col 3: Val "Sys 2"....Col 4: Val "Sys 3"
Row 2...Col 2: Val: "Sys 5"....Col 3: Val "Sys 2"....Col 4: Val ""
Row 3...Col 2: Val: "Sys 1"....Col 3: Val "Sys 3"....Col 4: Val ""
Row 4...Col 2: Val: "Sys 3"....Col 3: Val "Sys 4"....Col 4: Val "Sys 5"
I need a report that lists programs by system:
System Name. Program
Sys 1............. Prog A
..................... Prog C
Sys 2............. Prog A
..................... Prog B
Sys 3............. Prog A
..................... Prog C
..................... Prog D
Sys 4............. Prog D
Sys 5............. Prog B
..................... Prog D
Programmers can key in any program name or system name value they want in the spreadsheet. I don't know what values they'll key.
This report needs to list each system name only once, with the ability to report on as many programs they've entered.
I'll need to do some additional lookups from other tabs in the same spreadsheet. But I'd thought I'd try to crawl before I walk.
Thank !!!
P.S. I don't know any VB or Access.
(Sorry, I'm on a managed machine and cannot download any software from the web site).
Column 1 is a list of programs.
Row 1...Col 1: Value "Prog A"
Row 2...Col 1: Value "Prog B"
Row 3...Col 1: Value "Prog C"
Row 4...Col 1: Value "Prog D"
Columns 2 - 4 are a list of systems (Same spreadsheet tab).
Row 1...Col 2: Val: "Sys 1"....Col 3: Val "Sys 2"....Col 4: Val "Sys 3"
Row 2...Col 2: Val: "Sys 5"....Col 3: Val "Sys 2"....Col 4: Val ""
Row 3...Col 2: Val: "Sys 1"....Col 3: Val "Sys 3"....Col 4: Val ""
Row 4...Col 2: Val: "Sys 3"....Col 3: Val "Sys 4"....Col 4: Val "Sys 5"
I need a report that lists programs by system:
System Name. Program
Sys 1............. Prog A
..................... Prog C
Sys 2............. Prog A
..................... Prog B
Sys 3............. Prog A
..................... Prog C
..................... Prog D
Sys 4............. Prog D
Sys 5............. Prog B
..................... Prog D
Programmers can key in any program name or system name value they want in the spreadsheet. I don't know what values they'll key.
This report needs to list each system name only once, with the ability to report on as many programs they've entered.
I'll need to do some additional lookups from other tabs in the same spreadsheet. But I'd thought I'd try to crawl before I walk.
Thank !!!
P.S. I don't know any VB or Access.