+ Reply to Thread
Results 1 to 2 of 2

How do I link value in a cell (sheet1) to a cell on sheet 2, without doing a cut n paste?

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    Sandpoint Idaho
    MS-Off Ver
    Mac 2011
    Posts
    1

    Question How do I link value in a cell (sheet1) to a cell on sheet 2, without doing a cut n paste?

    I have deposits for the days in a month on sheet 1

    Sheet 2, I have the total of deposits for month.

    This is the same figure that is on the total line on sheet 2


    Sheet 1 ....... Sheet 2
    1 10 .......... JAN $464 # carried from Sheet 1 Total Deposits BY DAY FOR MONTH.
    2 15 .......... FEB
    3 10 ...... ETC...
    ..
    31 Days 5


    Total $464

    Can anyone help me/
    Last edited by cbaltax; 01-20-2016 at 11:57 AM. Reason: SEPARATE DATA

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,268

    Re: How do I link value in a cell (sheet1) to a cell on sheet 2, without doing a cut n pas

    If I interpret you query correctly then a formula like this would do what you want:
    Please Login or Register  to view this content.
    I am attaching a file that shows the setup where this would work:
    Deposits by Month.xlsx
    Notice: If you don't want the Month No.'s shown on sheet 2 hide column C (aesthetic value only).
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Paste Clipboard in Sheet1 Cell A1
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2015, 12:12 PM
  2. [SOLVED] Macro to copy cell value of Sheet1 to next empty cell of colum A in Sheet 2
    By JamesFinch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2014, 02:54 PM
  3. Replies: 3
    Last Post: 04-04-2014, 11:34 AM
  4. Delete whole row if a cell from sheet1 equals from a cell from sheet 2
    By ims0phie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2013, 12:47 PM
  5. [SOLVED] copy paste value from sheet1 to sheet2 in empty cell only
    By koi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2013, 03:46 AM
  6. Replies: 0
    Last Post: 11-15-2012, 09:51 AM
  7. Link to cell in different sheet - trigger copy/paste transposed row into column
    By janethenoob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2011, 01:42 PM

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