How to bring number that are relevant only

[sachi1982]

Hi All,

I need to fill this 3rd party template and is there a way i could bring only the required in for.
For eg: i have 200 product codes in a separate excel sheet and i only need to bring 100 product codes to the template. in the original 200 list i have column say whether to publish or not.

So is it possible me to get only product codes that are supposed to be publish through a formula. The 3rd party template cannot have empty line. only the products that we want to publish.

Please help.

Thanks,
sachi.

 

[alansidman]

This can be accomplished with VBA. For this to happen we need some information. Name of both sheets. Column holding product code to be copied. Column holding info Publish or Not. Column to Publish codes in (copied to?)

 

[kvsrinivasamurthy]

Pl upload a sample of data and result required from it.