Results 1 to 13 of 13

VBA To change Date format in Column A and Copy a cell if it contains specific Text

Threaded View

zaska VBA To change Date format in... 01-08-2016, 06:45 AM
kvsrinivasamurthy Re: VBA To change Date format... 01-08-2016, 10:33 AM
zaska Re: VBA To change Date format... 01-08-2016, 11:48 AM
LJMetzger Re: VBA To change Date format... 01-08-2016, 03:52 PM
zaska Re: VBA To change Date format... 01-08-2016, 08:13 PM
LJMetzger Re: VBA To change Date format... 01-09-2016, 01:13 PM
zaska Re: VBA To change Date format... 01-09-2016, 01:43 PM
zaska Re: VBA To change Date format... 01-10-2016, 08:25 AM
LJMetzger Re: VBA To change Date format... 01-10-2016, 08:58 AM
zaska Re: VBA To change Date format... 01-10-2016, 09:03 AM
zaska Re: VBA To change Date format... 01-10-2016, 10:37 AM
LJMetzger Re: VBA To change Date format... 01-10-2016, 10:41 AM
zaska Re: VBA To change Date format... 01-10-2016, 10:45 AM
  1. 01-08-2016, 06:45 AM #1
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    454

    VBA To change Date format in Column A and Copy a cell if it contains specific Text

    Hello,

    I have huge set of data and I want to make the following changes using vba.

    1. Change date format in Column "A" to dd.mm.yyyy

    2. When a row in Column "B" begins with word "Being" then cut and past the same in Column "I".

    I am herewith attaching the raw data.

    Thank you

    Regards,
    Zaska
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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] In a specific column find text and change the format
    By Louisa Venter in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-22-2015, 02:43 PM
  2. [SOLVED] Finding specific text and change the format
    By Louisa Venter in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2015, 05:11 PM
  3. How to concantenate a specific date format with a text cell in excel
    By vrachimis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2015, 05:04 AM
  4. [SOLVED] how do I format a column to change color when another column has a specific word in it?
    By officegirl14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2014, 06:15 PM
  5. [SOLVED] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  6. [SOLVED] IF column = specific text then copy value from another cell along the same column
    By Lifeless in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2013, 04:15 PM
  7. Change date format of a specific Cell?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2006, 07:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1