Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

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

  1. #1
    Join Date
    16th June 2017
    Posts
    4

    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.

    Capture.JPG


    Above my current code.

    Capture1.jpg



    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.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd April 2007
    Posts
    3,886

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    16th June 2017
    Posts
    4

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

    Quote 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.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    23rd April 2007
    Posts
    3,886

    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?

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    16th June 2017
    Posts
    4

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

    Quote 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.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    26th January 2011
    Location
    Steamboat Springs
    Posts
    755

    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 their reputation button (*) below their name.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 1
    Last Post: March 26th, 2013, 18:51
  2. Replies: 1
    Last Post: May 25th, 2011, 21:01
  3. Copy and paste cell from one sheet to another
    By IBSUB in forum Excel General
    Replies: 1
    Last Post: April 2nd, 2011, 06:29
  4. Copy Cell From Specific Sheet & Paste To Active Sheet
    By Lucy GP in forum Excel General
    Replies: 2
    Last Post: April 1st, 2008, 13:40
  5. VBA : Copy a cell from sheet 1 and paste it on sheet 2
    By xWolfiex in forum Excel General
    Replies: 3
    Last Post: January 10th, 2004, 05:02

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
  •  
porno