It has been a while since I have done any VB programming and never any VBA.
I am trying to design a macro that will Create a new sheet called Prime Broker
then go into a sheet called Daily Summary by Value Date find every row in column D with a certain name (if its not to hard maybe have a pop up box to ask for the name) then open links in the corresponding rows in columns M, O, Q, S and U then copy and paste the information in the new sheets that those links open up into Prime Broker.
Thanks for any help!
I am trying to design a macro that will Create a new sheet called Prime Broker
then go into a sheet called Daily Summary by Value Date find every row in column D with a certain name (if its not to hard maybe have a pop up box to ask for the name) then open links in the corresponding rows in columns M, O, Q, S and U then copy and paste the information in the new sheets that those links open up into Prime Broker.
Thanks for any help!
