Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Copy & Paste 1st 6 digits of a cell to another sheet.

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

  • Copy & Paste 1st 6 digits of a cell to another sheet.

    Hi,

    I'm trying to copy and paste only the first 6 digits for a cell to another macro written excel file.

    Click image for larger version

Name:	Capture.JPG
Views:	1
Size:	40.8 KB
ID:	1158172


    Above my current code.

    Click image for larger version

Name:	Capture1.jpg
Views:	1
Size:	62.8 KB
ID:	1158173



    Data i'm trying to copy and paste.
    i only want to copy the 1st 6 digits.
    Right is the data source and left is what i'm getting now.


    Possible to write a code that allow me to only copy the first 6 digits and paste into another sheet.
    Thanks in advance.

  • #2
    Re: Copy & Paste 1st 6 digits of a cell to another sheet.

    Formulas like =LEFT(Sheet1!A1,6) will get the data to the new sheet.

    Comment


    • #3
      Re: Copy & Paste 1st 6 digits of a cell to another sheet.

      Originally posted by mikerickson View Post
      Formulas like =LEFT(Sheet1!A1,6) will get the data to the new sheet.
      Does this works on a different file too?
      As I export data from another excel file using "ctl r" function to run it.

      Comment


      • #4
        Re: Copy & Paste 1st 6 digits of a cell to another sheet.

        It is a basic Excel formula that takes data from a different worksheet. What happened when you tried it?

        Comment


        • #5
          Re: Copy & Paste 1st 6 digits of a cell to another sheet.

          Originally posted by mikerickson View Post
          It is a basic Excel formula that takes data from a different worksheet. What happened when you tried it?
          I got an over stack error.

          Comment


          • #6
            Re: Copy & Paste 1st 6 digits of a cell to another sheet.

            Show us the formula you used. Without seeing what you have and what you have done, we have no idea what the issue is.
            Alan

            Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
            FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

            If someone has helped you, say "thank you" by clicking on the Like Button.

            Comment

            Trending

            Collapse

            There are no results that meet this criteria.

            Working...
            X