Requirement: I have an excel and I want to copy the particular items from the excel and paste into separate excel. I have attached the excel herewith.
Query 1: Excel have the value of “Designation wise report”, In this excel it is in 48th row I want to copy that from 51st row which has month values until Total Value which means 57th row. This 48th row and 57th row will be dynamic always for different excel reports. The row number gets changed always
FYI, Always all the excel reports have Designation wise report and after 3 column only “month” values will come but here i want to copy until “total value” in excel. Please let me know how to achieve this.
Query 2: Once copied into separate excel,I want to ignore the zero and only the total value which is not zero only should be there.Please let me know how to achieve this.
This is prioirty.It will be helpful if someone can share the ideas/ xaml file with this implementation ASAP.
Test Report.xls (54 KB)