It actually filter using a text box appearing after clicking on the button instead of dropdown box (inbuilt filter) and check box for filtering the data,
I have two files one is working and another one is in which i want to do the same.
i filter the data using some vba code(someone did it for...
i have too many customers and i filter them by checking the boxes(when we filter data) but now since they are now too many i want to make it easy and filter them by just tying thier name in some ind of search box or some kind of hyperlink or anything which can filter data easily
i have to autosum a column but it has formulas in it
=INDEX(Sheet2!L5:L24,MATCH(nuru!B5,Sheet2!M5:M24,0),0)
i want autosum it i get error #N/A how can i get autosum???
i want to fill some data to be filled automatically but i am not getting the formula. here is what i want...
when i write customaer name in sold field (b3) all the entry should automatically be filled (g3 h3 i3 j3)in his creadit account from (a3 c3 d3 e3).
somehow i managed to get it...
Hi,
i want to fill (or copy) some specific data to be entered in particular cell for example....
(i am using 2007)
Whenever i bought an item i put date, price, name of the person, quality ,etc.and a specific or unique item number (can be x99,a33,any random thing).
and when i sell it i type...