Hi Friends,
I need to copy the transactions from the sheet “data” for the “products” mentioned in the sheet “summary” and for the date range given in the sheet “summary” in to the new sheet with the name of Sequence number given in the summary sheet(Ex.Sequence01).
Also relevant data of fields like Price, % and Unit details to be copied to “Sequence01” sheet.
I have done manually for your reference. Kindly help to get the Macro to get Sequence sheet with the information from the sheet Summary and Data.
Thank you so much,
Regards,
Prabhu
I need to copy the transactions from the sheet “data” for the “products” mentioned in the sheet “summary” and for the date range given in the sheet “summary” in to the new sheet with the name of Sequence number given in the summary sheet(Ex.Sequence01).
Also relevant data of fields like Price, % and Unit details to be copied to “Sequence01” sheet.
I have done manually for your reference. Kindly help to get the Macro to get Sequence sheet with the information from the sheet Summary and Data.
Thank you so much,
Regards,
Prabhu