Copying a row to another worksheet with a twist

[Honestfletch]

Hi,

This may be impossible without complex scripting, but here goes.

I work at a lumber mill, and I am trying to track "Culled" lumber % by supplier, dimension, ect. - I have a simple spreadsheet set-up and have been adding to for 5 months now and it is servings its purpose in a simplistic manner.

What I would like to do, is be to be able to copy a specific row to another worksheet based on the value of a Cell. I.E. If Value of cell B2 is = 1 then copy that whole row to a specified worksheet. It should also be noted that there may be up to 20 or so worksheets that they could post to.

I have created several spreadsheets and some quite involved, but I have never ventured into scripting, VB, or macros ect. (yet) - but if this is what I need, then I am willing to learn if someone would be so kind as to point me in the right direction.

Thanks in advance for any help.

Cheers
Fletch

 

[Tazguy37]

Welcome to MrExcel Board!

If you want to do it without coding you can:
Select the column you want to copy.
Go to Data, Filter, Autofilter.
Select the value to filter on (1, in your example)
Copy the visible cells to your other sheet.

If you need (or would prefer) a VBA solution, somebody here could provide you with that, I'm sure. Hope that helps!