+ Reply to Thread
Results 1 to 2 of 2

Move data from Listbox to another then export data in excel sheet

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Move data from Listbox to another then export data in excel sheet

    dear All expert
    send for all my greeting
    please kindly can someone help me in the attached file for the following
    In my attached file you will find 3 sheet
    1-export Listbox (data exported from Listbox2) and you will find command show userform Data in listbox1 will be from Database Column B
    2-Generated Data sheet , that from Exported Data in fist sheet , this data
    will be generate as the following
    Each operator Have 11 Location and 1 or 2 or 3 run according to choice
    meaning for example
    We select operator HH1 and three run
    meaning data will be as sheet (Generated Data)
    if another Operator choice will repeat it as the same for operator according to number of run as in attached file with operator HH8
    3-Database sheet Which Have location and operator and runs

    my problem as the following
    in listbox1 sometime is come clear , i don't know why ?i think the code not connect specifically to database sheet , i think it for active sheet
    also
    code for generate data is not working and i cant add checkbox to this code i found in internet
    export code also not working , i just want to export all filled column in Generated data sheet to new workbook with name (print) but in folder named with date and time for the same directory of excel file present

    also if want to give me error message if i didn't select any checkbox in Select type
    and give me also error message if i didn't select run number
    hope you can understand what i mean
    if any thing not clear you can ask
    regards for all and hope happy night
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: Move data from Listbox to another then export data in excel sheet

    Please Can someone help me in this task

+ 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. Search ListBox, Move Data and Delete Source Data
    By Andyw111 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2018, 03:31 AM
  2. Export All Data of a Listbox items to Excel sheet
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2018, 08:13 AM
  3. Export VBA Data for to other sheet in excel ?
    By syed82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2013, 03:37 PM
  4. Excel data (sheet data + charts) export to ppt presentation
    By pntuehut99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2012, 05:55 AM
  5. Replies: 1
    Last Post: 07-08-2010, 06:10 AM
  6. export excel data to another sheet
    By owl527 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2006, 07:22 AM
  7. Is it possible to export Excel sheet data to..
    By avinoam.aharoni in forum Excel General
    Replies: 1
    Last Post: 07-14-2005, 01:05 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