# auto populating second sheet

#### azq2421

##### New Member
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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### My Aswer Is This

##### Well-known Member
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

##### New Member
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

Replies
0
Views
285
Replies
1
Views
215
Replies
1
Views
176
Replies
0
Views
145
Replies
1
Views
285

1,191,189
Messages
5,985,198
Members
439,947
Latest member
fabiannic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back