Hide Formula Contained In A Cell

Jul 4, 2007

I have a worksheet in which one particular cell contains a certain formula. For security reasons, I wish to hide the FORMULA contained in the cell. However, the VALUE of the cell given by the above formula should always remain displayed for the user.
I want this to be done only for that particular cell. I tried hiding the formula bar,but it hides it for all cells.

View 9 Replies


ADVERTISEMENT

Display Formula Contained In Cell Within Worksheet?

Mar 11, 2012

I'd like to display a formula contained in a cell within the worksheet. How can I do that?

View 4 Replies View Related

Search Formula (return A Statement If A Certain Month Is Contained In The Text Within Another Cell)

Dec 21, 2008

I am trying to write a formula that will return a statement if a certain month is contained in the text within another cell. Formula is =IF(ISERROR(SEARCH("Dec",Assumptions!B2)),"Ensure Journal is Non Reversing","")

Cell B2 contains a date in the format of Dec 08, so if this date contains Dec, then return "Ensure Journal is Non Reversing", if it doesn't then leave the cell blank.

At the moment it is putting in the first test for every month I select and not changing to blank.

View 2 Replies View Related

Formula To Check Whether Value Is Contained In A List

Aug 12, 2008

I have the following data (as below).

Basically I want to check if a value is in AC but not AD, I would like to mark it as such in column AE i.e. mark all datevalues in column AD that aren't in column AC.

Could anyone please help with the required formula?.....

View 9 Replies View Related

Conditional Formatting Based On Value Contained In Another Cell

Apr 9, 2014

I have some problem with conditional formatting, basically what I'd like to do is color the cells, based on the value contained in one specific cell. I'm not able to make a formula that suits my job.

Basically I want to color code a cell if the value in a specified cell is between x and y.

I've attached a sample spreasheet: MrExcel.xlsx‎

View 1 Replies View Related

Trimming Certain Information Contained In 1 Cell And Putting Them Each In A Column

Feb 17, 2010

Need to trimming certain information contained in 1 cell and putting them each in a column. I could do left, mid & right but this time there is inconsistency in the content of the cell.

I've attached a file which will further give you an idea exactly what I want (formula to be in Column M to P).

View 2 Replies View Related

Adding Data By Row Based On Typing In Cell Contained In Row

Mar 10, 2009

I've built (but not completed) a spreadsheet used to organize multiple Bill of Material lists. This list is a row-by row list of products with information relating to a specific part number including: Mfg, Part#, Qty Used, Cost Ea, Vendor, among many more.

