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!
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!
