How can I cross reference data from different sheets? I need to connect a summary data from one sheet to the entire table in an another sheet.
Please help me ASAP.
How can I cross reference data from different sheets? I need to connect a summary data from one sheet to the entire table in an another sheet.
Please help me ASAP.
You can do this the same way as you would do if the data you needed was in the same sheet.
Lets say you in cell A1 want the value from cell C4:
In cell A1 press: =
select cell C4 and press enter
You then get the formula =C4 in cell A1.
This is wery basic excel learning. But now you can try to do the same but instead of selecting cell C4 inn the same sheet, select a cell from another sheet or another open woorkbook !. Then you will see the syntax to use for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks