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