Hi Priyanka,
I have a written a macro which does similar task, but I just wanted to
check with you about "Subject" and "Mail Body" of the email.
What would be the Subject and what should be written in the mail?? If you
can give me these 2, I will modify the macro and send it to you.
Regards,
Ani
Mathai Chacko wrote:
> It means the sheet is protected with another password, and that you cannot
> unprotect the sheet using a password that does not match.
>
> Sam
>
>
> On Fri, Oct 28, 2011 at 9:16 PM, Anish Shrivastava wrote:
>
>> Hi,
>>
>> Pleas
Hi,
Please see the code below, when I run the code it says "password you
supplied is not valid".
===
Sub unpro()
Dim sht As Worksheet
Dim uname As String
Dim pwd As String
uname = Environ("Username")
pwd = "Sample"
For Each sht In Worksheets
If uname = "anisku
Thank you Very much Ashish.. This would help, as I needed to work on Word
macro but I couldnt, just becoz I had no clue. By going through first
few pages of this book, I think I can learn it faster.. :)
Thansk again for sharing this.
On Sun, Oct 23, 2011 at 8:01 PM, ashish koul wrote:
> http://
Imran Ansari wrote:
>>
>>> Hi Anish,
>>>
>>> Can you tell me as to how can i get the same
>>>
>>> Also please tell me the name of the software that your are using and the
>>> amount in rupees to spend for same
>>>
>>> Do
Hi,
I have a password recovery application (Licensed version) but it works only
till office 2003.
I tried unlocking your file but no success since it's "xlsx" (2007).
If anyone needs any assistance in breaking passwords till "xls" or any
office application till 2003 ver, I can be a help.
Thanks
Hi Haseeb,
Thanks for you help on this query but recently I noticed onething, this
formula works when we have to match strings from left. In this case it works
fine. But when I have the below scenario, it doesnt work properly.
For example, in source sheet I have "Analex Corporation" and in Destin
Strange!! but I got it working with the same code below.
Thanks a lot for this.
Anish
On Mon, Jul 25, 2011 at 7:46 PM, Anish Shrivastava wrote:
> Hi Rajan,
>
> Thanks for your quick response. It works fine.
> However I made few changes according to my further requirements and then
quot;).Range("A2").End(xlUp).Row + 1).Value = myWord*
>
> * MyTest = False*
>
> *Next*
>
> *Sheets("WrongWord").Activate*
>
> *MsgBox "Total " &
> WorksheetFunctio
Hi,
Is it possible to store those keywords which is being found using Spellcheck
option in excel.
I have a list of values in Column "A" on which I run the spellcheck. Now I
want, excel(vba) to store those wrong values in sheet2 which is being found
by spellcheck function so that I can populate th
Yes Prabhu, It is possible.. Pour in your further details/sample
attachments.
On Thu, Jul 21, 2011 at 11:03 PM, Prabhu wrote:
> Hi all,
>
> I need to send Automatic mail message from my mail id to some around 10
> members in every week end to remind them to do something.
>
> I can create distrib
Haseeb Sir,
I am becoming a FAN of you... You seem to have super knowledge of
Formulas... tooo good...
On Thu, Jul 21, 2011 at 9:58 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Prabhu,
>
> Use SUBSTITUTE. or excel's Find/Replace command
>
> SUBSTITUTE is a case sensitive fun
is it possible to attach the sheet? You can remove the data from it or
replace the values..
On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote:
> Yes, the names are all ok, i double checked it, even try to change names,
> but doesn´t work :S
>
> 2011/7/21 Anish Shrivastava
Please check if the sheet name is "Pivot".
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote:
> Hi guys, i have this macro i use to copy a range from column D of a
> worksheet of a workbook to column G of another workbook and worksheet, but
> it keeps giving me
Harish,
Did you try it.. ??
On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava wrote:
> Harish,
>
> PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in
> that macro.
>
> Use this attachment.
>
> On Thu, Jul 21, 2011 at 5:09 PM, Anish Shriv
Prabhu,
Use the solution given by GoldenLance below.
=SUBSTITUTE(A1,"ABC","#")
*GoldenLance,*
Thanks Man, This formula didnt hit my mind at that time.
On Thu, Jul 21, 2011 at 10:02 PM, GoldenLance wrote:
> Wouldn't this be much more easier, and apt?
>
> =SUBSTITUTE(A1,"ABC","#")
>
> On Jul 21,
Giving the formula as per your example.
*=IF(RIGHT(A1,3)="ABC",LEFT(A1,2)&"#",A1)*
Copy it down.
On Thu, Jul 21, 2011 at 8:55 PM, Prabhu wrote:
> Hi Friends,
>
> Can you help me to know the formula for find and replace.Example i need to
> find "ABC in the A1 cell and replace with "#". If th
Vijay,
Though you have provided the sample sheet your requirement is not clear.
What do you mean by merge the names in one sheet. do you want to consolidate
the data or you want a concatenation.
On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA wrote:
> fyi
>
>
> On Wed, Jul 20, 2011 at 6:25 PM, N
Harish,
PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK* in
that macro.
Use this attachment.
On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava wrote:
> Hi Harsih,
>
> Since you didnt reply about column headers I assumed that it's the same for
> ev
00 PM, Anish Shrivastava wrote:
> Harish,
>
> I forgot to ask you one thing.
> The column headers in the file you attached will be constant for all the
> 30-35 files which are there on your sharedrive, right?
> Cheers,
> Anish
> On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma
file with one row filled.
> And Column "C" & Column "H" concatenate should give us unique value so if
> this is repeated then we need to have below requested feature.
>
> Hope this would be more clear now.
>
> Thanks
> Harish
>
>
>
> On 20 July
he sample file with one row filled.
>> And Column "C" & Column "H" concatenate should give us unique value so if
>> this is repeated then we need to have below requested feature.
>>
>> Hope this would be more clear now.
>>
>> Thanks
&
Hi Anwar,
Please run the below code and see if it works fine..
--
Sub conc_test()
Dim main_word As String
'cell_pointer = 0
lastrow = Sheets(1).Range("A2").End(xlDown).Row
counter = 3
While counter <= lastrow
Set present_cell = Range("E" & counter)
Set present_cell1 =
One sample sheet would be helpful to us to see the data structure.
However, for this "*Also identifiy if there is any row duplicated and
highlight them and paste them into another sheet" * There must be any
particular data field which has to be checked against others in order to
find duplicates.
Hi Azeema,
Here comes the macro for this. (see the attached file)
*Hey Dave,*
Have seen your post after a really long time. :)
Cheers
On Wed, Jul 20, 2011 at 6:16 PM, Dave Bonallack
wrote:
> Hi Azeema,
> Have a look at the attached to see if it meets your needs. The formula is
> really cumber
o
> > populate the erroneous amount of fluff that you see in my xls
> >
> > On Wed, Jul 20, 2011 at 12:35 AM, Anish Shrivastava
> wrote:
> >> Hi Adam,
> >>
> >> Great thing.
> >> I would request you again to send me only those sheets which
act everything from the raw data, instead of hundreds of
> vlookups in hidden tabls…..all of the other bucket breakdowns once I
> can get this to make sense from the raw data.
>
> Attached is a monthly spend ticket as submitted per executive review.
>
> On Tue, Jul 19, 2011 at
Hi Adam,
Looking at your workbook, it seems that it's a complete dashboard project to
be completed and in these cases Sample data wouldn't do the perfect job
(However we can create one dummy dashboard).
I understand that you want it to be interactive to the user creating
homepage and navigation w
Hi Adam,
Are we missing the Sample db as attachement?
On Tue, Jul 19, 2011 at 6:40 PM, Adam Hamilton wrote:
> Hi, guys,
>
> So, I’ve created this complex budget workbook for the department I
> manage. Everything is automated, however, now that I want to create a
> dashboard with the data, all o
Hi Anwar,
You requirement is not clear to me.. Merge few cells (manually) in the
sample sheet according to your requirement and send it.
Will write the code for you.
Thanks,
Anish
On Tue, Jul 19, 2011 at 3:56 PM, Anwar Mohd wrote:
> Hi All,
>
> Can any one help me with this.
>
> Regards
>
> Anr
Hey Haseeb,
This formula is AWESOME man... Tooo goood.. helped me big time..
A big THANK YOU :)
Thanks,
Anish
On Tue, Jul 12, 2011 at 8:25 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello, Try this Array Formula. Must hit CONTROL+SHIFT+ENTER, rather than
> ENTER.
>
>
> =INDEX(
) <
afrika...@gmail.com> wrote:
> Anish Shrivastava wrote:
>
> > Anyways, I will give you another macro which will search in each cell on
> the sheet and if it finds a value then it will populate cells address at the
> begining for the text but this may lead to problem with formul
t; & cel.Row & "]]]" & cel.Value
End If
Next cel
End Sub*
**
*Note :- I can understand completely that you cannot share the sample sheet
with me ;)*
Cheers!!
Anish
On Sun, Jul 17, 2011 at 6:38 PM, Samuel Murray (Afrikaans translator) <
afrika...@gmail.com> wrote:
> An
Hello Group,
It would be an add-in for my learing, if you can suggest the code for
finding unique account values from Column "A" using the code so that
Shrinivas doesnt have to copy and paste the unique account values manually
in cell M1.
Thanks,
Anish
On Fri, Jul 15, 2011 at 5:27
Hi Shrinivas,
Attached please find the Dump file with macro. You will have to copy and
paste your unique account numbers in Cell *"M1" *before running the macro.
Data will be splitted based on the account numbers and new files will be
saved with account names.
Also note that I have done it with
Hello Sir,
I guess, I answered this query yesterday with attachment.
Please let me know if it didnt work or you want a different solution.
This was the code..
Sub copy_rows()
Dim sht As Integer
For sht = 5 To Worksheets.Count
Sheets(4).Select
Rows("5:6").Copy
Sh
Hi Karan/Norain,
what is use of merging all the cells on a sheet. After merging what are you
going to do with the sheet as it will become like a Notepad page and you
cant use any other formula/function.
I am asking this just out of my curiousity, would appreciate your answer.
Thanks,
Anish
On F
Hello Samuel,
Please have a look on the attached file. This might be helpful.
I tried it only on one column since I dont know in how many columns you will
have the data. If you could attach a sample sheet for your data, I can make
it more feasible.
Let me know if it works, otherwise will try a d
Hi Sajid,
First of all, your sheet is protected, I couldnt save it as.. and 2nd you
are using wrong formulas.. specially which naming the range.
In the form sheet you are trying to do vlookup on a blank source.. in the
last sheet you are using a wrong name range for Vlookup..
We need an unprotec
PLease post a sample file with clear requirement.
On Wed, Jul 13, 2011 at 1:44 PM, Juan Antonio Castillo Guerrero <
castill...@gmail.com> wrote:
> Hello group!
>
> I'm doing an Excel spreadsheet in which I posed the following problem, I
> put a sample of what I have and a sample of what you need
Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)
On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma wrote:
> *=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0)*
>
> *Use this*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macro
Hi Chandra Shekar,
I assume your query is incomplete. However I will try to answer..
If you want to save a macro free (no vba code in it) workbook, you should
save it as ".xlsx". Remember there will be no macros in this file.
I hope you know the shortcut key for Save As (F12).
If you want a cod
t the
results.
I guess I am asking for much but yet I would request for it.
Appreciate your help.
Thanks,
Anish
On Mon, Jul 11, 2011 at 5:38 PM, ashish koul wrote:
> try this
>
> VLOOKUP(A1&"*",Sheet1!$A:$A,1,0)
>
> On Mon, Jul 11, 2011 at 3:42 PM, Anish Shriva
Thanks Ashish for sharing this. Really very informative (Infact the website
itself contains huge information on VBA).
Hope to see something for sorting on Numbers...
Thanks,
Anish
On Fri, Jun 24, 2011 at 3:29 PM, OpenExcel.com <26may.1...@gmail.com> wrote:
> Are you a reporting analyst in IT fi
Hi Venkat,
Can you please provide some sample sheet or data ? Otherwise can you please
elaborate more ?
Thanks,
Anish
On Mon, Jun 20, 2011 at 5:49 PM, Venkatesan c wrote:
> Dear All,
>
> Can any one have templates or websites for Call Center Inbound&Outbound
> Manpower scheduling.
>
> --
> *Bes
Tue, Jul 13, 2010 at 11:48 PM, Harmeet Singh wrote:
> may b attached tool will help you...
> Warm Regards,
>
> Harmeet Singh
> IT Analyst
> McKinsey & Company
> http://www.facebook.com/Harmeeet
>
>
> On Tue, Jul 13, 2010 at 10:21 PM, Anish Shrivastava >
PLease help me on this.
On 7/13/10, Anish Shrivastava wrote:
>
> Hello Experts,
>
> Yesterday, while using Google Translator manually I just thought if it
> can be automated using VBA. Actually what my task includes is to
> Convert various European language values to Standard E
Hello Experts,
Yesterday, while using Google Translator manually I just thought if it
can be automated using VBA. Actually what my task includes is to
Convert various European language values to Standard English lang.
I have values in a single Column (No fixed number of rows/values but
it will be
Hi Regina,
Please attach a sample worksheet with your problem.
On Wed, Jun 16, 2010 at 3:17 PM, ExcelVBA wrote:
> I am trying to use function Vlookup, but the cell value I am refering
> contains a function and the result I am getting is #N/A , is anyone
> who knows how I can solve this proble
Hi Rajesh,
You should provide some more details like which all raw data you have? For
creating automated Invoice Format, we can create 100 types of template but
what are your requirements.
Please be specific with your questions.
On Fri, Apr 30, 2010 at 12:22 PM, Rajesh D wrote:
> can some help
Please post your file here, will unprotect and send back to you.
--ANISh
On Wed, Mar 3, 2010 at 1:37 PM, Chieu Ang
wrote:
> Dear all,
>
>
>
> Anyone can help: How to unprotect the sheet( that has password)?
>
>
>
> Thanks
>
>
>
> Chieu Ang, Tan
>
> Finance Department
>
>
>
> Country Foods Pte
he macro testmulti()
> You should get a true for all multibyte character strings
>
> Regards,
> Praveen
>
> On Wed, Jan 6, 2010 at 3:57 PM, Anish Shrivastava
> wrote:
>
>> Experts
>>
>> Please helpor advice if it is possible...
>>
>&
Experts
Please helpor advice if it is possible...
-- Forwarded message --
From: Anish Shrivastava
Date: Tue, Jan 5, 2010 at 2:29 PM
Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
To: excel-macros@googlegroups.com
Hi Dave,
Attached please find the file with
..@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Experts!!!
>
> Any updates on below query??
>
> Thanks!!
> ANISh
>
> On Wed, Dec 30, 2009 at 1:31 PM, Anish Shrivastava wrote:
>
> Hello Experts,
>
> Thank you very much for helping me on my earlie
Experts!!!
Any updates on below query??
Thanks!!
ANISh
On Wed, Dec 30, 2009 at 1:31 PM, Anish Shrivastava wrote:
> Hello Experts,
>
> Thank you very much for helping me on my earlier queries.
> Could you please help me in finding cells which contains multibyte
> characters.
>
Hello Experts,
Thank you very much for helping me on my earlier queries.
Could you please help me in finding cells which contains multibyte
characters.
I mean how can we find or select the cells which contains NON-English
charecters.
We get the data from almost each country in this world to work o
Hi,
You can simply use SUBTOTAL function, which you can find under DATA submenu.
Attached please find the solution.
Cheers!!
ANISH
On Fri, Dec 18, 2009 at 3:20 PM, Praveen kumar wrote:
> dear all
>
>
> need a help..
>
>
> A similar product in sold to different customers on the same day at
Hey Steve,
Looks like your problem can be solved by using simple vlookup. Can you
please provide an example sheet so that I can put in the solution... (Sorry,
no time out of office work to create the example sheet myself)
Cheers!!
ANISH
On Thu, Dec 17, 2009 at 1:14 PM, Steve wrote:
> I have a
hey Suhas,
Could you please attach a sheet wid this example as it looks bit messed up
here...data is not being displayed properly...once you send the sheet, will
certainly give it a try..
ANISH
On Wed, Dec 16, 2009 at 4:35 PM, Suhas wrote:
> Hi everyone,
>
> I am facing some problems with SUMI
Hi Skanda,
Attached please find the solution..Lemme know if the format is according to
your requirements..
Cheers!!
ANISH
On Wed, Dec 16, 2009 at 8:46 PM, Skanda wrote:
> Srini,
> Thanks for the response.Let me explain my requirement.
>
> We need the percentage at the physician level.
> say f
e everyone is welcome and we try to help each other. If
> by any chance someone is not able to help/understand your problem. Then
> someone else will help you. So please be patient. Tomorrow when you try to
> help someone you will not like that person writing like this to you...
> Right!!!
Hi Punit,
Thanks for you helping attempt, but tht's not wht I want. You used just
vlookup in 2 cells...I m afraid to say tht but even I know tht much of
basics (No offence). Could you please let me know wht if the occurance is 3
times. :P
Cheers!!
ANISH
On Fri, Nov 13, 2009 at 3:06 PM, punit pod
Hello Experts,
Once agian I am here with a new problem (Thanks for helping me earlier, on
my code).
This time I am stuck with Vlookup, actually I have a list of lot # for which
I have to find TIC # from another table but the problem is it has got
multiple occurances. Our simple vlookup picks the
Hi Prashant,
Why dont you use SORT the column which you want..It's juz very simple.
Try it once :)
Cheers!!
ANISH
On Thu, Oct 29, 2009 at 7:16 PM, Prashant Bhawar
wrote:
> i want top 10 performing learner from all the data( i want there names in
> that column by Rank 1 to Rank 10 ).
>
> --
>
27;-------
>> j = j+1
>> 'Wend!
>>
>> I have not tested this code yet.
>>
>> Pls test and let me know if its not working
>>
>> 2009/10/26 Hemant Hegde
>>
>> Hi Anish
>>>
>>>
---
> j = j+1
> 'Wend!
>
> I have not tested this code yet.
>
> Pls test and let me know if its not working
>
> 2009/10/26 Hemant Hegde
>
> Hi Anish
>>
>> Its not the problem with "WHILE" or "WEND"
>>
>&g
Thanks Dave,
Looks like we have got another idea to ignore count of ENDIF's ;) ... by the
way wht r disadvantages of using 100 instead of ENDIF??
Cheers!!
ANISH
On Mon, Oct 26, 2009 at 2:23 PM, Dave Bonallack
wrote:
> Hi Anish,
> I also think it's just a mis-count on the End If's
> You can simp
6, 2009 at 12:23 PM, Hemant Hegde wrote:
> Hi Anish
>
> Its not the problem with "WHILE" or "WEND"
>
> Make sure you have closed all "IF" conditions with "END IF" at proper
> places
>
> Just check if you have started an IF condition i
Hello Experts..
I m using While and Wend statement in my code and it has got more than 100
if conditions. when I run the macro it says "WEND WITHOUT WHILE", it's
buggin my head...and I don know wht's wrong. Could anyone of you please help
me...
Sample code...
Sub dept()
i = 1
z = Cells(Rows.Coun
Hi Anurag,
IF you dont mind then please send the file to me, I will give it a try (as
of now dis cracker has cracked all the excel file ...hope this one also
count on)...
I will recover and send it bk to u.. (I cant send you the Setup file coz I
don hv it for dis software/cracker, I hv got it ins
Hello Experts...
Could anyone please tell meis is possible to dig in a *.xla file...I
mean if anyone created any Macro and converted it to *.xlaDo we have any
way to Dig into the codes in tht XLA file???
Please reply on this if it is possible
Cheers!!
ANISH
--~--~-~--~-
Hey Sai,
You just have to use the formula, it's very easy ...you have to link the
files together...I don think we need any macro for this thing...
Suppose if you want the value of cell 'A1' of sheet 1 in the cell "B1" of
sheet2 then just got to "B1" of sheet 2 and type = and then go to sheet 1
an
Hi Prabhakar,
This *.rar file is asking for password, could you please let us know the
same so that we can use the application.
Thanks a ton for sharing it..
Cheers!!
ANISH
On Wed, Oct 7, 2009 at 4:40 PM, prabhakar jain wrote:
>
>
> On Wed, Oct 7, 2009 at 10:11 AM, N.Shivkumar wrote:
>
>> Is
ication (if possible the
> link to download) so that even we can download the application.
>
> Thanks & Regards,
> Ramkrishna T. Padhi
> On Wed, Sep 30, 2009 at 5:03 PM, Anish Shrivastava
> wrote:
>
>> I have a Password Cracker application...may be I can give it
I have a Password Cracker application...may be I can give it a try..plz do
send ur file..
Cheers!!
ANISH
On Wed, Sep 30, 2009 at 5:00 PM, vivek agrawal wrote:
> Hi There..
>
> I have downloaded a pdf file which is PASSWORD PROTECTED.
>
> CAn anyone PLEASE help crack the password. IF YES, then pl
Dude,
Go For Advanced Filter.
On Wed, Sep 16, 2009 at 12:51 PM, Aligahk06 wrote:
> Dear All,
>
> I want to fetch unique records through Formula or VBA.
> I have two records in two different column.I want to fetch Unique records
> from both the Column.
> E.g
>
> Col k10:k25 Col L10:L25
>
rom another sheet.
>
>
> -- Forwarded message ------
> From: Anish Shrivastava
> Date: Tue, Aug 25, 2009 at 3:32 PM
> Subject: Re: $$Excel-Macros$$ Help regarding formula
> To: excel-macros@googlegroups.com
> Cc: vidyutm...@gmail.com
>
>
> Hi Vidyut,
>
&
Hi Vidyut,
Attached please find the worksheet wid formula. I just used Data Validation
to create the list of your Q.No. and used below formula.. Hope it Helps.
=SUMPRODUCT(($A$2:$A$211=$F$219)*($C$2:$C$211=G217)*($H$2:$H$211))
Cheers!!
ANISH
On Tue, Aug 25, 2009 at 2:23 PM, vidyut more wrote:
Hi Anil,
Do you mean to say, you want 4 text files...
And what do you mean by specified delimiter...
I can give you the code which wil seprate the rows in any number of files
but the file name would be same as file01, file02 file03 and so on
Please lemme know...if it's okay...
On Wed, Ma
Hi Sachin,
It was very simple...Just use Conditional Format feature...
Attached is the file wid solution..
Thanks!!!
ANISH
On Wed, Mar 25, 2009 at 4:17 PM, Sachin Shukla wrote:
> Dear All,
>
> Please help me on said subjects . I attached sheet for same problem.
>
> Thanks in Advance
>
>
> Sach
80 matches
Mail list logo