+ Reply to Thread
Results 1 to 4 of 4

Number stack formula/Macro?

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Number stack formula/Macro?

    hi excelers,
    Is then any way to place a previous input number below a new input enter number.
    So I enter in say "5", and if next I enter say "3" the "5" will be placed below the "3" so-on so-on all the way down the array!
    It seems like a simple function but Is this possible with formula alone or will it need MACRO to do it?
    Any suggestions or ideas are welcome*
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Number stack formula/Macro?

    In the sheet's code put
    Please Login or Register  to view this content.
    Attached Files Attached Files
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: Number stack formula/Macro?

    wow that works very well.
    thx for your help and so simple. star 4u*

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Number stack formula/Macro?

    Good news,
    Happy Sunday

+ 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: 1
    Last Post: 10-02-2014, 01:51 PM
  2. Transpose and stack MACRO- Excel 2010
    By Drewfiss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2014, 08:35 PM
  3. [SOLVED] Need A MACRO to Remove Duplicate Name Header and Stack
    By sbehera in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-28-2012, 03:15 PM
  4. [SOLVED] Modify code to transpose a stack of data to rows on to delimit on text hone number field
    By coachtim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 02:52 PM
  5. Macro for Call Stack
    By Karthick083 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2010, 06:33 AM
  6. can a macro see the call stack.
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2009, 08:05 PM
  7. Search for stack number using input
    By jhard in forum Excel General
    Replies: 6
    Last Post: 09-08-2008, 08:25 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