toggle menu
Activity
Categories
Discussions
Best Of...
Groups
Sign In
·
Register
Sign In
·
Register
Activity
Categories
Discussions
Best Of...
Groups
Sign In
·
Register
×
Home
›
Accounts Business Range
Discussion
Budgets
Author
Date within
1 day
3 days
1 week
2 weeks
1 month
2 months
6 months
1 year
of
Examples: Monday, today, last week, Mar 26, 3/26/04
Search
Budgets
Nadine
Member
Posts:
55
✭
November 2017
edited July 2020
in
Accounts Business Range
When starting a budget from scratch, but using the profit & loss data from previous years, can you remove line items that you know won't reoccur?
0
Comments
John Graetz
Member
Posts:
1,649
✭✭✭
November 2017
edited July 2020
Yes Nadine. Just replace any prior year figures with a blank, rather than a zero. You can change the first column to blank and then use the "copy across" function to copy that blank cell to every other cell on the same line.
John L G
0
Nadine
Member
Posts:
55
✭
November 2017
edited July 2020
Hi John So if I do that will those lines be automatically removed?
0
John Graetz
Member
Posts:
1,649
✭✭✭
November 2017
edited November 2017
Yes Nadine - as long as the cells are blank and do not have any figures such as a zero.
John L G
0
Nadine
Member
Posts:
55
✭
November 2017
edited November 2017
Thanks for your help John.
0
Sign In
or
Register
to comment.
Comments
John L G
John L G