Results 1 to 5 of 5

vba to copy numerical data only in first column ,if found copy whole row to another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,142

    vba to copy numerical data only in first column ,if found copy whole row to another sheet

    Hello All

    I have a sheet from an external interface that requires to copy specific rows to another sheet in same workbook

    The data that I need to copy starts from column A with a header name poste there are numerical data with blanks cells some are alphabetic or alpha numeral.

    My concern is to copy the rows with numeric data only ,that is it starts with 01 , 10,55, 190,1000 and so on , the maximum will be 4 digits only in column A.

    looking a vba code that lookup these digits on column A , once found copy the whole row still to column A TO I .

    the rows concerned are in yellow in sample sheet and expected results in sheet tab.

    However the expected sheet results may have blanks or scattered data , this is normal , I will adjust accordingly.

    The sheets data shows up 10000 rows which is quite painfully.

    Can anyone assist thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-09-2017, 05:36 AM
  2. Replies: 1
    Last Post: 02-09-2017, 05:30 AM
  3. VBA to searc column for a value and copy the row(s) to another sheet when found
    By brockj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2014, 03:27 PM
  4. [SOLVED] Copy row from one sheet and paste to another if a key word is found in 1 column of sheet 1
    By killdozer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2014, 02:27 PM
  5. Replies: 3
    Last Post: 03-31-2014, 01:00 PM
  6. Replies: 16
    Last Post: 01-20-2013, 09:40 AM
  7. Replies: 2
    Last Post: 03-16-2009, 12:26 PM

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