Generating Reports

**V for Visual Basic** · 08-23-2009, 02:46 PM

Hi,

I have created a spreadsheet for work that lists people's capabilities on different software, their skills in different work areas etc.

This matrix has around 25 people listed in it (vertically in column C) and around 40 different fields (horizontally in row 11). As a result, this takes up 2 A3 sheets to print off in a font large enough to read, which will be a bit of a pain for people to use in 121s, and when reviewing personal development plans.

What I'm looking to have is a worksheet within the matrix that contains all the fields arranged in such a way that each person's report will fit on one page of A4. The worksheet has been drawn up, but I am totally stuck for how to set it to automatically populate the relevant fields when a member of staff's name is selected.

I was thinking of using vlookup, hlookup or IF, but I think this would end up with a lot of overcomplicated formulae (25+ per field).

Any help would be much appreciated.

**JBeaucaire** · 08-23-2009, 04:15 PM

Go ahead and post up your workbook. Setup your desired output sheet so we're clear on the goal.

Sanitize the data by removing the company name and replacing the real names with generic ones.

Then click GO ADVANCED and use the paperclip icon to post up your workbook.

**V for Visual Basic** · 08-23-2009, 04:49 PM

I'll do this tomorrow as it's on my work laptop, which I'm not allowed to hook up to my home internet.

**Redwood** · 10-21-2009, 06:50 PM

Did this get dropped or is the followup someplace else I can't find? I'm dealing with a similar situation and would love to see how this was worked out.