I'm a VBA beginner so please excuse my ignorance.
I am building a purchasing system that can generate orders or requests for quotes.
I would like to write a macro on my "quote entry" sheet that finds a saved quote on the "saved quotes" sheet (by quote#) and places that quote's information back in the "quote entry" sheet.
So, the macro would search for the number placed in the cell, find it in another worksheet, select the corresponding cells (that apply to that quote#), copy them, and paste them back in the entry sheet.
I tried searching the forum, the internet, and to no avail. If you have any insight, please help and thanks for your time.
I am building a purchasing system that can generate orders or requests for quotes.
I would like to write a macro on my "quote entry" sheet that finds a saved quote on the "saved quotes" sheet (by quote#) and places that quote's information back in the "quote entry" sheet.
So, the macro would search for the number placed in the cell, find it in another worksheet, select the corresponding cells (that apply to that quote#), copy them, and paste them back in the entry sheet.
I tried searching the forum, the internet, and to no avail. If you have any insight, please help and thanks for your time.