auto populating second sheet

[azq2421]

I have a workbook that i use for pricing out a projects so the first sheet is a list of every product we use in broken down into columns like so

Supplier

QTY

Model

Description

Price

Item Total

<tbody>
</tbody>

Crown

1

CDI1000

Same as XTi1002; 70V 500W

$520.00

$520.00

<tbody>
</tbody>

the second through fourteenth sheet list each supplier that are on the first sheet in seperate sheets in a P.O form using the following column layout

Qty

Item #

Description

Unit Price

Line Total

<tbody>
</tbody>

how can i make only the items that have a qty of 1 or more on the first sheet auto populate on to the respective sheets for ordering purposes ?

any help would be great and i thank you all in advance

 

[My Aswer Is This]

So if column "A" has the value "Dell" then column "B" has a value greater then one you want this row copied to sheet named "Dell" is that correct?

But then you do not have the layout the same on Master sheet as on the P.O. Sheet

And on the Master sheet you refer to column ("C") as "Model" but then on P.O sheet you show Item # is item # the same as "QTY" or the same as "Model"

Help us out here and be consistent.

 

[azq2421]

So if column "A" has the value "Dell" then column "B" has a value greater then one you want this row copied to sheet named "Dell" is that correct?

But then you do not have the layout the same on Master sheet as on the P.O. Sheet

And on the Master sheet you refer to column ("C") as "Model" but then on P.O sheet you show Item # is item # the same as "QTY" or the same as "Model"



Help us out here and be consistent.

sorry for the inconsistency this is how the file was made. but hey if its that big of a deal I'm sure I can swap things around on the master sheet to make it work i know i can't change the PO sheets because that is how they need to be