+ Reply to Thread
Results 1 to 2 of 2

Store outcome Macro in another tab

  1. #1
    Registered User
    Join Date
    07-18-2020
    Location
    Nieuwegein, The Netherlands
    MS-Off Ver
    Office16
    Posts
    1

    Store outcome Macro in another tab

    Hi everyone,

    I just joined this forum because I'm struggeling with my Excel skills. Hopefully you will be able to help me.

    I would like to make a Macro which enables me to safe the outcome of a few cells in another tab.
    Example: Date 18-07-2020 and outcome is Profit: $500
    Is it possible that in another tab I mention al of the dates in a year and that the Macro safes the outcome?
    So after I changed the date and the profit and I press the Macro button again it stores this new profit outcome on that other tab.

    I hope this makes sense. English is not my native language.

    Thank for helping me.

    Pvunderink1

  2. #2
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: Store outcome Macro in another tab

    Is it possible that in another tab I mention al of the dates in a year and that the Macro safes the outcome?
    So after I changed the date and the profit and I press the Macro button again it stores this new profit outcome on that other tab.
    If your data have a unique identifier, I think it's possible.

    Maybe upload a sample workbook is better - so when someone can help, it's easier for him by seeing your sample workbook.

+ 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. Search Apple App Store and Google Play Store
    By mbuchman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2019, 01:25 PM
  2. [SOLVED] Formula to create store by store inventory transfers
    By DamianTaylor in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-08-2016, 08:37 AM
  3. Add file to the Record Macro Store macro in drop down
    By dalfiuss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2015, 11:26 AM
  4. [SOLVED] Two forms, two macros same outcome, form 2 and macro 2 not working
    By Missus Mommabear in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-14-2015, 12:52 PM
  5. Macro runs Text to Columns with incorrect outcome.
    By JonnieB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 11:15 AM
  6. Run HLOOKUP macro on outcome of Data Validation
    By simonc64 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 09:36 AM
  7. Macro to correct formula outcome
    By pinas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2012, 12:10 AM

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