Forum Discussion
Transferring data from multiple sheets to a summary sheet
I don't use excel very much, just do basic stuff on a spread sheet. However, I have a client that needs to trackpatient receipts by patient so I envision numerous sheets with cell amounts transferred...
Hello,
in order to suggest a formula it would be really useful to learn how the workbook is structured.
A very simple formula that pulls a value from a different sheet can be created like this:
In the Summary sheet, select a cell. Type a = sign, then click the sheet tab of the source and click the cell that has the value you want to show in the summary sheet. The formula in the Summary sheet will look something like this
='Other sheet"!$F$5
where "Other sheet" is the name of the other sheet and cell F5 was clicked in the process I explained above.
Does that help?