Hi i am trying to creat a datavalidation in VBA.
i am creating 2 new columns in my reference spreadsheet there i need the data from. (Sheet2) Columns unknow --> rows should be excel down (i guess name magement would be recommended)
i would like the dropdown list to be danymic since more data could be added on later.
the datavalidation or dropdown list should be shown on my front page (Sheet1)
Any suggestions and/or help would be highly appriciated.
i am creating 2 new columns in my reference spreadsheet there i need the data from. (Sheet2) Columns unknow --> rows should be excel down (i guess name magement would be recommended)
i would like the dropdown list to be danymic since more data could be added on later.
the datavalidation or dropdown list should be shown on my front page (Sheet1)
Any suggestions and/or help would be highly appriciated.