Hiding Values In Individual Cells?

Apr 27, 2014

What I need to do is hide the value in an individual cell, dependent on whether a value (any value) has been entered in another cell. I know this must be possible somewhere in conditional formatting but I can't seem to figure it out no matter how much I try!

The table below should hopefully explain exactly what I'm after. I want to hide the value in the balance column (automatically calculated)when no transaction has taken place (ie, there is no date entered in the date column). At the moment this value appears all the time.



View 7 Replies


Hiding Individual Cells

Aug 2, 2008

is it possible using excel 2002 to hide individual cells instead of whole columns or lines

View 9 Replies View Related

VBA Code To Get Individual Values In A List Placed Into Individual Cells

Apr 7, 2014

My current project involves sorting a spreadsheet, selecting specific qualifying data from the sheet, storing it into a variable, the pasting the individual values from the list into individual cells on a different sheet within the same workbook. Here is the code I have so far...

Sub Test()
'' freeze screen updating to remain on main worksheet
Application.ScreenUpdating = False
'' move to Avaliable worksheet
[Code] ..

When this code runs the first item in the list pastes into Sheet10 A1, but no other values from the list are placed into Sheet10. Previous to this I had been using a variation of this code to push the list into a combobox list within a userform. In that case instead of

ThisWorkbook.Worksheets("Sheet10").Range("A1") = x

I had

Combobox1.list = x

And this worked perfectly; creating a list within the combobox (in fact I can use this modification to interrogate my code to determine if the list is being properly generated, and it is).

View 2 Replies View Related

Count Individual Values From Multi Value Cells

Mar 1, 2013

I have a column with (potentially) multiple values in, heres an example:

Marketing Specialism

Commercial, Multi-channel, Loyalty/Retention

Analytics, Partner


Commercial, Analytics, Segment


What I need to be able to do is count (and then chart) the number of each value, irrelevant of whether it appears with another value in a cell. e.g.

Analytics, Parter - Would count 1 Analytics and 1 Partner
Analytics - Would count 1 Analytics

I know there is a formula where I can specify the value to count, but as the column has so many different values I would have to write a formula with each separate value, this would take a long time.

View 2 Replies View Related

Find And Replace Multiple Values Within Individual Cells?

Mar 13, 2014

So I have a list of organizations in Column A, with multiple names (anywhere from 0 to 50 names) for each org. in Column B.

Company A
Brown, Jones, Smith, West


I want to do a find and replace for all of Column B, where all the names are replaced with their respective color values. If possible, I'd like this to all happen with the individual cells (so for example, B3 might go from "Brown, Jones, Smith" to "Red, Red, Blue").

If that's not possible, I could divide all the names into individual cells and then find and replace.

View 3 Replies View Related

How To Split Massive List Of Values Into Individual Cells Down A Column

Mar 26, 2014

I have an issue with being able to process my data i have a text file in notepad that lists a massive amount of values (enough for excel to process if they are listed down a column but not across a row) each separated by a space. As an example here is a small portion of the data.

81768102 191193210 386225426 110858190 393958997 21773704 22450052 70617438 843133051 103582830 370163346 819494826 109538724 846339187 19638405 50748904 476397524 128490548 134215188 252862729 387318907 82658728 15822910 199255054 172623979 59872284 773581712 124854321 547098635 604524102 45265054 203132867 225629848 215828319 14779508 300950341 715797961 329121584 366323012 583555062 917794380 216847744 784432795 606179111 537865871 500392632 37701513 830010548

I know how to import this as text but i can only wither get it all in one cell or across the 1st row. The first row can only display about 16000 values and that isn't enough for my end product to be accurate enough.

So is there any way to import the text file and have it formatted so a each new value has its own row? For example...

Or is there anyway to get the data from my already imported giant A1 cell into the above format?

Added an example of how it looks and how i want it to look. This is how it looks when i open the txt file containing my data in a way that all values stay in the excel sheet. As well as this there is an example of how i want it or rather need it to look.

