How to auto populate a worksheet using a reference cell

Roseftd

New Member
Joined
Jan 18, 2012
Messages
1
I have two spreadsheets, one which contains job data, and the other that is set up as a job sheet form. Currently I link each cell of the form to the appropriate cells in the data sheet, but figure someone here may know a way that I can populate the needed data from the data sheet into the job sheet somehow.


What I've tried so far is using the IF function: =IF(A1='Data Sheet'!B1,'Data Sheet'!B2,0)


B1 in the data sheet is the job#, which I want to use as a reference to populate the job data to other cells in the job sheet.


So if A1 in my job sheet (in other words I type in the job#)= B1 in my data sheet (which is the job#), then the customer's name (which is in Data Sheet B2) will appear in the cell containing this formula...I do this in each cell where I want corresponding data linked, which works fine individually, but does not seem to work for a range of 301 rows containing 301 jobs.


Is there a way to do this without having 301 job sheets, but by having just one template job sheet that will populate from the data that pertains to a specific job number?

Thanks so much to anyone who can help me with this issue and make my live so much easier!
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,127,484
Messages
5,625,028
Members
416,065
Latest member
meiravmeron

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top