Auto Fill formula using conditional formatting across tabs

[UK_Richie]

Hi There,

In the attached spreadsheet within the the Stock Take tab I want the cells G6 and H6 downwards to fill in with to auto fill from the Product Sales tab with those that have AC as its status.

Hope that makes sense, and hope you can of help.

Many thanks,
Richard

[JeteMc]

Try the following:
1) Select Stock Take G6,
2) Paste the following array entered formula* into the formula bar:

Please Login or Register  to view this content.

3) *While G6 is still in edit mode simultaneously press the Ctrl, Shift and Enter keys,
4) Copy down.
5) Select Stock Take H6,
6) Paste the following formula into the formula bar:

Please Login or Register  to view this content.

7) Press the Ctrl and Enter keys,
8) Double click the fill handle to copy down.
Let us know if you have any questions.