copy all content of one sheet into another sheet in excel

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)

Before

after

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:

https://support.office.com/en-in/article/Introduction-to-Microsoft-Power-Query-for-Excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605

Free Windows Admin Tool Kit Click here and download it now
March 21st, 2015 6:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics