Recent content by imran khan

Hi, I tried alot but could not do the following: i have data in the range M11:O1844. I want that by a click of a button, all the data in the range M11:O1844 is copied and paste special in the range G11:I1844. How can this be acieive by VBA. Please define steps also to run as whenever i...

Noted....Thanks

Thank you Asheesh, bingo it works. Thank you so much.

Hi, i am trying to add values in a row given that when i enter a week number it sum up all the values from the start uptill that week. e.g in the below data, i like to sum uptil 201425 and next week when i enter 201426 it should sum all from 201423 till 201426 and so on each week. i have...

thanks alot Hui,

thanks alot .. misra,

Projects 201432 201433 weeks 201434 201435 201436 201437 50000 10 69 45 80 45 45 50001 52 85 80 52 80 80 61003 58 78 45 45 45 45 61003 78 50 68 78 68 68 50000 41 20 78 15 78 78 68798 45 15 18 27 18 18 i need a sum formula wich sum...

perfect :) thanks faseeh............ may ALLAH bless you

Dear Faseeh, that formula i know, but on row one contain " in - out" and row two contain "values" i need to count values how are in front of "in"

in out in out in out in out 1 10 52 12 0 5 0 how can i count the "in" values"

hi, how do i convert numeric to alphabetic words ( like , if i write 50 it give answer "fifty")

dear somendra Misra / GFC, thanks for such a beautiful work, appropriated your replies.. hope we will be get i touch again and again... and will learn alot from you guys .. :)

hi, GFC, perfect .. it works . .thanks

HI BBD, i need to count PO values based on RO values .. count only those PO values how has in front RO values .

i have to column named "PO" and "RO". i have to count the values of PO but condition is like : PO RO 1 a 2 b 3 c if RO has all values, count PO values (ans "3") and if PO RO 1 2 b 3 c if RO has any empty value, count PO value only for RO values has (ans 2)