Results 1 to 3 of 3

Empty cell, no formula, no Macro, no formulas referencing cell - Automatically fills up wi

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2012
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Empty cell, no formula, no Macro, no formulas referencing cell - Automatically fills up wi

    I really hope someone understands how can this work (file attached).
    So, cell is empty in Col A (like A7), and when numbers are entered in all cells B7:E7, excel copies formula from cell above (B6).
    At first I thought - right, easy to do with VBA, but... There are no macros, nothing in worksheet code, there are no custom functions, and now for few hours can't figure out how is Excel doing this. It is not tables, I can tell that (red one similar post).

    Also, try deleting A7 to E7 contents, and then enter numbers again in B7 to E7, A7 gets formula from cell above automatically. I copy/pasted whole range to another Workbook, and it works too.

    This looks really cool, the only thing is I can't understand how it works and how to replicate it.
    Any feedback or thinking would be appreciated,
    Tom
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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