Exporting info for a report

cruyff73

New Member
Joined
Oct 7, 2016
Messages
23
Hi,

I've got a spreadsheet to record accuracy of my team (example below) and I need to present it in a more user-friendly format. The sheet is populated by staff filling in a userform so I can't change the format. The info I need to show would be columns A-E and the headings in F-R but only where an error is shown (ie. Row 13, I would need A-E @ F1 along with the descriptor and comment in F13 & G13). Really can't think where to start. Is it even possible?

Thanks
 
Last edited:

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,109,073
Messages
5,526,651
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top