Trying to link data from one sheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook set up in 13 worksheets. 12 for the months for data to be entered, and one for a master. when I enter data into these worksheets I want all the data to be sent to the master worksheet automaticly without copy and paste. How do i do this?
 
Assuming all the sheets are the same -

1. This method uses Excel's ability to group sheets.
Position your summary sheet as the first sheet.
Start your formula by typing
= SUM(
into a cell in the summary sheet. Select the same cell in the next
sheet. Hold down Shift key. Click name tab of current sheet. Click name
tab of last sheet. Type a right bracket to close the formula. Enter.
You get a formula like :- =SUM(jan:dec!A1)

2. This method can use cells in any combination.
Type = sign into summary cell. Select cells in turn from the other
sheets typing a plus sign after each one. Enter.
You get a formula like :- =jan!A1+feb!A1+mar!A1 ... etc.

Or you can type the formula directly into the summary cell.
 
Back
Top