Lifespeachy
08-04-2020, 07:35 PM
Hi all,
I am doing a quote register for work and I'm a little stuck on some VBA coding.
I have in this example 2 sheets (actual quote database has many more but for simplicity I've omitted most), an edit quote sheet (Sheet1) which calls up the quote details to allow for editing and then saving back to the database and a quote status sheet (Sheet2), which has a list of all the quotes and their revisions.
What I'm wanting to do is look up the quote and revision # on sheet1 cells L1 & H1, find the match in the list on sheet2 and change the status to "Rev'd"
I've had a looked around for similar code to play around with but all I can find is code that uses Index Match for the copy criteria not the paste criteria.
I have attached a sample of the data base for hopefully more clarification of what I'm trying to achieve.
Thanks for an help that can be provided.
I am doing a quote register for work and I'm a little stuck on some VBA coding.
I have in this example 2 sheets (actual quote database has many more but for simplicity I've omitted most), an edit quote sheet (Sheet1) which calls up the quote details to allow for editing and then saving back to the database and a quote status sheet (Sheet2), which has a list of all the quotes and their revisions.
What I'm wanting to do is look up the quote and revision # on sheet1 cells L1 & H1, find the match in the list on sheet2 and change the status to "Rev'd"
I've had a looked around for similar code to play around with but all I can find is code that uses Index Match for the copy criteria not the paste criteria.
I have attached a sample of the data base for hopefully more clarification of what I'm trying to achieve.
Thanks for an help that can be provided.