Hi all i want only selected box with account stating with 045 and i have to write it into other sheet with the value which is showed in colour with column name foregin account and other column name suspense account i want only these two part
Can you be more clear
send me expected output and input
the sceenshot shot which i have posted na in that i have highlighted account which is have 8 digit and now i have to take only those account and there is other column which has account num 0450001001so i have to write only colured with account starting with only 045 into other sheet
Use filter datatable and put condition starts with 045 and get the dt. Do you want only those 2 fields ?
ExcelHelp.zip (33.8 KB)
this will work out for you .