Forum Discussion
Converting data for multiple sequential numbers sheets
Hi everyone,
I was wondering if anyone can help?!
I have a quote register sheet in excel with several information fields with a quote number that runs sequentially - I also have a job number sheet that I use when the quotes are accepted and become jobs - this sheet also has the job number running sequentially.
How to I convert or transfer the data from the quote register fields into the job register sheet automatically selecting the next sequential job number without me having to retype all the data or copy and paste every time??
Your suggestions/input will be very much appreciated
Thanks
Rory
7 Replies
You may use XLOOKUP or similar function, but that's better to illustrate on concrete sample.
Morning Sergei - thanks for your reply.
I have attached an example of my sheet - dont know how else to provide a concrete example.
Would like to hear your comments
Best
Rory
I did that for the client name, not sure what else shall be taken
Formula is
=IFNA(INDEX( 'QUOTE REG'!$F$15:INDEX('QUOTE REG'!$F$15:$F$100,COUNTA('QUOTE REG'!$D$15:'QUOTE REG'!$D$100)), MATCH($B9,'QUOTE REG'!$D$15:INDEX('QUOTE REG'!$D$15:'QUOTE REG'!$D$100,COUNTA('QUOTE REG'!$D$15:'QUOTE REG'!$D$100)),0 ) ),"")
