Exporting info for a report

C

cruyff73

New Member
Joined
Oct 7, 2016
Messages
32
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:

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You must log in or register to reply here.

Similar threads

drom
  • Question Question
SUMPRODUCT to count dependent validation list column with wrong items
Replies
1
Views
277
drom
drom
S
  • Locked
  • Question Question
Summary Report
2
Replies
13
Views
658
Fluff
Fluff
F
  • Question Question
Macro that copies and pastes from each file into formatted master sheet with merged cells
Replies
1
Views
950
OaklandJim
O
M
  • Question Question
Exported report manipulation to break up exported text box and create new rows
Replies
0
Views
301
Matt1214Excel
M
R
  • Question Question
Risk Assessment
Replies
1
Views
486
fjns
F

Forum statistics

Threads
1,224,811
Messages
6,181,081
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top