OK Sorry!! start again, attached is the file with the columns A & B that I extract from the system and C, D & E are what i would like to see. I have started filling the information in but it takes a long time manually so hopefully there is enough for you to understand what i am trying to achieve. Column C I am using as the identifier (the type of film) so i can then look up the cost for that type of film and multiply it by the width, length to check the cost of each roll of film. The rest of the description is not important. thank you for your efforts.![]()




Reply With Quote

Bookmarks