Please help : in this sheet1, the highlighted cells are with alpha numeric pattern, as it required to be in that order.
On the next tab, in sheet 2 , i have one table shows the name, date and numeric value that needed to be filled in from sheet1.
I want whenever i enter any of this alpha-numeric value in any of the cells in sheet1, it should auto populate in sheet2 against with respective name ,date and the numeric value only. That is, instead of 1-16 with n or m , i need 1-16 as numeric only .I hope ,it reaches. I am using Microsoft 365 MSO -64bit version. Thanks
On the next tab, in sheet 2 , i have one table shows the name, date and numeric value that needed to be filled in from sheet1.
I want whenever i enter any of this alpha-numeric value in any of the cells in sheet1, it should auto populate in sheet2 against with respective name ,date and the numeric value only. That is, instead of 1-16 with n or m , i need 1-16 as numeric only .I hope ,it reaches. I am using Microsoft 365 MSO -64bit version. Thanks