V
Vivek
Hi,
I have two excel sheets, A.xls and B.xls
I have lots of data in A.xls and need to consolidate them in B.xls.
What i want:
1. Get the file name from a column given in B.xls (cause the 1st excel name
can be anything)
2. Once this is done, next i need to get a count from a range depending on
the condition, say like i have columns M:U filled with data (value < 100) and
i need to get the count if data is between 60 and 100. Just count.
How do i do this? And more complex calculations will follow depending on the
success of this.
What i like to do is to select the filename and then proceed.
Can someone help. Thanks..
I have two excel sheets, A.xls and B.xls
I have lots of data in A.xls and need to consolidate them in B.xls.
What i want:
1. Get the file name from a column given in B.xls (cause the 1st excel name
can be anything)
2. Once this is done, next i need to get a count from a range depending on
the condition, say like i have columns M:U filled with data (value < 100) and
i need to get the count if data is between 60 and 100. Just count.
How do i do this? And more complex calculations will follow depending on the
success of this.
What i like to do is to select the filename and then proceed.
Can someone help. Thanks..