Going to try to make this as brief and simple as possible.
My workbook has 3 worksheets, each sheet's data starts at A4, columns are A:F.
I'm trying to make my macro read Sheet1!A4:F4 as a single value, then check if it exists in either Sheet2 or Sheet3 (also A:F, not in a single cell). Essentially, I'm trying to get this:
<tbody>
</tbody>
To read the value of A:F as a single value, something like: "Timmy Thomas Client Single Phone 831-555-4321".
If it's not on either sheet, copy A4:F4 then paste it in the next available row on Sheet2. If Sheet1!A4:F4 is found in either Sheet2 or Sheet3, go to Sheet1!A5:F5, and so on until the last row of the data in Sheet1. The last row on each sheet will always be different, not at a predetermined row.
I'm sure this could be accomplished without macros, but this is one part of a larger macro. I appreciate any help you can offer! Thanks!
My workbook has 3 worksheets, each sheet's data starts at A4, columns are A:F.
I'm trying to make my macro read Sheet1!A4:F4 as a single value, then check if it exists in either Sheet2 or Sheet3 (also A:F, not in a single cell). Essentially, I'm trying to get this:
A | B | C | D | E | F |
Timmy | Thomas | Client | Single | Phone | 831-555-4321 |
<tbody>
</tbody>
To read the value of A:F as a single value, something like: "Timmy Thomas Client Single Phone 831-555-4321".
If it's not on either sheet, copy A4:F4 then paste it in the next available row on Sheet2. If Sheet1!A4:F4 is found in either Sheet2 or Sheet3, go to Sheet1!A5:F5, and so on until the last row of the data in Sheet1. The last row on each sheet will always be different, not at a predetermined row.
I'm sure this could be accomplished without macros, but this is one part of a larger macro. I appreciate any help you can offer! Thanks!