Hi Guys
i have no <acronym title="visual basic for applications">VBA</acronym> 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 <acronym title="visual basic for applications">VBA</acronym> 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
(ive attached a link to the file to give a broader understanding of my requirements)
copy all content of one sheet into another sheet in excel
March 21st, 2015 5:55am
If you're using Office professional or Office 365/Power BI, you could use Power Query, which is just made for tasks like this:
Free Windows Admin Tool Kit Click here and download it now
March 21st, 2015 6:10am