Ask Your Question
0

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
0

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

Libreaccount gravatar image

Superstar. Thanks a lot.

edit flag offensive delete link more

Comments

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
0

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

=VLOOKUP(A2;$Items.A:C;3;0)

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

   =SUMIFS($Items.C:C;$Items.A:A;A2)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 29 times

Last updated: Feb 15