Need help to fetch data from other sheet based on Resource Name

Here is some VBA code that will do what you want, however to make this work, you will need to unmerge all the cells in rows 5 and 6 or the code will not work. VBA does not play well with merged cells. Place a command button on your Summary worksheet and attach this code to the button.

Please Login or Register  to view this content.

@Alan:

you could probably get away with using column F to determine the last row. Then you can leave the merged cells alone.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

What can I say? It doesn't do that for me with the sample file that you uploaded. I didn't change the structure of any of the sheets. I just copied and adapted Alan's code, and then added the extra lines to clear the data before refreshing.

I think you need to look at the layout of your live workbook. The code, as it stands, should not be trying to clear any merged cells.

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Please Login or Register  to view this content.