Hi there,

i have a VBA code that retrieves its data from an external excel workbook(masterplandata workbook) and copies it onto the (example workbook).

what the VBA code does:
1. retrieve the data for July 2018 by the fabric delivery column
2. copy the data according to columns of the example workbook
3. vba would not clear records in the example workbook with OFM, KH and Collar and Cuff as these are typed in by the users.
4. sort the records according to the PO column

Now with the code, i am not able to copy over the records. does anyone know why?

i have attached the example workbook below

Attached Files

	MasterPlanData.xlsx (12.5 KB, 22 views)
	Example.xlsm (24.3 KB, 12 views)