Results 1 to 2 of 2

Using pivot table to lookup data from large table, but would like to edit

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Using pivot table to lookup data from large table, but would like to edit

    I have a worksheet (Data Entry) that I use to enter data onto and there's a button to move the data into a table on another worksheet (Database). I also have a pivot table with a slicer that I use to retrieve data from this growing table in order to review it.

    What I'd like to be able to do is edit the data that I retrieve from the Database page without having to go to the Database page to do it.

    I've attached an example of the workbook.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Large data set, pivot table and percentages
    By bladewalker in forum Excel General
    Replies: 0
    Last Post: 02-28-2012, 03:32 AM
  3. Excel pivot table? Edit pivot table sub catagory
    By Bowtye8 in forum Excel General
    Replies: 3
    Last Post: 02-23-2012, 02:25 PM
  4. Sorting through large amounts of data (pivot table, sql)
    By Heim in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2009, 09:25 AM
  5. How to edit the Pivot Table data range?
    By smartcard in forum Excel General
    Replies: 1
    Last Post: 12-26-2006, 04:57 AM
  6. How to edit pivot table data source??
    By KitenutDave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2006, 05:40 PM
  7. [SOLVED] large data file problems - pivot table with vba
    By seyenmeup@prodigy.net in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2005, 10:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1