Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating report from spreadsheet
Hello,
I would like to make reports in excel based on a spreadsheet In the spreadsheet there are a lot of variables, such as name, company, .... and I would like to make a report with just a few of these variables on a new page. is this possible and how? thankx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating report from spreadsheet
Hi
depends where the variables are and how you want your report to look. If all the data is in columns and you are referring to column headings, then you could hide columns you don't want. If that is all you want then reply with the details. regards Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating report from spreadsheet
Hi,
It's like this. It is a large spreadsheet with more than 2000 lines. Every line represents a person. In the colums is the data that refer to the persons. There are about 20 colums, but I would like to have only some of them in the report. Each report should correspond with one person, so I would like to be able that when for instance when I have a meeting with a client, that I press some button or so and that I get his report. The generated report must not be in the same file or not in excel, but this may. But the generation of the report is my problem,is this with macro's or with templates or so? thankx a lot for the quick response matthias |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating report from spreadsheet
The generated report must not be in the same file or not in excel, but this may. <<
Not sure what you mean here? However, from your brief description, here's what I might try: 1. Create a named range over the column with the list of people's names. 2. On a separate sheet, create a data validation for a cell using that named range as your validation list. This will allow you to have a drop-down box in that cell with the list of all of the people in your database. 3. Have the rest of the page be your template, doing VLOOKUP() functions to retrieve the data from your database based on the value found in the drop-down box you just created. Then, any time you change the value in the drop-down box, your report will change to show data on that person. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Report | Excel Discussion (Misc queries) | |||
creating a report with macros | Excel Worksheet Functions | |||
Creating a report with .jpg files in it | Excel Discussion (Misc queries) | |||
creating an aging report | Excel Worksheet Functions | |||
Creating a report by For Each... | Excel Programming |