looking for macro help

[Chuck]

Hi All,

I posted this in the programming section and didn't get a response. I
assume that I was in the wrong section so I'll repeat it for help here.

I have a column of text only information in A1 thru A26, with a control
number in A27.
I want to copy A1 thru A26 to C1 and transpose that column (values only) to
that row.
Then I want to repeat that same copy (for the number of times that is
indicated in A27.
I would then like to go to the bottom of column C and and go down 4 rows
below the last row and put a formula that counts the numberof times that the
information in row 1 occurs in the rows below it.
And finally I would like to copy that formula across the rows for the
transposed information..

Each time I have tried to do this in a recorded macro I couldn't get it to
work, mostly because of the formula and the location of the bottom of the
row, which seems to go to the wrong place. I would appreciated any help and
thank you in advance.


Chuck C

 

[Dan E]

Chuck,

E-mail me your workbook, one with the sheet as it is when you get
it, and one with how you would like the sheet to appear after you have
run said macro...

I'm not quite sure what it is exactly your looking for.