Script for macro button to transpose and paste data from selected row to selected cells

Question

I need to come up with the script for an import button on my google spreadsheet, but I'm a little out of my depth.

I have one Spreadsheet with two Sheets:

• Purchase Order template (Sheet2 = 発注書)
• Product Requirements data (Sheet3 = 朝食)

The goal is to populate the Purchase Order (Sheet2) from a row of Product Requirements data on Sheet3. The Product Requirements data includes a Purchase Order value.

What I'm trying to achieve is to import data from the second to the third tab in the following way:

Process:

• Enter a Purchase Order number in Cell B2, Sheet2.
• Manually start the macro (by click the "import" button) to copy data from Sheet3 to Sheet2.
• Find the row on Sheet3 where the value in Column A equals value entered into the Purchase Order Cell B2. Then, copy values from that row on Sheet3 to the Purchase Order (Sheet2)
  • Column B - copy to Sheet2, Cell D16
  • Column C - copy to Sheet2, Cell C15
  • Column D - Copy to Sheet2, Cell D20
  • Column E - copy to Sheet2, Cell D21
  • Column G - copy to Sheet2, Cell D14

*Other columns do not need to be imported.

Basically, depending on the value I insert 発注書!B2 (Sheet2, B2), I can import different data from the 朝食　tab row. I apologize if it's not clear enough. I tried modifying the script based on an existing excel doc which used the formula but I failed.

This is a sample spreadsheet to illustrate what I'm trying to do: Sheet2 (朝食), and below Sheet3 (発注書）

Answer 1

Using VLOOKUP

• Enter the purchase Order Number in Cell B2

• Use this formula in the appropriate cell

=vlookup($B$2,sheet3!$A$3:$I$199,2,0)

• $B$2 - absolute reference to the Purchase order number
• sheet3!$A$3:$I$199- link to data on sheet3. The extra rows will allow for expansion of the data on Sheet3
• 2 - index = 2 (= Column B)
• `0' - looks for an exact match

The same formula can be used in many cells, just change the index number to return the appropriate column value from Sheet3.

Sheet2

---

Sheet3