Share via

Moving data from sheet1 to sheet2

Anonymous
2020-01-05T01:46:16+00:00

I would like to reference cells in sheet1 from sheet2

example  I would like to copy the contents of A1 Sheet1  to A3 in sheet2, A2 in sheet1 to A4 in sheet2, etc.

Also would like to use a number in cell from sheet1 to use in a calculation in cell in sheet2.    B1 sheet2   = (sheet1,cell B1) + (value inB5 of sheet2) + (value inB6 of sheet2) - (the value in B7 of sheet2)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-01-05T02:14:39+00:00

    Hi, Larryperry3.

    I am a fellow user. I would like to help.

    To reference a value from Sheet 1 to Sheet 2, go to the cell where you want the value to be placed, type =, go to the reference cell then enter.

    Also, this is the formula in B1 Sheet 2

    =Sheet1!B1+Sheet2!B5+Sheet2!B6-Sheet2!B7

    Please let me know should you need further assistance.

    Thank you.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-01-05T02:35:53+00:00

    Hi Larry

    For the first part of your question

    try this formula in cell A3 on Sheet2  A3=Sheet1!A1 and drag the formula down

    For the second part

    On Sheet 2,

    cell B1  =Sheet1!B1+Sheet2!B5+Sheet2!B6-Sheet2!B7

    OR simply

    cell B1=Sheet1!B1+B5+B6-B7

    Please, check the pictures below that shows the results with some sample random data

    Do let m know if you need more help

    Regards

    0 comments