Report

Macro that will allow tab 1 's information to be copy to tab 2 [Solved]

Ask a question HappyPerson 2Posts Thursday March 31, 2016Registration date April 25, 2016 Last seen - Last answered on May 28, 2016 10:00PM
Hello,
Please help.
My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, contract amount and....... Tab 2 is to keep track of change order. I don't like to re-type the project number, project name, customer name and contract amount to tab 2 when I enter a change order number for a contract that is already in tab 1.

Is any way macro that will allow tab 1 's information to be copy to tab 2 when I enter the contract number to tab 2?

Thank you so much.
See more 
Helpful
+0
moins plus
Hi HappyPerson,

Have you tried VLOOKUP?

When Tab 1 looks like:


And you make a change to project number 2, then Tab 2 will look like:


Then formula in B2 is:
=VLOOKUP($A$2,'Tab 1'!$A$2:$D$5,2,0)
in C2:
=VLOOKUP($A$2,'Tab 1'!$A$2:$D$5,3,0)
and in D2:
=VLOOKUP($A$2,'Tab 1'!$A$2:$D$5,4,0)


Best regards,
Trowa
HappyPerson- May 28, 2016 10:00PM
Thank you so much.
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!