Maria Clara
New Member
Hello All, hope you can help me again on this one 
I have an spreadsheet with information from two different sources split in two tabs and I want to put all of them in one single tab for me to be able to calculate the lowest price properly.
First tab - 'Automatic' - is the format I receive from my system and second tab - 'Manual' is the format I get the data manually.
Basically what I want to do is to put Suppliers & Prices from tab Manual on tab Automatic (as it is highlighted in red on attached file), always considering that on both tabs I can have several numbers of suppliers (columns) and products (rows).
I've attached the file below for you reference.
http://www.sendspace.com/file/6eq0x0
Thank you again!
I have an spreadsheet with information from two different sources split in two tabs and I want to put all of them in one single tab for me to be able to calculate the lowest price properly.
First tab - 'Automatic' - is the format I receive from my system and second tab - 'Manual' is the format I get the data manually.
Basically what I want to do is to put Suppliers & Prices from tab Manual on tab Automatic (as it is highlighted in red on attached file), always considering that on both tabs I can have several numbers of suppliers (columns) and products (rows).
I've attached the file below for you reference.
http://www.sendspace.com/file/6eq0x0
Thank you again!