+ Reply to Thread
Results 1 to 2 of 2

Copy cell from on sheet to another If the cells starts with ** edit

  1. 12-13-2014, 04:08 AM #1
    John Swift
    John Swift is offline
    Registered User
    Join Date
    10-18-2014
    Location
    Ontario, Canada
    MS-Off Ver
    2013
    Posts
    30

    Copy cell from on sheet to another If the cells starts with ** edit

    Hello and thank you for your help once again

    I have a macro that goes from the bottom up and takes the first 2 digits of a value in column A and creates a new sheet and paste the cuts and copys each value into its rightful sheet i.e.

    AA12345678
    AB12345678
    CC12345678
    DD12345678

    "sheet"AA

    AA12345678

    "sheet" AB

    AB123456789

    "sheet" CC

    CC12345678

    "sheet" DD

    DD123456789

    Code as follows

    Please Login or Register  to view this content.
    This works perfectly

    The issue I have is now I would like this macro to copy the contents of both column A and B as it only copies column A for now but it can be the entire row if that makes it any easier.

    Thank you for you help
    Reply With QuoteRegister To Reply
  2. 12-13-2014, 04:11 AM #2
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Copy cell from on sheet to another If the cells starts with ** edit

    Hi, John Swift,

    instead of
    Please Login or Register  to view this content.
    try
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    I would prefer to Dim your variables as Long.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy cell from on sheet to another If the cells starts with **
    By John Swift in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-06-2014, 05:06 PM
  2. Average formula that starts at first cell>0 and calculates blank cells as 0?
    By bradtredo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-20-2012, 05:54 PM
  3. Excel 2007 : Copy cell to another worksheet if cell starts with a specific string
    By ambar in forum Excel General
    Replies: 15
    Last Post: 03-27-2012, 08:48 AM
  4. Edit code to copy whole sheet
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2008, 08:06 AM
  5. [SOLVED] Query starts a "read only" copy of the source sheet
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2006, 08:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1