Closed Thread
Results 1 to 4 of 4

2 functions one cell

  1. #1
    Registered User
    Join Date
    09-10-2019
    Location
    ireland
    MS-Off Ver
    2010
    Posts
    6

    2 functions one cell

    Hi Guys,
    Im brand new here, 1st post hope you can help.

    I have a workbook with a series of values i want to copy across. Its for monthly payroll
    eg Cell H6 displays the value in A6 (=A6) (salary in feb is the same as in Jan)
    Cell O6 displays the value in H6 (=H6) and so on. (salary in march is the same as feb)

    If i amend a salary in march this copies acros subsequent months which is great, but if i then amend the salary from a previous month (say jan) this only copies as far as march as I have overtyped the formula.

    Is there a way to allow me to overtype a value so subsequent months copy, but if i subsequently change a value in a month prior, the formula will once again copy right across the sheet?
    I hope that makes sense,
    Thanks in advance,
    Joe

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,984

    Re: 2 functions one cell

    If I follow you... you will need VBA for that, as a cell can have a value or a formula, but not both. If I do follow you correctly, I can't help as I'm hopeless with VBA.
    Glenn



  3. #3
    Registered User
    Join Date
    09-10-2019
    Location
    ireland
    MS-Off Ver
    2010
    Posts
    6

    Re: 2 functions one cell

    Hi Glenn,
    I think you are correct about VBA, i saw an answer to another thread that suggested this and it looks like what I need but i couldnt figure out how to get the code to work on my workbook.
    thanks for your answer.
    Joe

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,761

    Re: 2 functions one cell

    Welcome to the Forum Joenor!

    As a new member, please take the time to review our rules. There aren't many, and they are all important. We have a rule against duplicate posts. If you feel that a post belongs in a different place, please ask a Moderator to move it, rather than creating a duplicate.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread because it has no solutions to your question. You may continue here in the new thread.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

Closed Thread

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