+ Reply to Thread
Results 1 to 3 of 3

Extract partial data from entire column at once by using VBA( without using Loops)

  1. #1
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    Extract partial data from entire column at once by using VBA( without using Loops)

    Hi


    i have one doubt.

    previously, i used to convert text values in entire columns to numbers at once without using "Loops".

    Here is the Code.
    Range("d:h") = Range("d:h").Value

    like above code

    i) i want to convert date&time column to date(mm/dd/yyyy) at once on same "A" column( With Out Loops)
    (1st column (Sold On) in attached sheet. )


    ii) i want to extract partial data from one column to another column at once. (without using loops)

    (in Attachment, For explanation, i used formulas and date formats . But Actually, I need VBA Code for both columns)

    regards
    shiva
    Attached Files Attached Files

  2. #2
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Extract partial data from entire column at once by using VBA( without using Loops)

    Hi, try this:
    Please Login or Register  to view this content.
    Last edited by banaanas; 04-15-2019 at 04:28 AM.
    Tuomas "Banaanas" Savonius
    Trying to give back now when I actually can do some VBA

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Extract partial data from entire column at once by using VBA( without using Loops)

    See if this is what you want

    Attachment 620072


    To test: Click on sheet "Result" and select a different value in cell A1

    Code is in "Result" SHEET module
    Please Login or Register  to view this content.
    This was the code used to convert the format of cells containing dates and times (loop would be required to convert the actual values)
    - code is in Module1
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

+ 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. Replies: 4
    Last Post: 04-02-2019, 12:22 PM
  2. Replies: 0
    Last Post: 08-17-2017, 11:26 AM
  3. [SOLVED] Index can return an entire column, but how about a partial colum?
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2014, 01:00 PM
  4. Need to extract particular details from entire column
    By prakashmak in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-10-2013, 05:27 AM
  5. [SOLVED] How to check if entire column has an partial match from a cell?
    By goljat in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2013, 04:16 PM
  6. Replies: 2
    Last Post: 10-12-2012, 11:18 AM
  7. [SOLVED] [b]Possible to extract this complicated partial data in Excel?[b]
    By deepz12 in forum Excel General
    Replies: 8
    Last Post: 08-14-2012, 12:10 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