+ Reply to Thread
Results 1 to 2 of 2

inserting a row then keeping a formula in it

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    West Wickham, Kent
    MS-Off Ver
    Excel 2007
    Posts
    3

    inserting a row then keeping a formula in it

    I know this is a long shot but i enter a new row each week so i insert a row at row 6, i was wondering if i could have a formula that stays in row 6 and when i enter a new one it moves to the new row 6 so that i can link it to a totals cell so it updates on that tab whilst my other tab changes weekly.


    say the row i just inserted i needed the totals from another tab is there any way to get a formula to go into the new row and then use the data thats in another tab to display a total. at the moment i manually enter it. so maybe a formula that is fixed to cell C6 and shows the total of say 'Billings' tab cell B7

  2. #2
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: inserting a row then keeping a formula in it

    If possible attached the sample sheet

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1