Can you supply an example doc, its is almost impossible to imagine the layout and format? Also to you have a list of the names to look up in an excel ...
i have had a quick look You seem to be doing quite a bit in the Macro and i think yoiu need to try and understand what is happening - do you know h...
I have not found a simple way of doing this. there seems to be ways with extra pivots/powerpivot or VBA but nothing straight forward. It is possibl...
Can you post the dummy data so that we dont have to waste time recreating it (probably incorrectly)
Adding a workbook example is always better than adding a screen dump as we have to recreate data to doing any testing as far as know you only have ...
Just a quick comment - with out seeing the data in the reports/extracts that the macro is opening it would be very difficult to know why the macro tak...
To my knowledge the sort function doesnt exist in Excel 2013 Which might explain when its hanging when trying to open
Do you have an example of the code you are using? much easier to view and amend an example workbook When it comes to sending mails via VBA this sit...
If it just the button you want to remove then add in ActiveSheet.Shapes.Range(Array("CommandButton1")).Delete after the Set Wb2 = ActiveWorkb...
Sorry, completly forgot Tried to make it as flexible as possible, might be overkill you need to put the destination Drive,Workbook name, sheet n...
As mentioned earlier - if you add an example workbook we can see what we are dealing with and it makes writting the code much easier
What do you mean by only 1 page? how is the sheet formatted? Its always best to add an example file so we know what you want and how stuff looks
Its better if you put the question on the message board rather than in the file, so we can see what you are after easier. I have added a helper col...
Can you please add an exmaple work book rather than a picture? The resolution is poor so you cant see anything and it save us having to re-create a se...
Maybe the password is conflicting with one of the updates the code is doing. Definitely get it tested without the password and then if it works, we ca...