+ Reply to Thread
Results 1 to 6 of 6

Help with Macro for Prefilling Pay on Dynamic Dates

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,558

    Re: Help with Formula for Prefilling Pay on Dynamic Dates

    Thanks. Can I just clarify: you want the amount to appear, but for the entire incomings/outgoings table to be editable? The thing is, you can't have both a formula and manual entry in a cell, so for what you seem to want, for a wide audience, I suspect you are going to need VBA. Please clarify.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  2. #2
    Registered User
    Join Date
    07-01-2019
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    3

    Re: Help with Formula for Prefilling Pay on Dynamic Dates

    You're quite correct, Ali. I would be hoping for a solution that allows a prefill (maybe a macro attached to a button is a better option) as well as the ability to add additional values to cells in the incomings and outgoings column. Not being able to have both is a good point and perhaps macro's/VBA is a better option.

+ 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. Targeting dynamic department capacity between two dynamic dates
    By tpieken333 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2015, 02:46 PM
  2. Prefilling 10 rows in one column based on 1 row from another
    By Farmer Ali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2015, 02:13 PM
  3. Conditional Weekly Average Formula for Dynamic Dates
    By roychirodeep in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2013, 01:51 AM
  4. [SOLVED] Calling and prefilling a form from another form
    By jlt199 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2012, 04:18 PM
  5. Prefilling cells with IF statment?
    By qvp in forum Excel General
    Replies: 3
    Last Post: 02-24-2012, 05:29 AM
  6. Replies: 0
    Last Post: 02-28-2006, 09:10 PM
  7. Replies: 2
    Last Post: 02-02-2006, 04:10 PM

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