Hello
Source Workbook : "Daily Sheet"
Source Location : Desktop
Destination Workbook : Return Items
Destination Location : D Drive
I have 12 sheets in the source workbook, one for each month
In each worksheet i have the following data
Column H: Date
Column I : Category
Column J : Party Name
Column K : Particulars
Column L: Bill Value
Column M: Quantity
Column N : Return Qty
If Column I : Category is "Returned Items" (I have a data validation) , i want that particular rows items from column H to Column N copied to the new workbook
I want this for all the worksheets in the source sheet
All the data can be together in the destination workbook
Source Workbook : "Daily Sheet"
Source Location : Desktop
Destination Workbook : Return Items
Destination Location : D Drive
I have 12 sheets in the source workbook, one for each month
In each worksheet i have the following data
Column H: Date
Column I : Category
Column J : Party Name
Column K : Particulars
Column L: Bill Value
Column M: Quantity
Column N : Return Qty
If Column I : Category is "Returned Items" (I have a data validation) , i want that particular rows items from column H to Column N copied to the new workbook
I want this for all the worksheets in the source sheet
All the data can be together in the destination workbook