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...
A quick way to go about fixing this problem would be to copy the sheet that you have, and then paste special the information. Then if you make any changes as well to the data it will automatically be computed in the other tab
Josh Powers Can you explain that in a bit more detail? How will pasted data automatically compute in the other sheet? Which option of Paste Special would you use for that?