+ Reply to Thread
Results 1 to 4 of 4

FIFO Function only works if you Save Workbook and re-open; or move to a different Sheet an

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    FIFO Function only works if you Save Workbook and re-open; or move to a different Sheet an

    Hi,

    The attached FIFO Workbook works well if you save the Workbook and re-open it; or if you move to a different Sheet in the Workbook and return to the original Sheet.

    I use the function in Column H of the "FIFO with Sample Data" Sheet, providing supporting data (..input data) in Columns A thru G. So, if you make a new entry in the supporting data section say, Row 45, the resulting answer shows up in H45 and other cells in Columns H are zero out; but if you move over to the other Tab, "FIFO Example" and then come back to the "FIFO with Sample Data" Tab, all is good; or if you save the Workbook and re-open the Workbook, all is good.

    I'm not sure what causes this problem. I prefer to use the FIFO function and see the results in the same TB or while the Workbook is still open.

    Can someone please help me?

    Thanks. Much appreciated
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: FIFO Function only works if you Save Workbook and re-open; or move to a different Shee

    Saving and re-opening or switching between sheets causes this macro to run:
    right click on the sheet name at the bottom of excel and select view code.

    Please Login or Register  to view this content.

    Change that macro to this:-

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: FIFO Function only works if you Save Workbook and re-open; or move to a different Shee

    Hi

    I tried it and got:

    Run Time Error '1004'
    Application-defined or object-defined error

    This happens when I starting to make a new entry in Row 45 at Column A45

    Anything else you can suggest is very much appreciated.

    Cheers!

  4. #4
    Registered User
    Join Date
    08-17-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: FIFO Function only works if you Save Workbook and re-open; or move to a different Shee

    Hi Mehmetcik,

    Thanks for the below code suggestion. Can you please give it another shot.

    I'm getting:

    Run Time Error '1004'
    Application-defined or object-defined error

    This happens when I start to make a new entry in Row 45 at Column A45

    Once again, many thanks.



    Quote Originally Posted by mehmetcik View Post
    Saving and re-opening or switching between sheets causes this macro to run:
    right click on the sheet name at the bottom of excel and select view code.

    Please Login or Register  to view this content.

    Change that macro to this:-

    Please Login or Register  to view this content.

+ 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: 6
    Last Post: 04-28-2016, 10:35 AM
  2. [SOLVED] VBA to save a newly open workbook to a specfic workbook and then sheet within
    By namluke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2014, 05:14 PM
  3. Move sheet to its own workbook and save
    By Kholmes11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 12:51 PM
  4. Save an open workbook, then open template workbook and close the saved workbook
    By ondvirg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2009, 10:20 PM
  5. [SOLVED] Open a sheet rename and move to another workbook
    By Patrick in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-18-2006, 11:30 PM
  6. Replies: 1
    Last Post: 01-02-2006, 11:30 PM
  7. Replies: 0
    Last Post: 12-30-2005, 04:35 AM
  8. [SOLVED] Find and Open Workbook then copy and move sheet
    By cwilson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2005, 05:54 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