Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

Removing data only; save formula

I'm starting a new fiscal year and need to remove all the data from the current fiscal year; but save all the formula's.

I used F5; Constants and was successful at removing most of the data; but some some .

I'm sure it has something to do with the Details list data, ut I deleted the data on that page, so why is the data still showing up in the Master sheet?
Master-Budget-with-locked-data.xlsm
0
mikecox_
Asked:
mikecox_
  • 2
1 Solution
 
duttcomCommented:
There are still 6 rows with data at the top of the tbl_Details table on the Details sheet.
0
 
mikecox_Author Commented:
Oh!!  It opened with those out of site; never occurred to me to scroll down!
Thanks
0
 
mikecox_Author Commented:
Thanks
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now