How to Create Auto Generate List

[ellehcer08]

Hi!! I have an excel worksheet named "recipe calculator", and I want to create a command button which creates auto-generate list to a NEW sheet.

But there is a lot of columns and rows in the "recipe calculator" sheet. For example, I will put a number/text in Column D, then the conditional formatting highlights the whole row. What I want is to input coulmns C, D, N, O, and the highlighted rows in the new worksheet when the command button for auto-generate is click. Is it possible?

Please, please, please help... Thanks a lot...

 

[villy]

can you provide a sample sheet please?

 

[ellehcer08]

as you can see in the image (i hope it shows!), i typed the # 1 in D10 which highlighted the entire row.. the button GENERATE INGREDIENT LIST has no macro yet. i want that button to generate/extract a list (when clicked) in another sheet the highlighted row but with just column C,D,E,N,O.

i tried the isnumber function with the advanced filter but it doesn't show every details (e.g, column D,E,N,O). can you please help me with this,.

thanks a lot