+ Reply to Thread
Results 1 to 2 of 2

Transferring selective data from one table to another with in the same worksheet

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    california, usa
    MS-Off Ver
    Excel 2003
    Posts
    1

    Transferring selective data from one table to another with in the same worksheet

    I have attached an excel file. I am trying to move the information of the last 30 rows of table 1 to be displayed into table 1. In table 1 I only want to display these last 30 rows and would like for it to update automatically as table 2 is modified. I also have some equations that calculate Standard deviation and averages for these last 30 values but, it does not seem to exclude zero or empty cells, how can I fix this? For these equations I want only the last 30rows to be considered and only the non-zero values of within these 30 rows.
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Transferring selective data from one table to another with in the same worksheet

    Is it from Sheet3 into1 or other way around?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ 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. Replies: 1
    Last Post: 04-06-2013, 05:49 AM
  2. [SOLVED] Pivot table query for selective data
    By Excel Dumbo in forum Excel General
    Replies: 2
    Last Post: 07-01-2012, 09:01 PM
  3. Filtering one worksheet and transferring data to another workbooks worksheet
    By medic922 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 09:58 AM
  4. Obtain selective data from different worksheet!
    By Spellbound in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-19-2011, 09:14 AM
  5. Creating new table from selective data in original table
    By rasmussk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2009, 09:46 AM

Tags for this Thread

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