Excel spreadsheet to produce a report per row

Hi - does anyone know if there is a way to produce a report per row of an excel spreadsheet. For example if my spreadsheet contains the names of 10 people in column one and lots of columns of data per person. Is there an easy way for me to pull all that data to produce a one page report for each person listed with the data within it?

Thank you

Hi bankcott,

Please post an example of what you are trying to achieve.

Are you comfortable with a macro solution?

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi David - I am happy with any easy solution to this problem. I am not at all familiar with macros (and not at all an expert on Excel) but if they would be the answer then that is fine. I have attached a rough example - there would be quite a lot of different data types added to the main spreadsheet.

Thank you - appreciate any advice.

Use vlookup function

Originally Posted by thameem127

Use vlookup function

I'd do this, but I would also base it on a drop-down selection box.

@Bankcott - can you attach an example spreadsheet?

Instead of a picture in Word, can you attach the Excel Workbook please?

It will be a lot easier to work with!

Thanks,

David

Attachment 298606Apologes... now attached. Thank you

Thank you - I am not sure how this would produce a single report per person on the spreadsheet though? Can you advise?

Originally Posted by AliGW

I'd do this, but I would also base it on a drop-down selection box.

@Bankcott - can you attach an example spreadsheet?

Hi bankcott,

This is what I would do:

bankcott - transpose data.xlsx

The name box has a simple Data Validation drop down box, and the cells are using VLOOKUP!

I also attached a sheet using TRANSPOSE (from the Paste Special options). This almost gives you what you want, but not as good as the VLOOKUP solution.

Regards,

David


When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Thank you David - I can see how this will reverse the information. Do you know then after this if there is a way however of really easily and simply saving each persons information as a separate sheet so that it can be attached to a file on their own record in a separate system? Thank you.

Hi bankcott,

It is easy with Excel 2010!

Simply move the table I created at A13:C21 to another sheet. (YOu will have to change the dropdown so that it looks at a named range instead of A3:A8).

Then file save as and give it a name, and in the Save as type box scroll all the way down near the bottom of the drop down where you will find PDF. Select this, and click save. You will see the PDF version.

Regards,

David


When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Thanks David - that will create a pdf though with all the names of all those listed I think?

Perhaps I am asking for the impossible but I need to be able to produce one sheet per person with just that person's details on it. I need to then be able to easily pick up the file for each person created to attach to a record on the computer.

Thank you David - I see how this works now. Thank you so much for your help with this. Bankcott

Thank you Paul - this is another option that I had not considered so thank you for this. Most helpful.