Need help creating a macro

[shaikhstonevilla]

Hi,

Thank you for reading this thread.

I need your help creating a macro.

I have two excel spreadsheets. .i.e 1) Pivot table 2) Reports. (Report file is shared).

The data in the both spreadsheets is as under.

Column A) Client names
Column B) Outstanding balance.

I want to create a macro which

1) Refresh and save Pivot Table file in every 5 minutes automatically even if I do not open it.
2) In Report file, Outstanding balance figure should come from the pivot table.
3) Auto save Report file in every 5 minutes.
4) Delete entire row/rows if outstanding balance is zero in report file. And save the file in every 5 minutes.

Please help me creating a macro if possible.

Many thanks,
Tim

 

[pvr928]

Hi shaikhstonevilla

I've looked over your previous posts and, like this one, they are generally open ended questions. It is therefore no surprise to me that none of your posts have responses that answer your questions.

For example:

Delete entire row/rows if outstanding balance is zero in report file

immediately begs the questions:

• which rows
• which worksheet
• what is the reference of the 'outstanding balance'
• what is the 'report file'

Without basic information like this, no-one can help you.

There are brilliant people on this post (myself excluded), but none of them can read minds.

It would increase the chances of resolving your questions if you can be as specific as possible. That generally means posting code or formula you have attempted to use without success, and pointing out what you want that code/formula to achieve, including the nature of any errors you are experiencing.

Have fun!

cheers

pvr928