Hi,
Could someone please assist with the following:
- Attached file has 2 sheets
- Sheet1 (cities) has the list of cities and states they belong to.
- Sheet2 (Criteria) needs to be populated for each city with values from the preceding row repeated and the one value (for state) being picked up from the first sheet (Cities).
- New rows should be inserted after the last row containing data (next empty row).
- Before the rows are inserted, Value in Colname10 should be emptied.
- The above to be achieved with the help of a button. A yes or no popup should also be displayed before the rows are inserted.
Thank you, Nick