Taking a column from several worksheets; combining into another...

M

maura

I have 10 worksheets (all are formatted the same), and I want to take all of
the information out of the same column in each worksheet and combine all the
information from that column into another worksheet. What would the formula
be?

Thanks, maura
 
D

Duke Carey

Assuming you want to sum 10 values from cell B1 (one for each sheet)

=sum('Sheet2:Sheet11'!B1)

copy as needed

If your sheets are not named Sheet1, Sheet2, etc., then start the formula
normally by typing

=sum(

then click on the leftmost tab, click in the cell you want to sum, hold the
Shift key down and click on the last tab to sum, then press the Enter key
 
M

maura

Sorry for not being clear. I do a lot more Access than Excel and I am trying
to help someone in my office. She has 10 worksheets to track Car Rentals.
Each sheet is name for the last six of the car's VIN. In each sheet she is
tracking her rental agreements by putting the rental agreement number in the
D Column. We want to make sure that we aren't missing rental agreements so we
want to combine all of the Column D's from each worksheet and then sort them
to see if any of the rental agreements are missing. I can do this by copying
and pasting, but I figure there's got to be a better way... Thanks, m.
 
D

Duke Carey

Well, if you are more used to Access, help her convert her spreadsheet to
Access. What you are describing is much better done in a normalized database
than in 6 seperate spreadsheets

If that isn't a possiblility, you are most likely left with the copy/paste
route
 
Top