Cut & Paste Non blank cells to another worksheet

[dhyatt58]

I have a workbook and one worksheet lists qty and material description. I would like to copy and paste only the rows that a qty was input next to a material description. I want the copy/paste into another worksheet.

qty material description
1 1" pipe
1-1/2" pipe
2 1" 90
2 1" ell
cplg

I would only want to copy and paste the rows that there is a qty. I am using excel 2010 and know nothing about programming as you can tell. Any help would be appreciated.

Thank you

 

[venkat1926]

can you autofilter column A -custom-non blank and copy filtered data to another location

 

[dhyatt58]

I tried a macro that would auto filter and removed the blanks and copied and pasted to the other location, the problem is that if quantities are changed it will not update the other form. I am no expert either and I've tried several different things by recording a macro and I've had no luck. That is why I turned to the forum to see if I could get some help with it. Thank you for replying to my post.

 

[venkat1926]

" quantities are changed it will not update"

do you want something automatically change if data is changed. then you m must use "event code" instead of a simple macro. Post a small extract of your data and how you want this to be copied in another location.