+ Reply to Thread
Results 1 to 6 of 6

Help creating vba function to move data from table to table on if condtion

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    israel
    MS-Off Ver
    Microsoft Office 2013
    Posts
    58

    Help creating vba function to move data from table to table on if condtion

    Hey,

    i have a table name day 1. in everyday problems are been open and close (or not opened at all).
    i need to create a function that if a problem wasnt solved and closed in that day, it will copy the data of that problem (name, num, time.. etc) to the next day
    without leaving empty rows (not based on the problem's row in the day before).

    here is an example (not a function) to show you what i mean more clearly:


    thanks for your help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Help creating vba function to move data from table to table on if condtion

    Hi
    Have you looked at the built-in Advanced Filter Function, this will do what you are after.
    Hope this helps.
    Tony

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    israel
    MS-Off Ver
    Microsoft Office 2013
    Posts
    58

    Re: Help creating vba function to move data from table to table on if condtion

    Hi Tony,
    Thanks for your answer, where can i find that built-in AFF?
    And i need this to be automatic because i have also sheets with weeks containing these tables.

  4. #4
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Help creating vba function to move data from table to table on if condtion

    Hi
    Have a look at this link:

    http://www.contextures.com/xladvfilter01.html

    Good luck.
    Tony

  5. #5
    Registered User
    Join Date
    10-29-2013
    Location
    israel
    MS-Off Ver
    Microsoft Office 2013
    Posts
    58

    Re: Help creating vba function to move data from table to table on if condtion

    Hi, thanks for answering.

    i have had a look, and its not what i need. even if you use macro it not good because there's more than 1 week and i need to reffer it.

    i need that if a cell is not fill, place the data in the next table. is there any way to do that in vba?

  6. #6
    Registered User
    Join Date
    10-29-2013
    Location
    israel
    MS-Off Ver
    Microsoft Office 2013
    Posts
    58

    Re: Help creating vba function to move data from table to table on if condtion

    Bump, help please

+ 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] Formula for creating a table from data from another table
    By amasson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-12-2013, 09:35 AM
  2. Creating a table using a spreadsheet as a function
    By whk051 in forum Excel General
    Replies: 3
    Last Post: 11-13-2012, 10:34 AM
  3. Replies: 1
    Last Post: 08-31-2012, 09:52 PM
  4. 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
  5. Creating Monthly Data Table from Weekly Data Table
    By nhojflies in forum Excel General
    Replies: 15
    Last Post: 06-19-2009, 09:11 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