User Tag List

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Excel Macro's - Any Experts

  1. #1
    Full Member spennny's Avatar
    Join Date
    Jun 2008
    Location
    Blantyre
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default Excel Macro's - Any Experts

    I need a Macro that i can assign to a pivot table , and also to a single spread sheet to update them (Refresh)

    Anyone help, i have tried the record function but cant do it

  2. #2
    Regular Member jlock's Avatar
    Join Date
    Jun 2009
    Location
    London
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats

    Vehicle : BMW 525i

    Trim : M-Sport

    Engine : 2.5l Straight 6


    Default

    ****** pivot tables! Im no help but i know how you feel! Took me ages to work out the ****** things last week!

  3. #3
    Regular Member FatboySteve's Avatar
    Join Date
    May 2010
    Location
    Bedfordshire
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    'Worksheet("SheetName").Calculate' will refresh the sheet.

    Don't use excel much, so not too clued up on pivot tables, but seems to be plenty of info on google, such as..

    http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx

    If you need anymore help, pm me :beer:

  4. #4
    Regular Member rickit's Avatar
    Join Date
    Feb 2009
    Location
    Biggleswade
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Hi Spenny, if you need any help still PM me. I will see what I can do for you. One of the MS apps I use in my job.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MS Excel - Any Experts?
    By Aidi in forum The 'Off Topic' room
    Replies: 3
    Last Post: 22nd April 2012, 17:24
  2. excel help
    By shan in forum General Chat
    Replies: 11
    Last Post: 7th November 2007, 00:33
  3. Excel Formula Experts
    By Damian in forum General Chat
    Replies: 9
    Last Post: 22nd December 2006, 10:08
  4. MS Excel Experts
    By Damian in forum General Chat
    Replies: 4
    Last Post: 24th September 2006, 19:18
  5. Excel Help Please
    By jka in forum General Chat
    Replies: 15
    Last Post: 6th April 2006, 10:42

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!

Bookmarks

Posting Permissions

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