Rows to Repeat at top

[Guest]

I am not sure why but when I creat a new workbook or worksheet it does not
allow me to choose the rows to repeat option in the setup. Is there an area
in the general setup that must be changed to enable this function? Thank you
for your time.

 

[Pete_UK]

Are you clicking on the Setup from within Print Preview? If so, you do
not have access to the Sheet tab to make those changes. Close the
Preview and click on File | Page Setup and then select the Sheet tab.

Hope this helps.

Pete

 

[Guest]

As usual you are great THANKS PETE!

Are you clicking on the Setup from within Print Preview? If so, you do
not have access to the Sheet tab to make those changes. Close the
Preview and click on File | Page Setup and then select the Sheet tab.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Maggie - I thought you had lost the thread, but thanks
for feeding back.

Pete

 

[MaggieR]

(Pete since you were so very wonderful in helping me the last time I thought
maybe you could rack your brain for me on this one) is there a different
technique that could be used rather than a
multiplication to get a numberic/alpha numeric out come? Since most of the
data needing to be converted is both alpha and numeric we are having to hand
change 37K entries. THank you for your previous help by the way!!!!!!!!!!!!

 

[Pete_UK]

Hi Maggie,

I don't quite understand this - can you give me a bit more background
detail?

Nice to hear from you again.

Pete

 

[MaggieR]

Pete,

In cell B1 is 456P and I would like it to result in A1 P654 the
reverse of what is in B1. We have alpha numeric and numeric characters that
need to be reversed from its original format. We also have 321-21-A in B1 and
need it to come back with A-12-123 in A1. I hope this helps clearing this up.
Someone mentioned a UDF solution but to be honest I am not sure what that is
or how to set it up. So hence the question to the notorious PETE!

 

[Pete_UK]

Hi Maggie,

as I still have your email address from before, I've sent you a file with
Gord's UDF already set up in it, so all you need to do is to copy the data
you want to reverse into this file, apply the formula down the adjacent
column, fix the values and then copy back to the original file.

Should be quicker (and more accurate) than manually changing 37,000 entries
!!

Hope this helps.

Pete