Input data in one cell, copies row details to another tab

Not sure how i can do this but basically i have a spreadsheet with two tabs, quotes and jobs

Firstly i will put information into the quotes tab when a job has been quoted. If we win the quote i want to put "yes" in the "job won" column and this will in turn copy over the relevant info fromthe "quotes" tab to the "jobs" tab. the info i need to be copied over has been highlighted in the attached spreadsheet in the "quotes" tab

As this info is copied across to the "jobs" tab, it will be given a Job Number. i would like this job number to be copied over to the "quotes" tab

on the attached spreadsheet ive manually written in the data that i require, i just want it to be automatic if possible.

Hope ive explained well enough and it can be done!

Do you manually enter the Job Number Given (column I) when you enter Yes into column J ? (You haven't for row 3).

Pete

No i want this to be automatic, so when Yes is put in the job won, the details go over to the jobs tabs and whatever the next job number is it assigns that job number. Bear in mind that every quote will not turn into a job

It would actually be easier for you to manually enter the Job Number - I think you might end up with a circular reference otherwise. So, you get confirmation that a quote has been accepted, and then you go to the quotes sheet and allocate the next available job number (no need for the "Yes" column - if there is a Job Number present then that serves the same purpose).

Anyway, I'll take a look at it and post back later.

Pete

Ah yes i understand, that sounds good. i'll await your next post. thanks!

In the attached file I've inserted a new column A in the Jobs sheet, with this formula in A2:

=IFERROR(MATCH(B2,Quotes!I:I,0),"")

This gives the row number where that Job number can be found. Then I have this formula in C2:

=IF($A2="","",INDEX(Quotes!B:B,$A2))

which will return the data from column B of the Quotes sheet on the row given in A2. When this is copied across it will get the data from column C, then D, and so on. Then these formulae can be copied down. Column A can be hidden if you don't want to see it on the sheet.

You will see in the Quotes sheet that I've made up some more quotation data. I imagine this is likely to be in date order, although if you get the go-ahead for a job that order will be different - I've tried to simulate this in the job numbers used column. Note that I've used cell J1 to give you the next job number in sequence (currently J5), and once you allocate this the data will automatically appear on the Jobs sheet and the next in sequence will appear in J1.

Hope this helps.

Pete

Hi Pete

This is great thanks very much. appreciate you spending the time on it for me!