Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Delete if "X"

Hello I need some help... I need a way to delete a entire row if the value in
Column A is equal to "X", the tricky thing is this... the purpose is to have
a "Main Sheet" where I have some data and I type those "X"'s into Column A,
and thru Formulas or Codes to get those "X"'s into other sheet's Column A in
the way that when I run the code I delete the same row in those sheets at the
same time. I had some code that did a similar thing but with "Blank" rows the
problem was that on the other sheets where the "Blank" was given with a
formula (IF formula), that row wasn't deleted because it contained a formula,
which had gave nothing but still had a formula.

What I need doesn't need to work in the same exact way with the "X"'s and so
on, so anyway in which I can delete the same row in several sheets is
appreciated!

thanks in advance!
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Row Containing "x" in ColumnA in 2 Worksheets Ed Excel Discussion (Misc queries) 1 July 15th 06 05:43 PM
I can't delete a cell without deleting a row Tenny Excel Discussion (Misc queries) 2 June 30th 06 12:52 AM
how do I delete a worksheet from my workbook DLee New Users to Excel 2 August 15th 05 09:59 PM
Delete row depending on criteria adw223 Excel Discussion (Misc queries) 1 June 30th 05 12:55 AM
How to delete rows when List toolbar's "delete" isnt highlighted? Linda Excel Worksheet Functions 1 May 26th 05 08:39 PM


All times are GMT +1. The time now is 11:01 PM.

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

About Us

"It's about Microsoft Excel"