Ask Your Question

how to transfer data to another sheet

asked 2019-02-15 21:58:54 +0100

Libreaccount gravatar image

updated 2019-02-15 21:59:28 +0100

If you look in the attachment I have two columns of data in two sheets. Both sheets labelled "Items" and "Market items" within each sheet have TYPEID and TYPENAME. I would like to move volume over to Market items.

The first sheet holds all the items in existence in this on line game (eve-online) whilst the second sheet holds only the data that can be sold in market. I can't just cut and paste volume over.

Any help would be great.C:\fakepath\help.ods

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-02-15 22:42:01 +0100

Libreaccount gravatar image

Superstar. Thanks a lot.

edit flag offensive delete link more


Please use comment, this in not an answer. . if the answer solves the question click ✔.

m.a.riosv gravatar imagem.a.riosv ( 2019-02-16 22:57:57 +0100 )edit

i can't find the tick. But it is resolved

Libreaccount gravatar imageLibreaccount ( 2019-02-17 01:11:54 +0100 )edit

< 0 > ✔ .

m.a.riosv gravatar imagem.a.riosv ( 2019-02-17 10:01:16 +0100 )edit

answered 2019-02-15 22:30:29 +0100

m.a.riosv gravatar image

updated 2019-02-15 22:30:45 +0100

If there are not duplicates in Items sheet the you can use a function like


If there are several with the same TYPEID then a function like

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-15 21:58:54 +0100

Seen: 29 times

Last updated: Feb 15