I would like to auto fill a couple of fields based on criteria being met. Found some vba code but not quite what I was looking for. I would like to auto fill column A with a number (in sequential order) if column C is populated with text. And then I would like to auto populate column H with the C4:G6 (Address, Contact Person, Contact details: phone and email) each on a separate line within the same cell. Is this possible?
Attached is the workbook.