+ Reply to Thread
Results 1 to 4 of 4

vba for tick box , copy selected data from tick box and paste special values and formats

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,145

    vba for tick box , copy selected data from tick box and paste special values and formats

    Hi All

    I have a database of of 750000 rows of data , there is a seach box at G2, when I entered data , a partial match is done and the results appear at G5 .

    starting at L5, checkbox is needed still to last row of data in green columns . When looking the nearest product matching description in database sheet, a tick box at M is inserted to copy the requested data to the next sheets trim description .

    At K2 clear button the clear the records G2, and reset the L check and tick box .

    Apply a new filter at G2 search box with another description , copy in L and M where tick is enable . copy records from data base to trim sheets but do not overwrite the existing data and the process continues

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: vba for tick box , copy selected data from tick box and paste special values and forma

    Hi JEAN1972,

    It would be a great help if you could attach a small sample workbook.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,145

    Re: vba for tick box , copy selected data from tick box and paste special values and forma

    https://drive.google.com/file/d/0B6p...ew?usp=sharing

    See attached trim version of the attachement
    Attached Files Attached Files
    Last edited by JEAN1972; 05-12-2017 at 04:10 AM.

  4. #4
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,145

    Re: vba for tick box , copy selected data from tick box and paste special values and forma

    Internet connection slow see attached below link

+ 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] tick all check box in just one click and then count up the selected tick box...
    By pejoi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-05-2013, 09:13 PM
  2. Copy certain contract codes from One sheet to another with Tick data
    By shreeku in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 10-14-2013, 07:41 AM
  3. Make 1 a tick in a tickbox and 0 no tick
    By ExcelFailure in forum Excel General
    Replies: 2
    Last Post: 04-02-2013, 07:28 AM
  4. [SOLVED] Copy and paste special values and formats
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2012, 07:14 AM
  5. Excel 2007 : one tick box selects multiple tick boxes
    By brentroberts in forum Excel General
    Replies: 2
    Last Post: 12-31-2011, 09:29 PM
  6. Display the legend only if the tick box is selected
    By pauldaddyadams in forum Excel General
    Replies: 0
    Last Post: 07-13-2011, 09:08 AM
  7. Replies: 4
    Last Post: 04-19-2010, 01:02 PM
  8. Place a tick in a cell when selected, untick it if selected again and....
    By hriggs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-14-2009, 09:09 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