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...

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...

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...

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")

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).

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...

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...

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?

lets suppose we have a series of values in a column ( 15, 20, 14, 18, 21....) so i want to count the value which are greater than 15 and less than 20 from the series in excel 2003. waiting for reply Imran Khan