Question:
I have written a short code to call a macro to run it on a few worksheets one after another. This macro deletes all the blank rows in all the worksheets in which it runs.
Now the problem is that if not all the worksheets contain useful data so I would like to delete a few [...]
Question:
Hi Experts,
I’m preparing monthly revenue report from different product categories, Sample sheet attached.
A1 to A6 are different sales teams data.
I have to collate the summary sheets with the data from A1 -A6.
In Sheet “Summary” , I have to put values based on differnt ‘Revenue Streams’ by each sales team,
In Sheet”Summary Product” values based on ‘Product [...]
Question:
My query is
Absence Results
50
10
30
40
80
Please find below data need for comapre above data
Range Value
10 10 >=10 and <=20
11 10 >=10 and <=20
20 20 <=20 and >=30
30 30 >=30 and <=40
31 30 >=30 and <=40
40 50 >=40 and <=50
43 50 >=40 and <=50
50 50 >=40 and <=50
100 120 >=60 and <=120
My results should be
Absence Results
50 50
10 10
30 [...]
Question:
I am curious. Is it possible to generate a series of alfa-numeric no series in excel.
Say, every time I want to generate 100 unique alfa-numeric nos and the series will starting from cell A2:A; Next time B2:B..so on..till excel columns ends.
Solution:
Note to self … read note to self!
Chris
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
Sub genStrings()
Const conststrLen As Integer = 6
Const intNoRows [...]