I am attempting to extract unique values from (3) different worksheets from (4) ranges using Excel VBA so I can then use a dynamic range to populate a combobox in a userform.
Sheet 1 (Range F1 through last row)
Sheet 1 (Range G1 through last row)
Sheet 2 (Range A2 through last row)
Sheet 3 (Range A2 through last row)
I am attempting to copy and paste in an Admin Sheet that has my dynamic ranges. Once I pull Sheet 1 (F1 through last row), I want to paste it in the Admin sheet. Next, I want to pull Sheet 1 (Range G1 through last row) and paste it underneath my data I just pasted in the Admin sheet.
I want to do this for all four ranges without deleting previous data. Can someone point me in the right direction?
Sheet 1 (Range F1 through last row)
Sheet 1 (Range G1 through last row)
Sheet 2 (Range A2 through last row)
Sheet 3 (Range A2 through last row)
I am attempting to copy and paste in an Admin Sheet that has my dynamic ranges. Once I pull Sheet 1 (F1 through last row), I want to paste it in the Admin sheet. Next, I want to pull Sheet 1 (Range G1 through last row) and paste it underneath my data I just pasted in the Admin sheet.
I want to do this for all four ranges without deleting previous data. Can someone point me in the right direction?