+ Reply to Thread
Results 1 to 2 of 2

How to paste formula properly from different spreadsheet

  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    Israel
    MS-Off Ver
    2013
    Posts
    1

    How to paste formula properly from different spreadsheet

    Hi
    I use excel 2013
    I wrote a formula for a table column (the column name is "date range")
    Now, I'm trying to copy it to a different table at a different worksheet (every worksheet represent different country)
    and of course I want the formula to use the data at the new table/ spreadsheet
    but it doesn't seems to change the references relatively, even though I use "past formula".
    I can't use the F4 because it seems like it doesn't influence the table name.
    here is the formula like its written in the "New York" spreadsheet:
    =IF(AND(A30-[@[Arrival Date]]>0,A30-[@[Arrival Date]]<=2),CONCATENATE(TEXT([@[Arrival Date]],"dd/mm/yy"),"-",TEXT(A30,"dd/mm/yy")),IF([@[Arrival Date]]=A28,B28,[@[Arrival Date]]))
    and this is how its appears in the Hamburg spreadsheet:
    =IF(AND(A21-NY[@[Arrival Date]]>0,A21-NY[@[Arrival Date]]<=2),CONCATENATE(TEXT(NY[@[Arrival Date]],"dd/mm/yy"),"-",TEXT(A21,"dd/mm/yy")),IF(NY[@[Arrival Date]]=A19,B19,NY[@[Arrival Date]]))
    My goal:
    At the Hamburg spreadsheet/table, I want the formula to use the Hamburg data
    Clarification:
    the two table structure and headlines are the same
    Thanks a lot
    Chen
    Last edited by chenlahav; 01-14-2015 at 04:12 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: How to paste formula properly from different spreadsheet

    It would be easier if you were to post an Excel sheet. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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: 10
    Last Post: 09-17-2013, 11:52 PM
  2. How to Paste VBA code properly...
    By TLiles in forum Excel General
    Replies: 4
    Last Post: 06-03-2010, 12:34 PM
  3. How to drag/paste formula on looong spreadsheet.
    By mud_shark in forum Excel General
    Replies: 3
    Last Post: 01-15-2010, 02:00 AM
  4. [SOLVED] Spreadsheet Don't save properly
    By ? in forum Excel General
    Replies: 2
    Last Post: 07-04-2005, 08:05 PM
  5. [SOLVED] Properly Formated Spreadsheet
    By Penflex in forum Excel General
    Replies: 2
    Last Post: 06-21-2005, 09:05 AM

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