Dear experts,
I require function to lookup value on consider of two particular condition.
Pls. see attached file for example.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
--
Are you =EXP(E:RT) or =NOT
Dear Vaibhav
Thankls very much working fine problem solved
Thanks once again
Regards
Shrinivas
On Wed, Feb 4, 2015 at 12:12 PM, Vaibhav Joshi wrote:
> Hi Sri
>
> Check this...
>
>
> You need to delete column B once you get data from Macro..
>
> Cheers!!
>
> On Wed, Feb 4, 2015 at 10:30 AM, Shri
Thanks a lot sir. It works perfectly.
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“SAVE TREES, SAVE EARTH” *
*“All appears to change when we change!”*
On 6 February 2015 at 00:42, Paul Schreiner wrote:
> The problem is that
The problem is that the first time a duplicate is encountered, instead of
ADDING it to an existing workbook, you're trying to create a new one.
Instead, I'd wait until they're all done before closing the workbooks.
Then, within the code, only create a workbook if it isn't already open.
I'd mod
Hello Sir,
I have attached the excel file which contains sheets & worksheet index i.e
Summary
In Worksheet Index tab
Column A contains the sheet name
Column B contains move or copy sheet
Column C contains Workbook name to be created.
I want to move or copy sheet based on table.
I wrote the co
This time code is working ok, what exactly you want please share in Excel
Sheet..
On Thu, Feb 5, 2015 at 8:35 PM, Vaibhav Joshi wrote:
> Check this on how to disable close button:
>
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=164
>
> http://www.contextures.com/xlUserForm01.html
>
> Cheer
Check this on how to disable close button:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=164
http://www.contextures.com/xlUserForm01.html
Cheers!!
On Mon, Feb 2, 2015 at 7:11 AM, sswcharlie wrote:
> Hi
> Excel 2000
> Three small questions as to these small codes not working.
>
> Want to
HI MV,
Check this :
http://education-portal.com/microsoft_office_specialist_certification_online.html
Regards
Ashish
--
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/disc
Hi
Use following code for creating Index:
Worksheet Index
First add a new sheet to the Workbook and call it "Index" (optional).
Next right click on the sheet name tab of the "Index" sheet and select
"View Code". In here you should paste the code as shown below
Private Sub Worksheet_Activate()
Hi All,
I would like to go for a MOS Certificate in excel 2007. I need some support
for the following queries.
how to approach on this exam?
What would be the syllabus?
Is there any fees details available?
Please share your thoughts and comments.
Wish you all a Great day.
Thank you
MV
--
A
I opened the file and it opened as I would expect.
Your error message implies that your computer "profile" is set to NOT allow
something here to happen.
Can you run macros in ANY workbook using this computer?
Can you open the VB Editor and look at the macros in this workbook?
Can you step thro
yes, you an do it...
On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna
wrote:
> Ok Vaibhav. Even though I have very little idea about VB (Just read the
> codes and try to understand them) I will give it a shot.
>
> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote:
>
>> i want you to w
Ok Vaibhav. Even though I have very little idea about VB (Just read the
codes and try to understand them) I will give it a shot.
On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote:
> i want you to work on present requirement...
>
> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna <
> kanw
i want you to work on present requirement...
On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna
wrote:
> Ok Sir, I will do that.
>
> I hope I am clear on my present question.
>
> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote:
>
>> You want to learn VBA then start modifying last code w
Thank u... Paul... & Vabz...
On Thursday, February 5, 2015 at 1:25:18 AM UTC+5:30, michael vinoth wrote:
>
> Dear All,
>
> I have a doubt.
>
> How to convert PDF file to Excel file using excel vba?
>
> It is very useful to me.
>
> Thanks in advance...
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Ok Sir, I will do that.
I hope I am clear on my present question.
On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote:
> You want to learn VBA then start modifying last code which i sent to you
> to accommodate it..
>
> Start & letus know when you get error..
>
> Cheers!!
>
>
> On Thu, Feb 5, 2
You want to learn VBA then start modifying last code which i sent to you to
accommodate it..
Start & letus know when you get error..
Cheers!!
On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna
wrote:
> Hi Experts,
>
> I have attached a sheet.
> I wish there could be a macro which when run
Hi Experts,
I have attached a sheet.
I wish there could be a macro which when run
--assess the website given in column A1,
--copy the value given in cell A4 in the input box
--wait for me to enter the Captcha MANUALLY (as I have learnt that it is
quite a tedious process via code)
--copy the result
That Was Amazing Indeed !
How do you do it !
Kindly share what should be the First step in Learning VBA. I am seriously
into this now...
On Thu, Feb 5, 2015 at 12:19 PM, Vaibhav Joshi wrote:
> Yes, check this...
>
> Cheers!!
>
>
> On Wed, Feb 4, 2015 at 11:49 PM, Kanwaljit Singh Dhunna <
> kanw
Hi
I tried this one and un-ticked MISSING from libraries and tried to Save As
the file with existing.
Then it says: The file is already exists. Do you want to replace with
existing file?
When I click on Yes it again says: Unable to remove existing file..
Kindly look in to this please.
Than
20 matches
Mail list logo