Here's what I'm trying to accomplish first. As this list grows, my intension is the be able to recall a row of data (or control what columns of the row are recalled) from this list and be able to easily add them to the list. I would like to be able to do this by typing in data in one cell in the row (like the Part#), and then have a macro or VB code that will automatically fill in a defined number of columns with the descriptive data like: Mfg, Cost Ea, Vendor, etc.

Currently, the data for the rows (if it already exists) would reside higher up in the list on the same worksheet but could also potentially be on another tab in the workbook.

View 9 Replies View Related

Hide The Formula In The Cell?

Jan 4, 2013

I have to hide the formula in the cell. nobody should see the formula in the cell without password.

View 1 Replies View Related

Add Hyperlink To Shape That Refers To Website Contained In External Workbook Cell

Apr 13, 2013

I've been trying without success to hyperlink a shape in one workbook that refers to a website contained in a second workbook cell.

The hyperlinked shape is in the current workbook and the website address is in a workbook called "data source.xlsx", sheet 1, cell A1.

My last attempt was this - ('C:UsersLouiseDocumentsMA[data source.xlsx]Sheet1'!A1)

View 3 Replies View Related

Index/Match: Populate Cell With The Information The Corresponding Letter Contained In The Table To The Far Left

Jan 7, 2010

I'm having a bit of a block with an index/match formula that I am trying to create for the attached spreadsheet. i.e. I need to populate cell J3 with the info the corresponding letter contained in the table to the far left. The numbers of reference to match are the 'zones' in H3 and J2.

View 2 Replies View Related

Hide Formula And Leave Cell Blank?

Mar 31, 2013

I am creating a worksheet for my buisness and I have input date of birth and have done a formula to work out ages but I dont know how to hide the formula and leave the cell blank so that when I create new information it automatically puts the age in.

View 1 Replies View Related

Hide Rows Where Cell = 0 (formula-driven)

Jun 24, 2009

I have formulas in cells B8:B365 that pull project names (in words) from a plugin using values specified in other cells (non-formula). If a project is inactive, the cell returns a 0.

I am looking for a macro that will hide the rows in this range where the B cells = 0. If there is no data at all, I want to leave the row as-is (unhidden). I also have 2 other specific sheets in the workbook that I'd like to include in the formula without having to repeat the macro 2 other times.

The one I am currently using just hides every row, regardless of if there is a title, a 0, or nothing. Here is the code (I don't know how to create those nifty little text boxes):

View 5 Replies View Related

Hide / Unhide Rows Based On Cell Value Containing Formula

Jun 17, 2014

I have the following code which works perfectly. It needs to hide rows 3:60 based on the value in K2.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("K2")) Is Nothing Then
If Not IsNumeric(Range("K2").Value) Or Range("K2").Value = "" Then
Range("A3:A60").EntireRow.Hidden = True
Else
Range("A3:A60").EntireRow.Hidden = False
End If
End If
End Sub

The problem I am experiencing is that I want to use a formula in K2. K2 must get its value from a cell on a different sheet.

If I manually delete the value in K2 the rows hide and if I manually enter a 1 in K2 the rows unhide, however I want to enter a formula in K2 that will result in either a 1 or blank cell.

View 3 Replies View Related

List - Filling In Each Blank Cells With Value Contained In First Non-blank Cell Above It

Feb 27, 2013

I have a list that looks something like this:

Column B

Row 4 Item 1
Row 5 Item 2
Row 6
Row 7
Row 8 Item 3
Row 9
Row 10 Item 4
Row 11
Row 12
Row 13
Row 14 Item 5

The range of cells in column B containing the items has a name "ColStreams"

I need to go through the list, filling in each blank cells with the value contained in the first non-blank cell above it - so, in this case, rows 6 and 7 would contain "Item 2", row 9 would contain "Item 3", rows 11-13 would contain "Item 4" and so on.

View 2 Replies View Related

Getting Chart Range From Range Address Contained In A Cell

Dec 3, 2013

I have a Choose function that is used to determine which range I need. e.g. =Choose(Choice,Cell,Cell,...).

In each corresponding "Choice" cell is a typed range. e.g. $B$33:$L$70

I'm looking for a way to be able to use this typed range as the range for some chart data.

View 2 Replies View Related

Got A "Mid": Copy A Value To A Refer Contained Within Another Cell

Mar 4, 2009

I am trying to copy a value to a ref contained within another cell.

BF3 is where the formula is to copy
BJ1 contains the cell ref of "H6"
BI10 is the next cell to select

I think the problem is activecell = Mid(BJ1,1,5) which is the cell to which i want to paste the value. BJ1 contains the ref in text format of "H6" I am therefore trying to copy the value in BF3 to H6

View 4 Replies View Related

VBA Macro Code Needed To Run The Code Contained Within A Cell

Dec 17, 2008

I have a macro that, when run, needs to read the contents of cell B5, and run the code that it contains.

Cell B5, for example, would contain the text:
Range("B13").Formula = "SUM(D12:D14)"

I need a macro to "execute this code", as if it were in the macro itself.

I have assigned the above to a variable, but am not sure how to execute it.

EG.


Dim the_calc
the_calc = Range("B5").value

Now, how do I run the_calc ?

View 9 Replies View Related

If Word Is Contained Within A Cell, Ouput That Word In Another

Jul 18, 2008

I have a bunch of cells in column b that have products.

Column B
Dell 24" lcd
vaio sony laptop
8.0 mpxl kodak camera
photoepsonprinter

Basically in Column A I want a formula that'll say.

If the word "dell" is somewhere in cell b1, then put the word "Dell" in cell a1.
If the word "sony" is somewhere in cell b1, then put the word "sony" in cell a1.

And then so on and so forth down through column A. The brand names are potentially endless, so is there a easy way to on like a seperate sheet make a list of brand names and have it pull from there?

Originally I made a if function that said if the brand name was contained in the cell then output the brand name, but that caps at 7 for the amount of brands i can use....

View 9 Replies View Related

Sum If Number Contained In A List

Dec 3, 2013

I have uploaded an example file and I need a formula to sum only the entries that are listed on the lookup sheet which match the contract name.

In order to do this the formula will need to look in column G and if there is a match on the lookup sheet then sum column Q. It would also need to match the contract name column U with Column B

I have provided an example of what I need as my description is not very clear.

The formulas would be required in the pink cells.

View 8 Replies View Related

Hyperlink To A Sheet Contained On Another Workbook

Apr 1, 2009

I have tried placing a hyperlink in a cell on sheet1 workbook1 to sheet1 of workbook 2 however it opens the workbook but does not take me to the correct worksheet stating: Reference is not valid.

Link is Abstractions.xls#Master for example

View 6 Replies View Related

Activating Sheet Whose Name Contained In Variable

Jan 20, 2012

I am attempting to use the code below to activate a sheet whose name is contained in a variable. The line in Bold gives me a "Subscript out of range" error even though the variables seam correct in the debugger.

Code:
Private Sub GetFromArchive_Click()
Dim wkb As Workbook
Dim strPath As String: strPath = "M:EfpDocsArchivesESI Processing Log Master Archive.xls"
Dim lngListItem As Long, lngSelected As Long
Dim varSheets() As String

[Code] .......

View 2 Replies View Related

Check If Two Ranges Contained On Same Worksheet?

Mar 23, 2013

What is the simplest way to do it in VBA?

View 3 Replies View Related

Autofill Cells With Information Contained In Other Sheet

Feb 9, 2014

I have a workbook with two sheets. The first one, let's call it the Main sheet, will be used to keep track of the touring artists of a record label. The second sheet contains a list of show venues with their respective contact info. Here's what the two sheets look like :

Main sheet
mainsheet.jpg

List of contacts
listofcontacts.jpg

What I would like is row D of the Main sheet to autofill, according to the contact information contained in row B of the List of contacts, when I enter a venue name in row C of the Main Sheet.

View 3 Replies View Related

Lookup The Values Contained Within The Matrix To Get Distances Between Them

Oct 8, 2009

I'm updating my database of distances between different cities in our records... but the source that i have to lookup is actually a distance matrix....something like this...

From/ToMumbaiPuneDelhiKochiBanglore
Mumbai024014501800900
Pune240015501650700
Delhi14501550028002400
Kochi1800165028000500
Banglore90070024005000

Now i need to lookup the values contained within the matrix to get distances between them. I'm hoping if i can do that i dont have to actually manually sit and list down all the possible combinations of cities and distances between them but directly lookup the distances from this matrix.

View 2 Replies View Related

Filtering On Specific Values Contained In Column

Oct 13, 2011

Column A
Row1 Orange-Apple-Pear
Row2 Orange-Grapes-Melon
Row3 Berry-Apple-Melon
Row4 Banana-Grapes-Melon
Row5 Orange-Grapes-Banana

Given the information above:

I want to find a macro that will auto filter on for example
"Banana" would filter to rows 4,5
"Orange" would filter to rows 1,2,5
"Apple" would filter to rows 1,3

View 4 Replies View Related

Excel 2010 :: Text Contained In Formulas?

Feb 29, 2012

I am working in Excel 2010.

I am looking over spreadsheets in a new job, and I am coming across formulas I am unfamiliar with?

For example, =(G16*G17/C13-G24)*hrs and =I25*elec.

hrs and elec??

After using the "Trace Precedents" feature, the "hrs" and "elec" are still a mystery to me. Are these variables that the creator of the spreadsheet has defined? They don't appear to be named data sets because they exist in just a few cells.

View 3 Replies View Related

Rows Contained In Non-Contiguous Named Range

Dec 1, 2012

I'm trying to write a 'ReImport' macro to copy data from one model into another. I'll call these models 'Master' and 'Split'. 'Master' contains about 50 departments' worth of financial data, and the 'Split' files contain a Division's (between 1 and 20 departments') worth of data. Structurally, the 'Split' files are just copies of the Master with the unneeded departments hidden. They are sent to various Divisions for completion, then the ReImport process takes data from the Split files and copies it back into the Master. Every Split File contains the full 50 departments from the Master, and it is only the 'Visible Row' distinction plus a 'ReImport key' that should determine what gets ReImported.

Each 'Split' range has a range name that controls what Departments are hidden or visible, but the range name is not contiguous. In other words, Division A might show Departments 1, 4-8 and 23. (Reordering the Depts is not an option.)

In a perfect world, I want to evaluate ONLY rows contained within the Division range name for the ReImport key. But the non-contiguous aspect of the named range is throwing me off. So in the above example, JUST Departments 1, 4-8 and 23.

My second-best solution would be to search through Departments 1-23, though that would be much slower...

View 5 Replies View Related

Listing Sheet Names Contained Within Workbook?

Mar 22, 2014

I have created a file that has several worksheets with different naming convention - to specify what the sheets are for. However, as the sheets are added, I sometimes find it difficult to keep track of all the sheets that I have in the workbook.

Is there a Macro Code or formula that I can use so that a Summary worksheet can summarize all the names of the worksheets that I have in the particular workbook.

View 5 Replies View Related

Function: Selected String Contained Certain Phrases

May 13, 2008

I wrote this function to see if a user selected string contained certain phrases. It keeps returning united states so i am guessing its not cycling through the entire list.

Function region2(searchString As String)
Dim result As String
result = "None"
Dim lng() As String
lng = Array("arabic", "belg", "bul", "czech", "dan", "dut", "dutch", "euro", "finnish", "french", "ger", "greek", "greenland", "hebrew", "hung", "iceland", "international", "ital", "nor", "pol", "portu", "russ", "slov", "spanish", "swe", "swi", "turk", "UK", "united kingdom", "states")


Dim Country() As String..........

View 9 Replies View Related

Pivot Table (enter A Certain Criteria That Would Be Contained In The Text)

Nov 8, 2009

I've got two columns with data. The first is text, and the second is numbers. So I want to be able to enter a certain criteria that would be contained in the text, and have excel return a list of the rows of text that contain that criteria and that have the highest 3 values in the corresponding column. I can use multiple cells to do this if need be (i.e. one cell for the text with the highest value, one for the second highest value, and a third for the next highest value).

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved