+ Reply to Thread
Results 1 to 7 of 7

Excel Assigning Value In Table Problem ( Shifting Problem )

  1. #1
    Registered User
    Join Date
    07-01-2018
    Location
    Izmir / Turkey
    MS-Off Ver
    2013
    Posts
    4

    Question Excel Assigning Value In Table Problem ( Shifting Problem )

    Greetings From Turkey

    This is my first topic , i hope you can help me.

    I have a little excel file for my expenses. I attached my file to this topic you can download from here.

    I want your help at this point.
    My table has expenses in rows and i have 3 types of source. credit card 1, credit card 2 and cash in my pocket. my F5 value is my initial cash money, if i spend cash, i assign final value to G5. First row of my table is $30 expense and i paid as cash so my final money is 70.

    I want my table to assign G5 to F6, G6 to F7 etc. When i add new row, i want previous rows final value automaticly assign to new rows initial value in my table

    Thanks!
    Attached Files Attached Files
    Last edited by Nefiskenar; 07-01-2018 at 01:02 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,104

    Re: Excel Assigning Value In Table Problem ( Shifting Problem )

    Hi, welcome to the forum

    Try this...
    =IF($E6="","",G5)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-01-2018
    Location
    Izmir / Turkey
    MS-Off Ver
    2013
    Posts
    4

    Re: Excel Assigning Value In Table Problem ( Shifting Problem )

    Quote Originally Posted by FDibbins View Post
    Hi, welcome to the forum

    Try this...
    =IF($E6="","",G5)
    Actually that works but problem is it is calculating values before adding rows, so the table becomes ugly, my aims is when i add new row, new expense, i want automatic assign the final value of previous rows to attend to new row's initial value

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Excel Assigning Value In Table Problem ( Shifting Problem )

    Use Excel Table not a Range "table"

    Ooops my excel was minimized so I didn't notice it is Excel table

    anyway you can add new row with TAB key so it will copy your formulas properly down
    Last edited by sandy666; 07-01-2018 at 01:15 PM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  5. #5
    Registered User
    Join Date
    07-01-2018
    Location
    Izmir / Turkey
    MS-Off Ver
    2013
    Posts
    4

    Re: Excel Assigning Value In Table Problem ( Shifting Problem )

    Adsız.png

    When i add new rows to table, i want this assignment automaticly and at that time, not before.

  6. #6
    Registered User
    Join Date
    07-01-2018
    Location
    Izmir / Turkey
    MS-Off Ver
    2013
    Posts
    4

    Re: Excel Assigning Value In Table Problem ( Shifting Problem )

    Quote Originally Posted by sandy666 View Post
    Use Excel Table not a Range "table"

    Ooops my excel was minimized so I didn't notice it is Excel table

    anyway you can add new row with TAB key so it will copy your formulas properly down
    explain this please i dont get it , if my rule copy to below it is also works for me

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: Excel Assigning Value In Table Problem ( Shifting Problem )

    here is

    now put pointer to the last row (in this case B8) and hit TAB few times to create new row (it should go thru the whole row to the end and jump to the new row)
    then enter new data
    I changed Ford's formula to =IF(ISTEXT(G4),100,IF($E5="","",G4)) because I don't know how you get 100 in F5
    you can modify this for your requirements
    Attached Files Attached Files
    Last edited by sandy666; 07-01-2018 at 02:36 PM. Reason: file was changed

+ 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: 2
    Last Post: 03-24-2018, 09:37 AM
  2. Problem with Assigning a Macros to the Ribbon or Quick Access Bar in Excel 2010
    By Benefitus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2013, 08:12 AM
  3. Excel .csv import assigning to column problem
    By Frank1000 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-07-2013, 02:33 AM
  4. problem with assigning row number
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-07-2010, 04:19 AM
  5. Problem with assigning value from UDF to a cell
    By knn9413 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2010, 11:49 PM
  6. Problem Assigning Macros
    By LanceB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  7. Problem Assigning Macros
    By LanceB in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 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