Transfer

[KlausW]

Hi every one

Someone who can help.

I have some sheets with different item I buy, under categories. Ex. Eks. Drink, Frugt, Kød, etc. (Danish)

Now I would like Excel to be able to transfer the item I would like to order to a sheet called " Bestilling ". (Danish)

So when, for example, I order orange juice in sheets "Drink" and order bananas, grapes and apples in sheets "Frugt", and order rabbit, beef tenderloin, chicken, in sheets "Kød". Should these items be transferred with item no. item name, quantity and price. Columns A, B, C and I
Some that can help.

The inserted item must first be inserted from cell A9 and down after.

All help will be appreciated

Best regards Klaus

 

[KlausW]

Hi every one

Someone who can help.

I have some sheets with different item I buy, under categories. Ex. Eks. Drink, Frugt, Kød, etc. (Danish)

Now I would like Excel to be able to transfer the item I would like to order to a sheet called " Bestilling ". (Danish)

So when, for example, I order orange juice in sheets "Drink" and order bananas, grapes and apples in sheets "Frugt", and order rabbit, beef tenderloin, chicken, in sheets "Kød". Should these items be transferred with item no. item name, quantity and price. Columns A, B, C and I
Some that can help.

The inserted item must first be inserted from cell A9 and down after.

All help will be appreciated

Best regards Klaus

I close this Questions, and will return when I got a solution KW