Is it possible to copy a current worksheet that keeps all formatting and formulas

[Eaglepi]

Hello people,
I have a worksheet that I use for my banking purposes, every time I make any kind of transaction in my bank I also keep a spreadsheet of the current data so that I always know that my accounts balance. Now obviously because this is a banking worksheet I know I'm not going to be able to give you an example which I know most of you like to see.

So for that reason I'm going to try to make this question as simple as possible, I have a current worksheet that I keep track of a savings account and I match it to my online banking after every transaction so I always know it balances.

I just opened a new account and I want to create another Tab on this worksheet for this new account.

Is there any way to copy my original worksheet so that all the formulas and formatting are copied so I can paste them into the new worksheet for the newer account?

If not, it's not a big deal I can just create a new one from scratch and then use the formulas on my main worksheet and copy them and paste them to the new worksheet. As I just said this while typing it I realize that might be the easiest. In

[Pete_UK]

You can just Ctrl-Drag the tab of the sheet you want to copy - position the new tab where you want it, then rename as appropriate.

Hope this helps.

Pete

[MrShorty]

I don't know if will apply, but I frequently use the "move or copy sheet" command to make copies of whole tabs -- including all the data, formatting, formulas, etc. If I understand what you are trying to do, I might right click on the tab -> Move or copy sheet -> Select the location for the copy and make sure to check the "create a copy" option -> clear or overwrite the data in the resulting copy.

[Eaglepi]

You can just Ctrl-Drag the tab of the sheet you want to copy - position the new tab where you want it, then rename as appropriate.

Hope this helps.

Pete

I just did the ctrl = drag And was able to create a new tab that was a copy of my original. Everything was intact formula and formatting.

Since this is going to be a complete new account I selected all the data and cleared data. All the columns are the same as the original which I will list here,

A Date
B Description
C Withdrawal
D Deposit
E total (running total

The formula I have in E4 is =IF(B5="","",E4-C5+D5) which is the same formula that was in E4 in the original that I copied.

I just entered a deposit in column D and column E did not update with a running total. What could I have done wrong?

***UPDATE**
I figured out what I did wrong, my original formula was not in E4 it was in E5 Once I changed it in a new copied sheet everything Works fine thank you very much.

I guess the only question I have and I assume it does do this, does the formula =IF(B5="","",E4-C5+D5) take the entire columns of E,C and D All the way down the worksheet and run the formula?

[Pete_UK]

Well, the formula is looking for B5 not being blank - did you put something in that cell?

Pete

[Eaglepi]

Well, the formula is looking for B5 not being blank - did you put something in that cell?

Pete

Once I entered the formula in E5 then I did a test entry in the next row and filled in each Column everything worked fine the total was updated. My mistake was I put the formula in E4 where it should be in a five. Somebody wrote the formula for me I believe it was actually on this forum quite a while ago and apparently what this formula does is it looks in Column B and then updates in column E depending on the deposit or withdrawals in column C and D.

I did a test entry and it does work so thank you very much for your help I didn't think it would go this easy

[Eaglepi]

I guess I spoke too soon, now my new worksheet that I copied is not working with that formula. It did work when I first tested it but I saved it enclosed it and when I reopened it it was just blank. I tried to enter the data again and did a test in the running total does not update???? I don't quite understand because it's an exact copy of the current one that is working fine

I just deleted the formula in column E and reentered it and now it's working fine.