+ Reply to Thread
Results 1 to 7 of 7

Formulas Not Pasting

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Pico Rivera, California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Formulas Not Pasting

    Hi,

    I have a workbook consisting of 1 summary page and 22 additional (branch specific) pages. I have simple formulas in the summary page that are supposed to reference specific fields in the subsequent pages that I receive individually via email. Since the summary page has to be updated periodically, my intention is that when I receive one of the individual pages via email, ideally I would just copy and paste these pages into each tab and the formulas from the summary page would then reference the information needed.

    I've made sure that the formulas are all correct and referencing the correct cells and I've even refreshed the data in both the summary page and subsequent pages but it still doesn't work. The formula is just a simple reference formula (=destination page!destination cell). Is there something else I can do to make this work?

    Any suggestions would be appreciated.

    I've attached my workbook and I've I've inserted "Atlanta" which returns the formula errors on the summary page.
    Attached Files Attached Files
    Last edited by AmberM; 08-20-2013 at 02:43 PM. Reason: Thread title not specific enough

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

    Re: Template or Macro or another Suggestion?

    Hi amber

    Save your workbook before trying this. Don't change the name of "BUSA Org Chart Summary P7 2013 ".


    By pasting over your existing data you are breaking the links in the formulae and corrupting them.

    The Freeze macro below freezes all your formulae by converting them to text. Unfreeze restores them.

    Try freezing your workbook before pasting your data. and then unfreezing it.

    I assume you know how to run a macro.

    [ Click on developer, then on macro, select the macro, click on run. ]

    Good Luck.



    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-19-2013
    Location
    Pico Rivera, California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Template or Macro or another Suggestion?

    Hi and Thank you!

    Your code partially worked. As a test, I froze my workbook, deleted the Atlanta tab, re-inserted it and unfroze the workbook. The information populated the Atlanta table of the summary page perfectly but then the tables for some of the other branches on underneath (which I didn't touch) seemed to stay frozen (in text form) (All the tables on the right were also fine).

    Should I have added something to your coding or could it be the way my cell is formatted (although I double checked and compared to the cells that were ok and I don't see a connection there)?

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

    Re: Formulas Not Pasting

    Hi Amber

    I set the macro to ignore some columns and some rows to speed things up.

    Maybe I shouldn't have.

    I will tweak the file and repost it for you.

    BRB

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

    Re: Template or Macro or another Suggestion?

    Try This. I will check it myself and will come back to you if I find anything useful.

    Please Login or Register  to view this content.

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

    Re: Template or Macro or another Suggestion?

    The macro above works for me.

    But I have added a few lines to ensure that it is always working on the correct sheet.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-19-2013
    Location
    Pico Rivera, California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Template or Macro or another Suggestion?

    That worked perfectly!

    Thanks so much!

+ 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: 3
    Last Post: 05-15-2013, 11:34 PM
  2. [SOLVED] here is a macro that works, anybody have an alternative suggestion?
    By siba in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2012, 09:44 AM
  3. Converting workbook with Macro to a template causes the Macro to stop working
    By Skeeta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 02:00 PM
  4. Need suggestion on macro to form a report
    By Kenji in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2010, 11:44 PM
  5. [SOLVED] Newbie seeks suggestion on recording new macro to print sheets
    By Vivian in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-10-2006, 02:00 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