I have a pivot table with datas starting from the cell A5. A5 has the
name of a person while the rest of the cells have the informations.
Now, if I press cell D5, which is the last cell associated with the
name in A5, I get the details of all the datas of A5 in a new sheet.
Now, I want to make a macro which would allow me to click at D5, save
the report in a new workbook and save it as the name appearing in A5.
Next, it should click D6, again and save it as the name appearing in A6
and so on until all the cells with values are clicked (ie. range ("d5")
I would be very grateful if someone can throw a light on how to do
this.