Macro to extract and list data on a new sheet

Hello there below is a macro that will filter the workbook "short coded ambient allocations 160712.xls" by the individuals name when you click on the macro.

To insert the macro, right click on the "Allocations" worksheet tab in the "WAREHOUSE WASTAGE 2012(1).xls" workbook and select view code.

This will bring up Visual Basic. In the blank space provided Paste the below code. Anything that appears in green is a comment I made that is meant to help you understand the code.

Please Login or Register  to view this content.

Close out of Visual Basic. Now whenever you click on a hyperlink the code will run and filter the other workbook by the name.

Let me know if this works for you!

Thanks!

RVASQUEZ

Hi RVASQUEZ

Thanks very much for that, but i have a problem. I will be adding lots of different short coded ambient allocation sheets with different names.

Is it possible to amend this code so no matter what sheet the hyperlink points to i will get the same result?

great start though, thank you very much, i did not think this would be possible

Hello there,

Try replacing the code I supplied earlier with this instead:

Please Login or Register  to view this content.

Thank you very much my friend, Problem solved