Hi there,
I'm working on a sheet for my truck, i have done the basic macros with my knowing and recording of macro's. But now i'm stuck...
I'm working on excel 2016 pro
What i'm trying to do :
I got a worksheet of stock in my truck like an inventory, the size and count are variable always(could be 100 entries or 168, it's always depend).
On my sheet 3 in column O i got variable like electricity, paper, tools etc. That column never have the same number of entries(in variable and length).
I need to find all electricity and cut them(all the row) into a new sheet name electricity(create the new sheet at firts) and paste it from line 2 to the bottom(line 1 is the header, from sheet 4 line 1), and doing it for every variable in the column O sometimes it can be only 3 variables sometimes he cant be 12 variables. So i need the macro to sort them all and extract them to another sheet with their name.
I try to learn the row count method, but i think it really too much advance for me now. I hope i'm clear in my explanation.
If you have any question just ask me and i will try to make it clear. Thanks in advance for your help so much.
Francois
I'm working on a sheet for my truck, i have done the basic macros with my knowing and recording of macro's. But now i'm stuck...
I'm working on excel 2016 pro
What i'm trying to do :
I got a worksheet of stock in my truck like an inventory, the size and count are variable always(could be 100 entries or 168, it's always depend).
On my sheet 3 in column O i got variable like electricity, paper, tools etc. That column never have the same number of entries(in variable and length).
I need to find all electricity and cut them(all the row) into a new sheet name electricity(create the new sheet at firts) and paste it from line 2 to the bottom(line 1 is the header, from sheet 4 line 1), and doing it for every variable in the column O sometimes it can be only 3 variables sometimes he cant be 12 variables. So i need the macro to sort them all and extract them to another sheet with their name.
I try to learn the row count method, but i think it really too much advance for me now. I hope i'm clear in my explanation.
If you have any question just ask me and i will try to make it clear. Thanks in advance for your help so much.
Francois