Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete rows of referenced cells...
HI
(microsoft.public.excel.programming) I am working on a excel sheet that works as per below pattern. I have two sheets namely LI and Looks_Like. I have 10 cells in Looks_llike sheet that are referenced to 10 cells from LI sheet. Which means on Populating the cell A1 in LI sheet cell A1 in Looks_like sheet gets populated with the same value. now my question is, Now if i have only 5 cells populated in LI sheet and the other 5 are empty, how do i delete the rows in which the blank cells of Look_like sheet are present that are referenced to these empty cells in LI. Can it be done using VB code If yes... I will be gr8ful if you can help mew with the code. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow Delete cells but not rows | Excel Worksheet Functions | |||
To delete the rows if certain cells contain the following | Excel Programming | |||
Delete Rows where all cells = 0 | Excel Programming | |||
Delete Rows where all cells = 0 | Excel Programming | |||
How to delete sheet that is referenced. | Excel Programming |