Consulting

Results 1 to 2 of 2

Thread: Dataset updates changing the pivot table

  1. #1
    VBAX Newbie
    Joined
    Sep 2017
    Posts
    1
    Location

    Red face Dataset updates changing the pivot table

    Excel 2016.
    Hi! I am completely new to VBA and wondering what codes to use - the thing is that I have an dataset that gets bigger over time. These additional lines of data gets added at the end of the dataset every month and the optimal thing for me would be if this updated dataset automatically updated the pivot table which in turn updated the different cash flows/figures. Can you please help me get started?

  2. #2
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    if you post a sample workbook someone could help you. an idea is to make your dataset a named range.



    Heres a tutorial to help you.

    https://www.extendoffice.com/documen...mic-range.html
    Peace of mind is found in some of the strangest places.

Tags for this Thread

Posting Permissions

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