Hi all,

I am pretty new on excel specially on macros, currently I am working on one project at work: I need to pull data from a web and create simple pivot table, i want to manage data according to cell value e.g. cell value name - John, link - www.xxx.com/xxxx/xxx=john&actionxx/x but if cell value is Tom hyperlink updates to www.xxx.com/xxxx/xxx=tom&actionxx/x and creates a pivot table according to it, so how hard to make this and can someone help me or just point to right direction, thanks