+ Reply to Thread
Results 1 to 2 of 2

auto convert data from dynamic table to static data

  1. #1
    Registered User
    Join Date
    02-23-2015
    Location
    Rotterdam
    MS-Off Ver
    2010
    Posts
    28

    auto convert data from dynamic table to static data

    Best,

    I have a table that pulls data of active projects. Once the projects are finished they disappear. I want to build a historic data log on another sheet to track certain variables. So I need the data of the finished projects to be copied to another sheet automatically before they disappear. Because this involves a lot of projects I am searching for a way to do this automatically.

    Any help would be great.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,078

    Re: auto convert data from dynamic table to static data

    It would help us to attach your workbook and explain in details what you want to do. An example would also be appreciated.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Making dynamic data static
    By clarkyblade in forum Excel General
    Replies: 2
    Last Post: 08-07-2014, 08:44 AM
  2. [SOLVED] Moving static data corresponding with dynamic data
    By caseys_93 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-19-2014, 06:11 AM
  3. [SOLVED] Convert Dynamic Cell to Static when Date Changes
    By SteveG1965 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-10-2013, 09:04 AM
  4. Convert a dynamic data range into a table
    By Bippa88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2013, 03:08 AM
  5. Auto-refresh of static data alongside live data
    By lamexuk in forum Excel General
    Replies: 0
    Last Post: 03-15-2011, 06:16 AM

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