Dear Experts,
Help required for attached sheet urgently
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poo
Dear Saurabh aka Doki,
You are welcome.
For WITH loop, refer to the link below:-
http://www.exceltip.com/st/Using_Loops_in_VBA_in_Microsoft_Excel/628.html
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 1
thanks. can u pls expain me how dis WITH statement work. If u hav any lik
den pls send me. Thanks once again
On Thu, Jan 7, 2010 at 4:02 PM, Dilip Pandey wrote:
> Dear Doki,
>
> Attached solution has been revised as per your needs. Thanks.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
> MBA-HR,
Dear Doki,
Attached solution has been revised as per your needs. Thanks.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jan 6, 2010 at 11:39 PM, Doki wrote:
> yes. only data in the sec
yes. only data in the second row (which contain yes/no ) sud be cleared with
all the vaidation it contain
On Wed, Jan 6, 2010 at 6:51 PM, Dilip Pandey wrote:
> You are welcome Doki.
>
> Regarding your query, I have following doubts:-
> 1) Only the data in those selected cells should be clear or
You are welcome Doki.
Regarding your query, I have following doubts:-
1) Only the data in those selected cells should be clear or,
2) The data + the validation should be cleared.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan..
Thanks Dilip,
It is on the same line of my requirement. just one more thing. Can we make a
refresh button , by clicking that All the selected cell having the dropdown
will get blanked.
Thanks for your time.
Regards,
Saurabh
On Tue, Jan 5, 2010 at 2:51 PM, Dilip Pandey wrote:
> Dear Doki,
>
>
Dear Doki,
Required validation (drop down) is there in the attached workbook.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jan 4, 2010 at 9:38 AM, Doki wrote:
> Im stuck with one prob
Thanks Praveeen,
It is mostly same what I was trying for. Just one more thing..
It sud be lik if i change the True to Flase or blank the Dropdown sud be
removed.The cell sud b completly empty.
Doki
On Mon, Jan 4, 2010 at 11:18 AM, kvc praveen kumar wrote:
> Hi Doki,
>
> Please check the attach
Hi Doki,
Please check the attached workbook and let me know if this is what you were
expecting.
Please run macro1
Regards,
Praveen
On Mon, Jan 4, 2010 at 9:38 AM, Doki wrote:
> Im stuck with one problem..I guess togather we can solve it..
>
> Prob is:
>
> I want a Dropdown (may be "Yes" n "No"
Im stuck with one problem..I guess togather we can solve it..
Prob is:
I want a Dropdown (may be "Yes" n "No") in the Worksheet with a if
condition.
Like If( TRUE) then I'll have a Dropdown (or list) says YES No but if
(FALSE) then Blank cell should appear...
Anyone need further clarification d
11 matches
Mail list logo
