Hi there,

First of all I would like to thank anyone who would take his time to read and try to solve my problem. Here it is:

I have table with names in column A and prices in column B in one worksheet. I would like to use that data in another worksheet of the same excel file when I put in names in column C of that worksheet. Lets say worksheet 1 with the table names and prices is: "repair prices" and
worksheet 2 name is: "service invoice".

Additional question for extra 100 karma points is: how to set excel autofil names from repair prices worksheet when I start entering them in service invoice?

Thanks!