Tag Info

Hot answers tagged


Personally I like pricegrabber and nextag. http://www.pricegrabber.com http://www.nextag.com/


There are cleverer ways of doing this but the conventional solution is to add a 'helper' column: Insert a column at the extreme left of PRODUCTS and in A1: =B1&"|"&C1 and copy down to suit. In INVENTORY in C2 insert: =VLOOKUP(A2&"|"&B2,Products!A:D,4,0) and copy down to suit.


I made a little script for you that will do just this. You currently have to paste the html for the tables in question into the HTML window, but after you do that just hit Run and you will see the combined tables. If you would like something more advanced, please let me know.


I would try just using plain old microsoft word, and zoom out to a point where you can see both copies on the same screen. Then they can be printed on different sheets, and comments can be added as needed on microsoft word. If you need to use an online tool then there is google docs word, but then you can't see both at once.

Only top voted, non community-wiki answers of a minimum length are eligible