VBA on how to copy specific columns to another sheet based on criteria in a certain cell? (ignoring blanks)

[mjaeger1]

Hi All,

Thank you for all you help so far. I'm working on a 'Quote Template' where i utilize vlookups and drop downs to retrieve 'part number' and pricing based on selections made.

Is there a VBA that can be used to copy data only in columns P, O, S, U when there is a value (successful vlookup) in column S, and paste that data on a separate sheet? (this sheet goes on past this data)
I would need the macro to skip any blanks or errors all the way doen the sheet.

Please let me know if you require more info.

Thanks!

NBC Fiber QuickQuote - Final - V 1.4 DL.xlsm
	A		C		E		G		I		K					P	Q	R	S	T	U
11	Fiber Patch Cords		Fiber Type		Fiber Construction		Connector A		Connector B		Length (Meter)					Leviton Part Number	Description	Cut Sheet	Quantity	Priority	Estimated Lead Time
12
13
14
15
16
17
18
19
20
21
22
23
24			To Configure Fiber Patch Cords Online - CLICK HERE and input PN to column 'P'
25
26
27
Fiber Quick Quote Tool