You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Witam
mam arkusze Excela z wykazami towarów na kolejne miesiąca.
Każda z list zawiera pełen asortyment lecz w kolumnie "ilość" jest
często zero.
Chciałbym przed drukowaniem arkusza jednym kliknięciem (makro?)
ukryć wiersze z ilością zerową.
A potem szybko przywrócić widoczność wszystkich wierszy
Jak do tego podejść?
Janusz
bip
unread,
Mar 8, 2016, 2:29:53 AM3/8/16
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
W dniu 10.12.2015 o 13:59, JanuszK pisze:
Może najprostszym sposobem będzie filtrowanie, tzn. z menu {Dane} ->
{Filtr} -> {Filtr standardowy} i w oknie {Kryteria filtrowania} w
{Nazwie pola} wybrać "ilość", w {Warunku} "<>" a w {Wartości} "0"
JanuszK
unread,
Mar 8, 2016, 6:45:00 AM3/8/16
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message