Re: Transposing

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: angela (anonymous_at_discussions.microsoft.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 06:11:03 -0700

     
     ----- Lady Layla wrote: -----
     
     Do you mind reposting this not using all caps -- it is impossible to read
     
     "ANGELA" <AFULEKI@SALLYBEAUTY.COM> wrote in message
     news:1D15AD30-6D1B-4358-8F20-1B573C933435@microsoft.com...
     : =C:\DOCUMENTS AND SETTINGS\CARSONL\MY DOCUMENTS\1ST SHIFT
     PRODUCTION\APRIL\[PULLER PROD 4-19.XLS] 1ST SHIFT WEEKLY
     ACCUMULATIVE'!$L$10+'C.........
Then same route to 4 other workbooks but the [PULLER PROD] date changes to match the name of the other workbooks.
What I have is 1 workbook per day tieing into 1 sheet for production for each employee. The individual employee sheet ties into a summary report in each workbook.....My task is to create a weekly and monthly report from these sheets. It will take forever if I have to mannually type in the formula for each cell. When I first started this project I was able to create the formula in the first cell..copy, then paste special "transpose" to the other cells in the same colum. The formula would transose the row number accordingly....now it just pastes the same formula over and over giving the same result.??
                   :
     : ----- Frank Kabel wrote: -----
     :
     : Hi
     : post your used formula :-)
     :
     : --
     : Regards
     : Frank Kabel
     : Frankfurt, Germany
     :
     : "angela" <afuleki@sallybeauty.com> schrieb im Newsbeitrag
     : news:8CF2DDAB-7C8C-4D9B-BC31-21691C960AFD@microsoft.com...
     : > I am working on a weekly worksheet that ties 5 daily sheets together.
     : Sometimes when I take the begining cell from the colum and copy, then
     : paste special - transpose it works correctly and changes the
     : destination cell that it is totaling from correctly. Other times it
     : will just re-copy the first formula all the way down the colum, not
     : changing the row number sequnentially down the colum.
     : >> Any help??? I am very frustrated with this.
     :
     :
     
     
     

Quantcast