How to automatically move data from one sheet to another

[gordons]

Dear Chandoo,

I have a problem to look up data from one table and move the data to another sheet with the value i want. I don't know how to describe, i hope the attachment file can describe it.

Very thank if you can help me, i'm sorry for my bad english.

 

[Somendra Misra]

Hi,

See this file.

Regards,

 

[gordons]

Dear Somendra,

Thanks for your response. I got this for 1st row, but when i copy it down, there are #Num Error with message "Circular reference", do you have any idea?

 

[Somendra Misra]

@gordons

The formula is an array formula, so must be entered with Ctrl+Shift+Enter in first cell and than copied down.

You must study the range used in the formula and than adjust in your file.

Or upload your file.

Regards,

 

[gordons]

@Somendra

I got this, I've try this, but still error. Can you please help me?Here is the data, formula is in sheet "Resume" and the data is in sheet "Production"

 

[Somendra Misra]

@gordons

See this file.

Regards,

 

[gordons]

@Somendra

The table only show 13 list even the data counted as 14, the 14th is error, do you know why?

 

[Somendra Misra]

Which case are you talking about?

Regards,

 

[gordons]

@Somendra

In the last file you uploaded.

 

[Somendra Misra]

No my question is regarding what name and what number?

Regards,

 

[gordons]

Oh Sorry, i mean the "stockpile SPV" on sheet production doesn't shown up.

 

[Somendra Misra]

I will again ask for what Kompetensi & what level?

Regards,

 

[gordons]

Oh Ok, sorry for my mistake. Please look at the file, on sheet "Resume" it count 14, but only show 13 on list.

 

[Somendra Misra]

You have not dragged the formula correctly. See this file.

Regards,