View 9 Replies View Related

VBA For Hiding Cells Based On Values?

Apr 18, 2014

I'm using the below macros to hide or unhide rows based off of a value in column A. Column A contains an If statement that looks for a value in column F, and depending on whether the corresponding cell in column F contains a value the if statement returns either True or NO-IF(F>0,True,"No).

It currently takes quite a bit of time to run this macro. Given the specs on this machine, I'm convinced that there is probably some loop or inefficiency in my code.

Sub Button1_Click()
Dim cell As Range
For Each cell In Range("a59:A1472")


View 3 Replies View Related

Hiding Formulated Values Derived From 0 Value Cells..

Dec 7, 2009

I have a sheet with cells that will vary and change in value. The far right column (in this case G) is calculating a percentage from cells in columns D and F. At the moment only 9 rows are being used but I have made provision for the list to extend down to row 100 for future use. Cells in columns D and F are receiving their values from sumif formulas on another sheet, therefore a lot of cells are showing a 0 value for the moment (which I have formatted to show blank).

My problem is that I have cells in column G (percent formula) which are of course showing #DIV/0! due to the fact that they are calculating cells with 0 value. How can I format the cells in column G to show blank until they receive a real calculation!

View 2 Replies View Related

Automatically Hiding Rows Without Values In Certain Cells?

Mar 23, 2012

Does Excel have the ability to automatically hide rows without values in certain cells?

For example:


ABC1Route NumberTechnicianNumber of Units Cleaned25Tony237Don749 511Ray12613James16715Chuck21817

In this example, Rows 4 and 8 would automatically be hidden, leaving the other rows displaying. Of course, somehow I'd have to "Unhide" these rows at some point to add data if needed.

This is for a spreadsheet that is about 500 rows. Conceptually, I would automatically hide the rows w/o data in column B, analyze (or print) the worksheet, then "Unhide" the columns to enter data the next day.

View 2 Replies View Related

Extract Multiple Dollar Values With Decimals From String Into Individual Named Cells?

May 21, 2014

I'm pasting XML data into a spreadsheet and trying to create a vba tool so I can work with the values in a different configuration.

Here's an example of the XML data when pasted into Excel and how I'd like to organize it:


View 1 Replies View Related

Hiding Redundant Values From Multiple Sets Along With Adjacent Values

Aug 2, 2013

I am working on creating a spreadsheet that can be updated by those unfamiliar to excel. I have a master list on one sheet and three separate lists for business, individual, and general. Each list has three columns giving name, address and postal code. There are numerous repeats on these lists and I wanted to hide any duplicates while keeping my cells aligned. So far I have been able to highlight any duplicates, but was interested in some function that would save at least one duplicate while hiding any additional ones.

View 2 Replies View Related

Formula To Count Individual Values?

Dec 9, 2011

I need a formula which would count all the indiividual values in a column Ive tried counta's but this doesnt work



I want the result to be 3, 1 for A, 1 for B and 1 for C

View 6 Replies View Related

Macro’s For Individual Combo Values

Dec 26, 2007

I have created a combo box and have inputted the values

Jan, Feb, Mar (think you get the idea).... Dec

I am looking to assign a macro to each value so that each one shows a graph, i have already created the macro’s to show the graphs. Just unsure how to make them work with the combo box

View 9 Replies View Related

Counting Number Of Individual Values In Array?

Apr 23, 2012

I need a formula which ignores duplicates and uniques in an array, which returns the number of individual values.

A comma denotes a new cell;


In this case, the answer should be "6".

View 3 Replies View Related

Action Based On Individual Values In String

Aug 10, 2006

I need to read a binary value and trigger an action based on whether the each value is 1 or 0.

So for binary 1001

1 switch on
0 switch off
0 switch off
1 switch on

Assuming i know how to switch on and off does anyone know how to make the determination based on individual characters in a binary number string?

