ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sorting (https://www.excelbanter.com/excel-programming/299664-sorting.html)

Tomasz Lelek

sorting
 
Hello,
I wrote macro which generates forms filled with zeros.User inserts values
into forms instead of zeros and now I need these values to be sorted during
or automaticaly after finishing of insertion of all. I tried pivot table,but
it needs to be refreshed manually.I would like to avoid creating this form
with macro in it, but if this can't be done other way,please tell me how can
I do it.
Thanks
Tom



Frank Kabel

sorting
 
Hi
for an automatic sort you'll need VBA.

--
Regards
Frank Kabel
Frankfurt, Germany

"Tomasz Lelek" schrieb im Newsbeitrag
...
Hello,
I wrote macro which generates forms filled with zeros.User inserts

values
into forms instead of zeros and now I need these values to be sorted

during
or automaticaly after finishing of insertion of all. I tried pivot

table,but
it needs to be refreshed manually.I would like to avoid creating this

form
with macro in it, but if this can't be done other way,please tell me

how can
I do it.
Thanks
Tom





All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com