0

How can I retain the NL function when copying and pasting?

Vivian Mosher

May 06, 2020 19:13

None

Follow

Hello all!

Every time I copy and paste a cell in design mode the NL function disappears and I only get the value.  Is there any way to copy and paste a cell of group of cells so that the functions are retained?  Thanks!

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Vivian Mosher May 06, 2020 19:14

  a cell OR group of cells (typo in original post).

• 0
  
  Bryan Robinson May 11, 2020 12:19

  First, it must be done in Design mode.  Second, if Excel is copying and not pasting correctly, that is outside of the realm of Jet's functionality.

  https://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-when-i-copy-a-formula-it-pastes-as-a/cb7fa828-6836-4d64-a428-25e75c6186e2

• 0
  
  Vivian Mosher May 13, 2020 13:56

  Thanks Bryan!

  I ended up copying the tab that have the functions that I need to copy from the original spreadsheet into the other spreadsheets and then I copy and paste.  You are correct that is must be done in design mode.  When I do it this way the NL functions copy, but they have the path from where I copied the tab, see below between the >>><<<<.  I then use Excel's Find and Replace to remove the paths.  

  =NL("Sum","Cust. Ledger Entry","Profit ($)","Posting Date",$S$8,"Salesperson Code",'>>>>>C:\Users\Test\Desktop\DevelopmentFolder\[Dev1.xlsx]<<<<<TestTab'!C2,"Document Type","Invoice|Credit Memo")

  I guess there is no better way...