View 3 Replies View Related

Delete Individual Matching Values From A Column - Error

Mar 15, 2012

I am using this code below to delete individual matching values (the value in "A2") from a column.

Set Found = Columns("AH").Find(what:=Range("A2").Value, lookat:=xlWhole)
If Not Found Is Nothing Then Found.Delete Shift:=xlShiftUp

I am receiving error "Delete Method of Range Class Failed" in the highlighted line.

View 3 Replies View Related

Hiding The Duplicates Values..

Sep 4, 2009

I'm trying to hide all but one duplicate value in a list; I have a report that can give multiple results for each record, but to make it cleaner to read I want to hide the duplicate values, such as customer names etc. after they have first appeared. I'm aware this may not be a very clear explanation so have attached an example spreadsheet.

The left-hand list is similar to what I would start with and the right-hand list is what I am looking to achieve. Conditional formatting will format duplicates but will obviously all to all and can't use the remove duplicates function as it will take away the unique values alongside them in the row. Preferably I'm after a solution that works in both '03 and '07 but it's not a disaster if I can only do it in '07.

View 5 Replies View Related

Hiding Values In A Cell

Jan 10, 2010

I have 3 columns on my spreadsheet with 100 rows:

- each cell in the 3rd column has an equation in it as such:
=h4+f5-g5 which means that the current cell in column 3 is adding the value of the cell just above it + and - the values of the cells on the left to it. This works fine, the only problem is that even though nothing is entered in row 40 for example, there still is a value based on the last calculation in row 5 for example - this value shows all the way down to row 100. Anyways,

How can I hide those values in column 3 all the way down to row 100 if nothing is entered in the other 2 rows?

View 10 Replies View Related

Copy Row Or Individual Cells In Row?

Apr 23, 2012

I have a spreadsheet with multiple columns, column N contains different countries (some are blank). I want to copy all data in that row (except columnt H) to a new sheet if N = USA.

Macros are disabled so a formula(s) is needed.

View 5 Replies View Related

Protect Individual Cells?

Mar 17, 2007

I am running a loop that changes the value in one cell at a time. Since this is for our entire company, I am trying to make it "idiot-proof" like most of you have done.
While in the loop, I want to unprotect a cell, change the value, then reprotect the cell. But the rest of the worksheet is going to be unprotected for now. is that possible? Or do I have to protect the whole sheet, and then .Unprotect the whole sheet first and then. Protect it at the end of the macro.

View 3 Replies View Related

Auto Hiding Rows With Zero Values

Apr 6, 2014

I'm using the following code to hide rows with zero values in my workbook. I have 10 sheets for potential data/products and a "summary" sheet that is set up to pull all the information from the 10 sheets. I often don't use all 10 sheets so there are a lot of blank cells. I set up the code below to hide zero values to make the "summary" sheet easier to work with. I am encountering a problem with cells that are formatted as dates. a zero value/empty cell shows up as 1/0/1900 and is therefore not auto hidden.

Either any adjustment to my formatting or code to automatically hide these blank date cells on the "summary" sheet?

Private Sub Worksheet_Change(ByVal Target As Range)Dim c As Range
For Each c In Range("C3:C8778")
If c.Value = "0" Then
c.EntireRow.Hidden = True

[Code] ...........

View 4 Replies View Related

Add Text To Individual Cells Which Can Be Written Over?

Aug 9, 2013

Is it possible to add text to individual cells which can be written over?

e.g. I would like A1 to have the background text of "slot 1"... Once user has inserted text then "slot 1" is removed... and when the user text is removed, "slot 1" reappears.

View 2 Replies View Related

Change Range To Look At Individual Cells

Jul 7, 2008

how to change an argument in VB to range to each and every individual cell in the range?

At the moment i have :

If 100 < Application.Min(Range("G5:O5")) Then
but i want to change it to :

