Hello,
I am trying to send up a template to record sales data. Here is my sample
data:

Worksheet 2
A B
1 Item Price
2 Ipod ='worksheet1'A1
3 Gameboy ='worksheet2'A2
4

What function can I use so that when I type an item name in A4, Excel will
auto insert a row below and auto copy the formula from B3 to B4?

Any help appreciated.

Thanks,
Wendy