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 .
prashant1603765
yedukondaluaregala
sharazkm32
ashokkarale
sonaliaggarwal47
Rahul_Rajendran
V_Roboto_V
revathi3
juan_haro
goag2413