I need a program that edits an excel file. Based upon The fields that are already in the excel sheet i need a program that can add/modify/remove fields.
Each column in the excel worksheet has a header describing the values in that column. The column headers are Model, Description, Attribute options, Designer....etc
I need this program to be able modify the fields in the excel sheet of all the products attributed to a particular Designer or individually just based upon the model number.
I dont know if anyone is familiar with the easy populate contribution for oscommerce, but it lets me create an excel sheet of my products and upload it to my store. I just need an easier interface to that excel sheet since i have so many products with so many attributes it gets annoying to modify each field and messy to look at.
See my problem is even though i have so many products they really are seperated by 8 or 9 different designers and most of the time when i make a change to one product i want to make the same change to every other product assocatied with the same designer.
Anyways i need this to be a vb program or some program that i can execute and i also need the source so i can modify it later on.