Solved

Removing data only; save formula

Posted on 2013-06-13
3
243 Views
Last Modified: 2013-06-13
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
Comment
Question by:mikecox_
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
duttcom earned 500 total points
ID: 39246281
There are still 6 rows with data at the top of the tbl_Details table on the Details sheet.
0
 

Author Comment

by:mikecox_
ID: 39246326
Oh!!  It opened with those out of site; never occurred to me to scroll down!
Thanks
0
 

Author Closing Comment

by:mikecox_
ID: 39246327
Thanks
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question