Search results

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)

hi, i have some data containing team A, team B, with some employee IDs. and dates among data. i need to create Staked column date wise between team A & team B. for more easy to under stand i uploaded a fine with example (i wanted).

thanks Narayan but it will not help me as i need to show in one glance as print out ...

I have 2 dates ( start date ) (end date) and i need to show chart that from a activity start from start date to end date .. there are 4,5 actives but i need to show with gap like : activities S.dated E.date. activity 1 ------------------- activity 2...

thanks NARAYANK991 :

i have a line chart containing 30 months (m1 ---- m30) like m1 m2 m3 m4 ----------- m30 a 10 20 25 30 ........... 100 b 12 15 c 10 12 when i create chart is seem se to too long but what i need is that i want to split this chart after 13 month but see unto 30 months. like ( m1 m2 m3...

thanks naryan it works... so nice of u ... please i have one more post and please also solve that problem.. thanks and regards

i have thousand of data in Column A and Column B and i have simple formula of in Column C which is of minus a- b, but i have a question is that i write a formula in Column C (a1-b1) and then i copy formula and past in all the other upto for example (A100-b100) but what i want is that if i copy...

lets suppose i have 2 column "A" and "B" and i want to add only those value from Column "B" which has text. A B 12 q 14 15 a 15 e 15

i have a excel sheet containing more than 27 values to be sum. i have to use subtotal formula. but after 27 values subtotal formula does not sum more value. how can i solve this problem?

hi Hue, thats great.... now its work as per my requirement .... thanks Hui,, wish you best of luck