Rows to Repeat at top

M

MaggieR

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.
 
P

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
 
M

MaggieR

As usual you are great THANKS PETE!

Pete_UK said:
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
Click to expand...
 
P

Pete_UK

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

Pete
 
P

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
 
M

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!
 
P

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
 
Top