You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Select & Clear Entire Row Based on Cell Value

Select & Clear Entire Row Based on Cell Value

Price: FREE

The idea is that a value is dropped into a cell (A3) via a drop down list
I would like the entire row that that particular value exists to be selected and then after a message box warning, clear the contents of that row. The first row that any data exists starts at A15, and the last column of data would be column AF

Visit publisher's web-site: Select & Clear Entire Row Based on Cell Value

Category and Tags: ExcelTutorials :

Related Tutorials

Entire row select and delete !

Free: Yes
Tags: Excel ›

I've got a large Excel file that I need to keep 1 record in 7.
So I'll run through it with a Rows = 1 to 100 loop.
I'll select an entire row if one cell meets a certain criteria and delete the entire row.
What's the command for selecting entire rows and is it possible to delete such selections ?
Please the commands.
I thought it was
EntireRow.select
selection.delete
but that doesn't compile.
I'd like the row to disappear so I might use a shift 1up command.

select entire column based on cell value

Free: Yes
Tags: Excel ›

in my macro, I'm trying to have the macro select an entire column (ie W) based on the cell value my users will input ( ie W). Here is my code with the column value hard coded.
' Macro2 Macro
Columns("W:W").Select

Conditional format an entire row based on one cell

Free: Yes
Tags: Excel ›

Is there any way to have an entire row shaded based on a value in that row. I want rows to be shaded once if a date in the row has passed.
I have tried using the =IF($V3<TODAY,1,0) and then selecting my shading colour, having highlighted the entire row, but nothing happened. Any help would

Find & Replace

Free: Yes
Tags: Excel ›

Is it possible to replace the contents of an entire row if that row has a cell which was found with the F & R function?
When using the F&R function it found 132 instances of the find criteria. I would like to clear the contents of the entire row for all 132 matches.

how to select entire row and column in a sigle cell selection

Free: Yes
Tags: Excel ›

I want to select the entire row and entire column on selecting a single cell.

Related Applications & Scripts

Acronis Back and Recovery Server

Free: No
Tags: Software › Excel Backup

Recover an entire system, single file or folder
Best of breed disk imaging and bare-metal restore technologies allow you to recover your entire system quickly without having to reinstall the operating system and the applications.
Do you need just one file? No problem with catalog it can be quickly found and recovered wherever it is located.
Acronis Backup & Recovery 11 Advanced Server license allows backup and recovering of Windows or Linux server with Acronis Backup & Recovery 11. It provides disk-based backup, disaster recovery and data protection, with support for disk tape and cloud storage options, catalog with search and centralized management.

AS3 Country Select

Free: No
Tags: Flash › Excel Forms

CountrySelect is a small and lightweight AS3 flash applet that let the user visually select, via a scrollable list, a country of the world. This small utility reads the country list from XML , creates a list with the names of the countries and their flags, and let the user choose from this list. In addiction a geo location script preselects the correct user country according to user IP address. The applet is plug&play, as is self contained in a MovieClip you can drag&drop into your movie; little or no configuration is required for the script to work. This apple is coded in fully OOP AS3 , with external reusable classes.

Real Estate WebTemplate

This Real Estate Web & Dreamweaver Template was designed to make feel warmth, summer, beauty, cleanliness, youth and passion. It uses vivid and clear colors. Destined to real estate agencies, or similar types of businesses that sell or rent properties.
Integration with Dreamweaver allows to create a site based on this design with just a simple click from a Dreamweaver menu , which will automatically produce an example of a page that is easily editable and which fully complies with all XHTML and CSS standards and makes optimal use of images while being light and fast. Beside the actual Dreamweaver extension, we also offer the original design source in PNG format which you will be able to edit as you see fit.

Elegant Neon pre-loader Horizontal Drag&drop

Free: No
Tags: Flash › Excel Preloaders

Included are too versions an External SWF pre-loader and the internal pre-loader both are customizeable and are fully commented. The preloader consists of 2 percentage based bars which scale x axis (Horizontal)according to the % of loaded content.
A percentage indicator displays the percentage number loaded and follows the main y axis loadbar. The movement of the percentage indicator is percentage & animation based i.e. every 1percent increase will move the indicator 1 frame each time until 100% is reached.

Simple JS Calendar

Free: Yes
Tags: JavaScript › Excel Calendars

This Calendar control is so self explanatory as you can see in the picture below. Selected Year & Month are always visible and clear color differences in different portions of the calendar to make it more eye catching and user friendly. Tooltips are also given to improve its usability.
This is very easy to use JavaScript Calendar Control with so many customization option. Date format can be change as different database support different date formats. It also supports multiple instances on same time and all the instances are completely independent with others. It is compatible will all major browsers and different style sheets can be defined to all different instances means every instance can be show in different color scheme on the same page. It also support expiry date feature so you can prevent users to select past dates. There are lots of other customization options as well.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing