+ Reply to Thread
Results 1 to 5 of 5

Reoccuring data

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    106

    Reoccuring data

    Hello all, have a question about some re-occuring data generated from a formula
    for example
    i need to manually input some data into B21 and C20 and a answer in c21... heres the formula $B21+$C20 because i copied and pasted it down beacuse the numbers will change daily according to performance... my question is how can i fix the formula to where it wont automatically populate in C22,C23,C24 and so on until i manually input the numbers ...See attached for an example...
    Thanks for your timeBook1.xlsx

  2. #2
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    106

    Re: Reoccuring data

    If you look at the sheet, all i want to do is not have the formula in colum C and E auto populate until i manually enter the data that I need to input..

  3. #3
    Registered User
    Join Date
    02-05-2015
    Location
    Edmonton, Alberta
    MS-Off Ver
    2013
    Posts
    70

    Re: Reoccuring data

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Past this into C22 and drag up and down. this will do the trick

  4. #4
    Registered User
    Join Date
    02-05-2015
    Location
    Edmonton, Alberta
    MS-Off Ver
    2013
    Posts
    70

    Re: Reoccuring data

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and you can put this into G22 to fix that column

  5. #5
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    106

    Re: Reoccuring data

    Perfect...Works fantastic. Thank you very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 09-11-2013, 08:56 PM
  2. Create individual worksheets for reoccuring data on a single worksheet.
    By Jaqbe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2013, 05:10 PM
  3. [SOLVED] Formating Reoccuring Data for Chart use
    By Aston01 in forum Excel General
    Replies: 5
    Last Post: 07-20-2012, 08:43 PM
  4. Replies: 2
    Last Post: 05-27-2011, 12:47 PM
  5. How to make a reoccuring if then
    By Calvin Witcher in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-16-2008, 07:10 AM

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