Results 1 to 10 of 13

Thread: Need an Autofill VBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 05-13-2014, 06:23 PM #1
    mrprofit
    mrprofit is offline
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0
    Usually i manually drag and fill down the formula to many rows, now i just want to use VBA macro to autofill just the required row only. with this book4 example, when A time 14:18 has B value (value>0), then C time 14:18 (= A time 14:18) will autofill the formula for D6:G6. For A time 14:20, B has no value, so no autofill for D7:G7. If A time has B value til 14:22, then formula will fill til D8:G8 only.
    Last edited by mrprofit; 05-13-2014 at 06:42 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Code To Autofill Formula In Every Nth Row
    By analyst in forum Excel Help
    Replies: 1
    Last Post: 12-23-2013, 05:51 PM
  2. AutoFill in Formula (R1C1 Style) till data found in adjacent column, multiple IF(AND
    By analyst in forum Excel Help
    Replies: 6
    Last Post: 12-23-2013, 04:07 PM
  3. Autofill the data based on non blank cell in next row?
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 3
    Last Post: 11-29-2012, 04:16 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