I have what I believe to be a complex query which, I hope, someone will be able to help. The purpose of my exercise is to select data from a particular column to a different sheet. An example is listed below:
Code Units Total
A05251
-pur 16 2005156
-rem 6 810595
Total 22 2815751
A03626
-pur 41 6219082
-rem 2 212250
Total 43 6431332
A02996
-pur 2 182000
Total 2 182000
A09412
-rem 2 190000
Total 2 190000
What happens however is that the results displayed are not consistent. Today I may have "pur" and "rem" under a particular code however tomorrow that may not be the case and I will have only one of the two or none. In this collumn there are hundreds of codes which start with a diferent letter however I am only interested in the codes starting with "A" and the respective pur and rem results. What I am looking into doing is listing the information in a different sheet, preferably by having all the possible "A" codes with the resptive "pur " and "rem" and total for each "A" code and then fill it in daily with whatever comes from the sheet where the above info is.
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com,http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
