Hi,

I am working on a large budget file which has 150 worksheets - one worksheet
for each general ledger number and each worksheet shows January-December
expenses. January thru December are listed in each row so my cells I want to
copy (to my summary sheet) for example, January would be C4, February would
be C5, etc. My summary sheet has January - December columns across the top
and each row is the g/l numbers. I want to be able to copy C4, C5, etc. to
C4, D4, on the summary sheets and use the fill feature but I can't get it to
fill properly. If I use transpose, it doesn't copy the formula. I want to
be able to change the worksheets and have it automatically change the summary
sheet. I really appreciate your help.

Nell