I'm assuming you already know to create a userform with the button. In order to get the "constumer number" and "request number", we need to know where those are generating in your document in order to define the range. Does the "constumer number" and "request number" always generate in the same spot?