+ Reply to Thread
Results 1 to 9 of 9

Auto Transfer Rows Once Complete

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Auto Transfer Rows Once Complete

    Hi,

    Hope someone could help me please, I've attached a log of how i want it to look, but i cant figure it out

    Basically when a person completes all fields on a row on their tab id like the row copied over to 'Main Sheet' and if any amendments are made id like the data to change auto on main sheet. Also id like the ability if possible to change the Person tabs to other names etc.

    Any help would be amazing, thanks


    Sorry had issues with file size, i want more tabs with users names on and id like them fed into the main sheet, if poss
    Attached Files Attached Files
    Last edited by excelnoobHEINZ; 10-10-2014 at 06:31 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Auto Transfer Rows Once Complete

    ...and are you going to upload the workbook?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Auto Transfer Rows Once Complete

    Sorry i think it exceeds the file size limit, just trying to reduce it now

  4. #4
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Auto Transfer Rows Once Complete

    Quote Originally Posted by Richard Buttrey View Post
    ...and are you going to upload the workbook?

    uploaded

    cheers

  5. #5
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Auto Transfer Rows Once Complete

    Ive just found this http://www.excelforum.com/excel-prog...ter-sheet.html

    But i cant duplicate it for what I need

  6. #6
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Auto Transfer Rows Once Complete

    any ideas? thanks

  7. #7
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Auto Transfer Rows Once Complete

    Can anyone help with this please?

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Auto Transfer Rows Once Complete

    Maybe:

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Auto Transfer Rows Once Complete

    Quote Originally Posted by JOHN H. DAVIS View Post
    Maybe:

    Please Login or Register  to view this content.
    Thanks so much for replying, but ive tried to add this to the macros on the document but it doesnt seem to kick in

+ 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. transfer data of a complete row if certain criteria completed
    By hriazm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2013, 10:37 AM
  2. Data Transfer upon Invoicing complete
    By dyjoshi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 08:34 AM
  3. Auto Complete/Auto Fill address field
    By moates in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-09-2012, 09:15 AM
  4. Auto Complete/Auto Percentage Formulas
    By AgentDirtySanchez in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-08-2010, 09:49 PM
  5. [SOLVED] Auto transfer rows from 1 sheet to another by account code.
    By Syd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2006, 12:10 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