+ Reply to Thread
Results 1 to 6 of 6

vba to fill header value to apply to below cells of nonblank

  1. 06-25-2013, 01:59 AM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    vba to fill header value to apply to below cells of nonblank

    Dear experts

    good morning

    I have sheet called FILLDATES contains in column headings range(d2:BE2) some dates i want fill the dates till end of text value in column(C:C) macro apply to same procedure to every column heading to fill date to end cell...
    please find the attachment you may understand better than what i describe here i inserted outlike file which is i am looking for output


    thanks to all
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-25-2013, 03:13 AM #2
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: vba to fill header value to apply to below cells of nonblank

    How about this,

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 06-25-2013, 04:31 AM #3
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: vba to fill header value to apply to below cells of nonblank

    Wow NIce Dude !!! Works Fine
    Reply With QuoteRegister To Reply
  4. 06-25-2013, 04:45 AM #4
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: vba to fill header value to apply to below cells of nonblank

    No problem, remember to say thanks.
    Reply With QuoteRegister To Reply
  5. 06-25-2013, 04:52 AM #5
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: vba to fill header value to apply to below cells of nonblank

    Thanks alot
    Reply With QuoteRegister To Reply
  6. 06-25-2013, 12:23 PM #6
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: vba to fill header value to apply to below cells of nonblank

    dude can you help me out on this threat? this is my old thread
    http://www.excelforum.com/excel-prog...36#post3293436
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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