• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to automatically move data from one sheet to another

gordons

New Member
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.
 

Attachments

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?
 
@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,
 
@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"
 

Attachments

Back
Top