We want to develop an excel template to import data from a CSV file.
The CSV file has much more data than we want to see, so we'd like to take only the data we want from that file and have it populate automatically into our Excel template, which is more simple and easy to read.
Ideally, our template will have the info included in our sample file: product name, cost, net price, tax, gross price, COGS% and GM%.
We would like to input just this information from the CSV file that we download regularly.
We would also like to have the COGS% cell text in RED if the % is 30% or greater.
We have created a sample template which is very basic, but would welcome a cleaner, more organized version.
22 freelancer đang chào giá trung bình $105 cho công việc này
Hi, I have undertaken similar Excel macro projects earlier on freelancer and would be happy to take on this project. Shall make a user friendly interface for selecting the input csv file. Regards, Arul
hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.
Hi. I can develop a nice solution for you for this. I have had to build similar arrangements and can easily solve this for you in an efficient way.