Copy Based on Multiple Criteria to a Different Sheet

[Haree]

Hey ,

I am attaching the sample Data

Daily Sheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date	Rate	Category	Item Name	Party Name	Particulars	Weight	Amount	Date	Category	Party Name	Particulars	Amount	Add 1	Add 2
2	01-04-2020	ABCD 1111	S Sales	SKU0001		New Item	168.25	1680.25	01-04-2020	Expense		Tea Expenses	50
3	01-04-2020	ABCDEF 11.11	Others			Purchase Return		880
4	01-04-2020	ABCD 1111	Debtors Received		Party 1	Bal From Last Month		5200
5
6	NOTE : ALL THE COLUMNS CAN AND WILL HAVE BLANKS
7
8
9
10
April

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A5,A9:A20	Expression	=AND(NOT(ISBLANK(A2)),NOT(ISNUMBER(A2)))	text	NO

I have a separate sheet for every month in the above mentioned format. Apart from this I have a separate sheet named Transfer In Which Cell B2 carries information of From Date and Cell B3 carries Information Regarding To Date. With These two Dates being the main Criteria I want the following Columns from the month Sheets
1. Date
2. Item Name
3.Weight

These three columns should be copied to a different workbook if They Satisfy the DATE CRITERIA from Sheet named TRANSFER and COLUMN C { CATEGORY } is "S SALES"

Assume the destination Workbook as Stock Trial. It will be in the same destination as the source File.
Details of Destination Workbook
1. Worksheet Name : Data Sheet
2.Date should be fed in Column B
3.Item name in Column A
4.Weight in Column D

Thanks a lot for your help. Hope i was clear.

 

[Haree]

Any lead or Ideas please ?