Generation & editing of Data view Macro's

Hi guru's,

I want to learn how to edit & create macros in planning Book.as i am facing some problem in data view of planning book.

Please guide me by providing some basic funda's & if any study material...

Thanks in advace

regards

Kiran