Results 1 to 10 of 10

Need help with Offsetting

Threaded View

concatch Need help with Offsetting 06-19-2012, 02:17 PM
NBVC Re: Need help with Offsetting 06-19-2012, 02:20 PM
jason.b75 Re: Need help with Offsetting 06-19-2012, 02:20 PM
martindwilson Re: Need help with Offsetting 06-19-2012, 02:22 PM
martindwilson Re: Need help with Offsetting 06-19-2012, 02:22 PM
NBVC Re: Need help with Offsetting 06-19-2012, 02:24 PM
jason.b75 Re: Need help with Offsetting 06-19-2012, 02:42 PM
concatch Re: Need help with Offsetting 06-19-2012, 02:24 PM
NBVC Re: Need help with Offsetting 06-19-2012, 03:11 PM
jason.b75 Re: Need help with Offsetting 06-19-2012, 03:44 PM
  1. #1
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    107

    Need help with Offsetting

    Hi, Please see the attached excel documents. The cells highlighted in RED are manually done. I'm hoping to find a way to automate this by selecting the bottom right hand corner of a cell and dragging in across.

    Basically I want to avoid the following which requires that i manually insert the relevant cells:

    Cell 1: =$O$47-D46 Cells2: =$O$47-D46-E46 Cell3: =$O$47-D46-E46-F46

    I want a way where I can just Highlight the cell I'm working in and it will auto-complete.
    Attached Files Attached Files
    Last edited by concatch; 06-19-2012 at 02:26 PM.

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