I have stock sheet so some times when I filter items which have quantity with zero quantity then I delete these items it delete these item and other item so it make the data not correct
so I need an accurate way to delete only items which I don't need
thanks
Hi,
Please upload the workbook so that we may see your request in context. Explain what actions you are taking with reference to specific cells.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
this is stock sheet and I want to delete item with net qty =0 and don't delete any other item
what shall I do
from Filtered Data
Select D347:D13380
Then Press Ctrl+G or F5
Then Click on Special Button
Then Select Visible Cells only
Then Press OK button
Now Delete the Rows (by pressing Ctrl and - keys)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
is there any other ways more quickly than this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks