Announcement

Collapse
No announcement yet.

Tick the checkbox and transferring the checkbox that i tick Data to another sheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Tick the checkbox and transferring the checkbox that i tick Data to another sheet



    Hello everybody.

    I am doing some lists of items of items to sell away. The items I have are in sheet1 and sheet2.
    But I want them to tick in checkbox and the details of the items together with the pricing will move to Sheet3.

    So its something like this in both sheets:

    Click image for larger version  Name:	Capture.PNG Views:	0 Size:	71.9 KB ID:	1221358

    And my sheet3 looks like this:

    Click image for larger version  Name:	Capture.PNG Views:	0 Size:	6.7 KB ID:	1221359

    So how do I make the checkbox that i tick to go to my sheet3 in place?
    Last edited by rumilinus; 1 week ago.

  • #2
    Please attach an example file
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

    Comment


    • #3
      Originally posted by royUK View Post
      Please attach an example file
      Good day Roy!

      Here is the attachment.
      Attached Files

      Comment


      • #4
        Do you want to copy from Columns B & S to the other sheet?

        Hope that Helps

        Roy

        New users should read the Forum Rules before posting

        For free Excel tools & articles visit my web site

        RoyUK's Web Site

        royUK's Database Form

        Where to paste code from the Forum

        About me.

        Comment


        • #5


          Originally posted by royUK View Post
          Do you want to copy from Columns B & S to the other sheet?
          Hi Roy.
          Sorry for the latest reply.
          Yes, I want to copy Column B and S only to other sheet when i check the checkbox.

          Comment

          Working...
          X