Need help creating a macro
Results 1 to 2 of 2

Thread: Need help creating a macro
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2012
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need help creating a macro

    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

  2. #2
    Board Regular
    Join Date
    Oct 2002
    Location
    Sydney, Australia
    Posts
    790
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help creating a macro

    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
    Last edited by pvr928; May 10th, 2016 at 09:41 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •