+ Reply to Thread
Results 1 to 6 of 6

Particular data taken out form input sheet to desire sheet by macro

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Particular data taken out form input sheet to desire sheet by macro

    Dear all, I have two work sheet , one is input sheet where data will be past by manually & another is desire output sheet , so I would like to get data like output sheet which will be taking from input sheet . please check the attachment where I have marked all data as color mark .
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Particular data taken out form input sheet to desire sheet by macro

    OK, I think I've got this. See attachment.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: Particular data taken out form input sheet to desire sheet by macro

    Hi Tinbendr , it works perfectly , no error no bug, everything is alright. Thanks for your valuable time regarding my complex issue. Take care…nur

  4. #4
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: Particular data taken out form input sheet to desire sheet by macro

    Hi Tinbendr, I need once again your assistance. The current date format of cell E2 of my work sheet is dd:hh:mm & its working fine , but I want to keep months before the dd:hh:mm also , it is something like this mm:dd:hh:mm Where starting first “mm:” is for Months , dd: for dates , hh for hours & last one :mm for minutes
    Or
    it will be something like this ddd:hh:mm (i.e 223:11:25 , where 223 is the total dates , 11 is the total hours & 25 is the total minutes ) .

  5. #5
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Particular data taken out form input sheet to desire sheet by macro

    Just play around with the cell format for that column(select column, right click, format) to get what you're looking for.

    If you can't get it, I suggest starting a new thread.

  6. #6
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: Particular data taken out form input sheet to desire sheet by macro

    Hi Tinbendr, ok no issue , by your code i could be able to prepare my report. again thanks. & take care..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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