Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 19th 05, 04:13 PM
David Smith
 
Posts: n/a
Default Locate and delete specific cells

I need to locate all cells that have a specific value, then delete those
cells and the cells to the immediate left of those with the specified value.
Once the cells are deleted, I want to shift the remaining cells up.

I have worksheets with names and values. The values are frequently "NA". I
need to delete the values of NA and the name associated with that value, I
then want to shift everything up so as to remove all the blanks. Right now
I anm doing it manually, and I am sure there is an easier way of doing it.



  #2   Report Post  
Old January 19th 05, 04:45 PM
Peo Sjoblom
 
Posts: n/a
Default

You can do that directly withour first deleteing the values, select the range,
press F5, select special and then select either formulas or constants and
uncheck everything but errors, then press enter or click OK, Then press ctrl
+ - (control key and minus key), select shift cells up or entire row
depending on what you have in other columns


Regards,

Peo Sjoblom

"David Smith" wrote:

I need to locate all cells that have a specific value, then delete those
cells and the cells to the immediate left of those with the specified value.
Once the cells are deleted, I want to shift the remaining cells up.

I have worksheets with names and values. The values are frequently "NA". I
need to delete the values of NA and the name associated with that value, I
then want to shift everything up so as to remove all the blanks. Right now
I anm doing it manually, and I am sure there is an easier way of doing it.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017