HI Chaya,
PFA
see if it helps,
On Tue, May 21, 2013 at 9:42 AM, Chaya wrote:
> Dear Experts,
>
> Please help in doing data sub validation. Please see the attached
> sample.
>
> What ever I select in the Category No column, the same corresponding item
> should be drop down in H Column.
>
>
Waiting for Reply
On Mon, May 20, 2013 at 3:16 PM, Shrinivas Shevde wrote:
>
> Dear All
>
> Please find atached excel sheet contain data .
> I want to make a Dynamic graph(as far a possible without macro) for users
> as the users is of top level I dont want to show any data.I want to show
> only
Dear Priti,
As always you did the great logical solution. Infact i really don't
understand the formula used for data validation in Level2 (very huge long),
but i have got some more ideas on this.
Thanks a lot.
Now i have small help modification in the attached sheet.
Exapmle : If F2 changes
HI chaya,
I hope this is what you're asking ...
On Tue, May 21, 2013 at 2:59 PM, Chaya wrote:
> Dear Priti,
>
>As always you did the great logical solution. Infact i really don't
> understand the formula used for data validation in Level2 (very huge long),
> but i have got some more ideas o
Thanks a lot priti.
Regards,
Chaya
The excel learner :-)
On Tue, May 21, 2013 at 3:39 PM, priti verma wrote:
> HI chaya,
> I hope this is what you're asking ...
>
>
> On Tue, May 21, 2013 at 2:59 PM, Chaya wrote:
>
>> Dear Priti,
>>
>>As always you did the great logical solution. Infact
Good job!!!
On Tue, May 21, 2013 at 3:42 PM, Chaya wrote:
> Thanks a lot priti.
>
>
> Regards,
> Chaya
>
> The excel learner :-)
>
>
> On Tue, May 21, 2013 at 3:39 PM, priti verma wrote:
>
>> HI chaya,
>> I hope this is what you're asking ...
>>
>>
>> On Tue, May 21, 2013 at 2:59 PM, Chaya wro
Does this make any sense?
On Tue, May 21, 2013 at 2:17 PM, Shrinivas Shevde wrote:
> Waiting for Reply
>
>
> On Mon, May 20, 2013 at 3:16 PM, Shrinivas Shevde
> wrote:
>
>>
>> Dear All
>>
>> Please find atached excel sheet contain data .
>> I want to make a Dynamic graph(as far a possible witho
DearI have actually twelve textbox in my userform with textbox i want sum all
numbers and display in a last textboxplease give me code as attachments.
Awaiting... Advance thankx to experts
RegardsSaju
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
I would change the name of the Total box to something like "Txt_Total" so that
the textbox# doesn't get confusing.
Then, I would create a function something like:
Function Sum_Textboxes()
Dim sTotal As Double
sTotal = 0
If (IsNumeric(SUM.TextBox1.Value)) Then _
sTotal
