Transfering Data from One sheet to another

[tjrmick]

I am wanting to setup a worksheet which will allow me to separate corp credit card charges by cost center and dept and then transfer over to a summary sheet which shows the totals only for each cost center and dept.
Info would be like:
6015-004 $268.85 03/15/01
First 4 digits represent the cost center with the last 3 being the dept number. Any suggestions? I want it in one workbook where others can just enter the information and maybe use a macro button to do all the sorting and subtotaling???? Please help. I'm in over my head!

[Anne Troy]

Why would you transfer to show totals only? Why not just use Data-Subtotals. And if that's too many steps, record a macro while you do it and place buttons on the toolbar to do the subtotals and also to clear the subtotals.

[tjrmick]

I want to show subtotals only so we can give to our accounts payable dept for entry for payment. Each total has to be entered seperately so it's charged to the correct cost center and department. Currently A/P is paging through about 7-10 pages to get the totals. Trying to make things easier. This bill can be $50k+ a month with 10-15 cards with so many receipts it would make your head spin.

[Brian from Maui]

Probably a long shot, but check this out by Chris Davison

http://www.mrexcel.com/board/viewtop...c=6659&forum=2

[Chris Davison]

Brian,

that Chris Davison is useless...!

in this post, I'd suggest Dreamboat's suggestion of data / subtotalling, adding that the info then be collapsed to just show the respective totals (click on the [1] or [2] to the left of the data

or

try pivot tables which can group by the rerspective cost centres, and be placed on a new sheet for presentational purposes

[tjrmick]

thanks for the help. i got it all figured out and it works wonderfully. used array formulas.