+ Reply to Thread
Results 1 to 2 of 2

userform not copying all to sheet

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    747

    userform not copying all to sheet

    hi
    can any one help me with this have gone over and over this till my eyes hurt,and come up with zilch,run scan out (frmissued)/ enter first 3 xes enter different bar codes in first 3 comboboxes, enter 200 location and anything in plant number,click save,all 3 items are sent to sheet3 as should be,
    click scan in (frmret)and log in again,enter the same 3 barcodes you scanned out click save,this is the problem all items returned should match the ones issued if they do sheet3 is updated and entried deleted and sent to sheet4,at the minute all are deleted but only 2 are sent to sheet4
    ,although none are left on sheet3 it looks like it takes all of them off but loses one as its sent to sheet4, can any one put me in the right direction please , this has worked before and I am going through old programs now to see if there is any difference in coding
    cheers colin
    Attached Files Attached Files
    Last edited by cfinch100; 12-17-2013 at 02:18 PM.

  2. #2
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    747

    Re: userform not copying all to sheet

    hi
    found it commandbutton 11 was copying from a3 instead of a2 works a treat
    cheers colin

+ 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] EXCEL USERFORM- pull data from sheet 1 into userform
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 11:10 AM
  2. [SOLVED] Code from tigeravatar ,Copying data from one sheet and copying it
    By DanielRay in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-07-2012, 03:07 PM
  3. Userform - copying the title from new sheet to index page
    By Drew37 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2010, 06:21 PM
  4. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01:06 PM
  5. Copying name supplied in userform to new sheet
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-16-2009, 07:17 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