Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Auto Delete Formula and leave resulting value
Thanks Skip for your response, but I'm looking for an automated solution, the copy/paste combination is very much reliant upon human activity. My reason for doing this is that there are financial values, specific to dates that I'm sourcing through formula, but these values change and are no...- Brinny
- Post #3
- Forum: Microsoft: Office
-
Auto Delete Formula and leave resulting value
I have a multi-sheet Excel 2007 document that I would like to lookup a value based on a start and end date. This is simple enough, but I want to have the formula auto replaced by the resulting value so that it then becomes static and not dynamic when the contributing values change. Any ideas?- Brinny
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Counting Spaces in a Text Field
How can you count the number of spaces (eg " ") that are within the one text field? I'm interested in code only.- Brinny
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
