Hi Guys
i have no VBA programming knowledge at all so im hoping one of you can assist me. i have about 12 suppliers for my online store, every week they send me price lists for the various items they sell. i would like to create a master products list file with basically all my suppliers products in individual tabs in excel. so for instance, tab 1 will be supplier 1 and tab 2 supplier 2 and so forth. obviously the columns in each tab will be amended to be the same so column A will be ID, column B will be product code, column C will be name, etc. i would like a master sheet within this file namely Master that will basically extract all the rows from the various tabs and paste them into the master sheet. can this be done? also say for instance 2 of my suppliers sell the same product with the same product code, can the VBA pick out which one of the 2 product codes has the lower price and paste that into the master sheet so that i can avoid having duplicate items.
Thanks guys, i know this is a challenging one (well to me it is) but i know you guys have super power programming knowledge
i have no VBA programming knowledge at all so im hoping one of you can assist me. i have about 12 suppliers for my online store, every week they send me price lists for the various items they sell. i would like to create a master products list file with basically all my suppliers products in individual tabs in excel. so for instance, tab 1 will be supplier 1 and tab 2 supplier 2 and so forth. obviously the columns in each tab will be amended to be the same so column A will be ID, column B will be product code, column C will be name, etc. i would like a master sheet within this file namely Master that will basically extract all the rows from the various tabs and paste them into the master sheet. can this be done? also say for instance 2 of my suppliers sell the same product with the same product code, can the VBA pick out which one of the 2 product codes has the lower price and paste that into the master sheet so that i can avoid having duplicate items.
Thanks guys, i know this is a challenging one (well to me it is) but i know you guys have super power programming knowledge