+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    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

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,172

    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 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] 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. 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 GorKoUSA@gmail.com 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1