Ledger sheets

[johnson]

Operating System: Mac OS X 10.6 (Snow Leopard) We've created a custom ledger sheet that we need to set up for each month. However, when we try to create a copy, it will not work. We have contacted an Expert and he could not figure it out. We always get a message to report the problem which we have a dozen times, but nothing gets resolved.
Please respond to this quickly.

 

[Phillip Jones, C.E.T.]

how are you trying to create it. Creating a new workbook (open a new
excel file) or click on the new sheet tab?

before you fill anything (just formulas, no numbers added, no
calculations) try click in first row/cell Column at top-left hold down
shift key and scroll to bottom of cells used (bottom-right) then click
copy, next click on sheet tab (or the + next to sheet tab). now click in
first row/column cell.

now go to edit menu and choose paste. or if that doesn't work try Paste
special and choose what you want it to paste. You may have to change
headers and footer Manually. then click on the + next to sheet again
and repeat again until you have a Year's worth)

then once you go a years worth finished and working. then save as to
save as you wanted. then choose save as again and rename slightly and
this will be for next year, repeat again each your you need (in fact
save a Back up blank copy just that have one to copy from). You will
have to change dates accordingly as your creating.)

See if this works.

If you can't figure send a Blank sanitized version to me and I'll see if
I can do it for you then you can edit as needed and re-save. Just need
some basic headers and formula for the first sheet.

 

[Jim Gordon Mac MVP]

Operating System: Mac OS X 10.6 (Snow Leopard) We've created a custom
ledger sheet that we need to set up for each month. However, when we try
to create a copy, it will not work. We have contacted an Expert and he
could not figure it out. We always get a message to report the problem
which we have a dozen times, but nothing gets resolved.
Please respond to this quickly.

To make a copy of a worksheet, use Edit > Move or Copy Sheet. Click the
checkbox for Create a Copy then click the OK button.

-Jim

 

[Phillip Jones, C.E.T.]

Wow That was easy how long has that been there 50 years? ;-)

If I had know about that setting up a spreadsheet for my mothers bills
for last summer would have been a snap. instead I spent half a day
setting up everything manually and then getting everything to work. Gee
tell me an easy way to do something 9 months after I needed it. ;-) Oh,
well I guess I was meant to go through the learning myself.