Doesnt necessarily have to be to word, excel could do it i guess.
The problem is that at the moment it it on the form;
company1, material1, price1, material2, price2
company2, material1, price1
company3, material1, price1, material2, price2, material3, price3
etc
etc
I could print that out but that'll quickly go horizontally off the page, even in landscape, so the easiest way to list it would be;
Company1, Material1, Price1
Company1, Material2, Price2
Company2, Material1, Price1
Company3, Material1, Price1
Company3, Material2, Price2
Company3, Material2, Price3
which could then go in to 2 columns and be printed on the minimum of paper (the last one was 16 pages. I want it for quick reference of monthly prices when out of the office, rather than having to hunt through an excel document on my phone.
I could manually link everything in excel but that leaves another problem, every month a load more get added and sorted into alphabetical order, but linking them fixes the cells so i would have to redo it every time.
I assumed there could be a way to set it all up using a csv file?
|