extracting info from multiple sheets

J

Jacob

I have seven sheets same setup for all seven sheets. It is a bank register,
each sheet is for a diffrent bank. I would like to get info filtered from
all sheets. Like all transactions for a certain date. Or all transactions
for a certain name.
Can some one help me please.
 
F

Frank Kabel

Hi
if you have devided this on several sheets it's getting complicated.
You may consider re-designing your sheet. Put all information on one
sheet, add a column for the bank name

With this layout you can use the build-in feature like 'Filtering,
Sorting, pivot tables, etc.
 
J

Jacob

I have one coulmn that keeps a runing total. it takes the last line balance
minus this line check amount. If I combine bank accounts in one sheet, even
if I use filter, how can I get a runing balance for a specific account?
 
D

Dave Peterson

You could either do Data|pivottable and refresh the table when you need it.

Or you could sort your data by account number and then Data|subtotals.

The pivottable may take a little more time to learn (but not a lot), but once
you do, you'll find lots of uses for them!

If you want to learn more about pivottables, here are a few links.

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx
 
Top