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