If 100 < Application.Min(Range("G5 or H5 or I5 or J5 or K5, etc).

I think that "or" is the correct way to describe it.
I guess i mean that i want the formula to look at each individual cell instead of the above code.

View 9 Replies View Related

Use Individual Cells In A Text Story

Apr 11, 2007

I would like to be able to write an article with data extracted from an Excel workbook. An understandable example would be like the books for kids which are personalized.

For example, using this data:

Name Friend1 Friend2 Town State Pet1 Pet2
Karen John Harrold Portland Oregon Snippy Goldie
Luke Mike Mark Solon Maine Charlie Max

I would like to write to a text file, vba text box, something like:

One day, B2 went down to B3's house to play a game. B3's cousin, C3 was visiting from D3, D4.

Which would output:

One day, Karen went down to Harrold's house to play a game. Harrold's cousin, Mark was visiting from Solon, Maine.

The text can be simple, no font formatting.
The data is coming from different sheets in the same workbook.
The data includes text, dates, and numbers.

View 8 Replies View Related

Hiding Rows Based On Multiple Values

Aug 7, 2012

I've tried several approaches on how to code this, but can't figure out how to work it. I have a large spreadsheet; which dynamically changes in both column and row counts. So, I have an array of values. If any cell has a negative value, that cell text needs to be changed to red AND that row needs to remain displayed. If ALL values in that row are >=0 then the row can be hidden.

The array is actually a pivot table named QTD

For Example: If cell D5 = 5 and F5 = -3 then Row 5 should remain displayed.

If Cell D6 = 5 and F6=0 then row 6 should be hidden because all values are > 0

Then I was thinking of using the case statement to hide the rows but can't figure the syntax. I'm open to any other means of performing the taks as long as the initial array dynamically to encompass all the data.

View 7 Replies View Related

Hiding Particular Rows By Comparing Values In Array?

Mar 25, 2013

I need to hide the rows in an excel whose value is equal to the array list that has been already hardcoded...How to do this...

View 1 Replies View Related

Hiding Zero Values From The Chart Data Range

Jul 7, 2014

I am currently building a tool that works with an undefined range of input variables, e.g. I now have a range of 200 values but it could just as easily be 400 or 100. I am using these values for further calculations and have thus 'dragged down' to cells that in some instances are empty, resulting in values that are 0. I'm also building a chart based on these values, but it shows the values that are 0 as well!

Is there any way to just plot the non-zero values without changing the data range?

View 1 Replies View Related

VBA - Hiding Columns Based On Cell Values

Mar 20, 2014

the support this board has given me as I learn VBA. I have three columns - Q, R, and S. I only need to see columns R and S if the cell values don't equal those in column Q or each other. So if I have cell values like the ones listed in the example below, then I don't need to see columns R and S.

Q Header
R Header
S Header


View 4 Replies View Related

Copy Individual Data Values In One Column To Single Cell Location On Multiple Sheets?

Jan 24, 2014

I am trying to come up with the most efficient way to copy data to multiple sheets within the same Excel workbook. The original data exists within one column on a summary sheet (could have up to 500 individual entries). I want to copy each individual entry to a unique sheet (that already exists), but in the exact same cell location within each sheet. I would only want to copy the original data value and not any formatting. Is there an efficient way to do this?

In my example spreadsheet, the original data is on the SUMMARY sheet. Sheets A through J would be the target sheets, with cell B2 as the target location for each of those sheets. My example shows the result of a manual copy paste value process, but I am hoping to automate that.

View 14 Replies View Related

Removing Duplicate Words In Individual Cells?

Aug 8, 2014

I have a column that is filled with various car brands that a dealership might sell. The data in the cell may look like CHRYSLER; CHRYSLER; CHRYSLER which I would want to just say CHRYSLER. If the cell says CHRYSLER; FORD; CHRYSLER; FORD I want it to just say CHRYSLER; FORD.

View 1 Replies View Related

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