ving and organizational skills
• Java and JavaScript experience highly preferred
*Thanks & Regards*
*Avinash*
* USM SYSTEMS | 14175 Sullyfield Cir, #400, Chantilly, VA 20151*
703-794-5762*avinashn**@usmsystems.com*
*www.usm* <http://www.usmsystems.com/>
RE:Securi
Dear Concern,
Please find the attached excel file and get me solution regarding
difference between timing.
Thanks.
--
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/discussex
attached excel for your reference and better understanding ,
with 3 different sample dates.
Regards,
Avinash
--
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
> On Saturday, March 28, 2015 at 9:14:11 PM UTC+5:30, Avinash wrote:
>>
>> Hi Experts,
>>
>> i want a macro which can copy data from another application to excel.
>>
>> below is the code which i am trying to use. i dont have any workbook to
>> expla
eys SendString, True
Exit Do
End If
Loop
End Sub
Please help me everyday i am spending 5-6 hrs to do this job (alt + tab,
copy one row, paste in to excel, again alt tab, copy second row, alt tab,
paste in to excel row by row)
Thanks in Advanced.
Regards,
Avinash
--
eys SendString, True
Exit Do
End If
Loop
End Sub
Please help me everyday i am spending 5-6 hrs to do this job (alt + tab,
copy one row, paste in to excel, again alt tab, copy second row, alt tab,
paste in to excel row by row)
Thanks in Advanced.
Regards,
Avinash
--
eys SendString, True
Exit Do
End If
Loop
End Sub
Please help me everyday i am spending 5-6 hrs to do this job (alt + tab,
copy one row, paste in to excel, again alt tab, copy second row, alt tab,
paste in to excel row by row)
Thanks in Advanced.
Regards,
Avinash
--
I really need your help in this query
Expecting output is *"NeedHelp"*
I have already tried below vba codes for this, but these are not working so
can you please provide any other solution.
1. Dim MyVar As String = ""NeedHelp""
2. Dim MyVar As String = """NeedHelp"""
3. Dim MyVar As String =
hi all,
i want criteria based week selection
attached is the excel sheet for better understanding.
Regards,
Avinash
--
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
Awesome man it's working thanks a TON!
Regards,
Avinash
Sent from my iPhone
On Oct 2, 2013, at 2:03 PM, ashish koul wrote:
=IF(B3=1,"PR -1 ",IF(AND(MOD(B2,4)=0,MOD(B3,4)<>0),"PR - "&
RIGHT(E2,LEN(E2)-4)+1,E2))
On Wed, Oct 2, 2013 at 1:43 PM, Avinas
logic you have used to mark them as PR1 - PR -2
On Wed, Oct 2, 2013 at 3:09 AM, Avinash wrote:
> Hi all,
>
> can anyone please help me to get periodic calculations.
>
> attached is the sheet for your better understanding. i want same value
> highlighted in yellow by formula.
&
Hi all,
can anyone please help me to get periodic calculations.
attached is the sheet for your better understanding. i want same value
highlighted in yellow by formula.
Regards,
Avinash
--
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
please help me for
to achieve this.
Regards.
Avinash
--
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. Poor
I am sharing a spread sheet in excel 2007 (.xlsx) format with one my
colleague and it is automatically getting formatted at his end. Does
anybody has any idea about that?
Thanks for your help in advance!
Avinash Daga
--
Join official facebook page of this forum @
https://www.facebook.com
sheet one by one and select the range then next sheet
but not using loop
and thanks for letting me know about the cells references it was great
information for me and now i will definitely try make change in my existing
macro.
regards,
Avinash
On Friday, July 6, 2012 9:07:39 PM UTC+5:30, Don
thanks don but what if the sheets name are in M column and range names are
in N column???
Regards,
Avinash
On Friday, July 6, 2012 9:00:40 PM UTC+5:30, Don Guillett wrote:
>
> And, if as shown you want the cells populated with the name in col A,
> NO selections are necessary or
hi don thanks for your help
and sorry for i was not able to explain my requirement but can u please
explain me how this code is working and what if the range table which is
mentioned in A and B column is in M and N column???
what will be the code???
Regards,
Avinash
On Friday, July 6, 2012
Hi rajan it is not working i am getting this error "Subscript out of range"
Regards,
Avinash
On Friday, July 6, 2012 6:16:27 PM UTC+5:30, Rajan_Verma wrote:
>
> Use this:
>
>
>
> Sub SelectRange()
>
>
>
> Dim WksSheet As Range
>
>
e("a2").Value).Range(Range("b2").Value).Select
> End Sub
>
>
>
> On Thu, Jul 5, 2012 at 10:47 PM, Avinash wrote:
>
>> Hi all,
>>
>> i want help regarding range selection from worksheet.
>>
>> i have created 1 macro to select speci
like
*Sheet Name* *Defined Range* Sheet1 C7:BS37 Sheet2 C8:BS37 Sheet3
C9:BS37 Sheet4 C10:BS37
and it should use range from worksheet not from macro module i hope u
understand what i am trying to tell u guys.
please help me on this
Regards,
Avinash
--
FORUM RULES (986+ members already
Thanks Don ,
But i am not able to understand this that is the reason i am asking for
help.
Regards,
Avinash
On Monday, June 18, 2012 8:57:26 PM UTC+5:30, Don Guillett wrote:
>
> http://oreilly.com/pub/h/2607
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid
Thanks Don ,
But i am not able to understand this that is the reason i am asking for
help.
Regards,
Avinash
On Monday, June 18, 2012 8:57:26 PM UTC+5:30, Don Guillett wrote:
>
> http://oreilly.com/pub/h/2607
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid
% completed*.
*it should not complete before any step finished* it should load as per the
step are getting completed.
Regards,
Avinash
On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote:
>
> See the attached file
>
>
>
> * *
>
> *Regards*
>
> *Rajan
Thanks Manoj for you help.
But i want progress bar macro formatting macro i already have i
have mentioned sample macro code not my actual code.
Regards,
Avinash
On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:
>
> Dear Avinash.
>
>
> Sub gg()
>
> For
Dear Experts,
I have 1 workbook and there are 10 subsheets in that workbook.
i have created 1 macro to format those 10 subsheets.
every sheet does have different formatting e.g. sheet 1 bold text for row 1
and and sheet 2 bold italic text for row 2.
so now i want macro to show the progress bar (
to get this done.
Regards,
Avinash
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered
Hi NOORAIN,
Thanks for your help man both the formula and macro works fine.
you are just awesome man simply great only 5 lines of code and doing
exceptional task.
salute for your logic and your knowledge.
not just words ! :)
simply great.
Regards,
Avinash
On Friday, June 1, 2012 11:17
Hi Excel's,
I want to retrieve unique records from the data. 1st preference will be
formula.
otherwise if anyone can help me with the macro or function will also
welcome.
please find attached sheet for better understanding.
Regards,
Avinash
--
FORUM RULES (986+ members already B
Thanks Andy,
It works very well.
Thanks thank you so much...!
Regards,
Avinash
On Sunday, April 22, 2012 12:18:50 AM UTC+5:30, Andy wrote:
>
> Dear Avinash,
>
> My mistake.. I forgot I am using Excel 2010 and shd have been careful.
>
> Looks like the part of the form
Thanks Andy,
I saw the sheet which u have attached and the results also but when i tried
to press enter to that cell it is automatically showing me (
#NUM!) error message i don't know what is the issue i am using excel 2007.
Please help
regards,
Avinash.
On Saturday, April 21, 2012
thank you so much ASA.
thanks for all your help.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not
,
Avinash.
On Saturday, March 24, 2012 7:26:14 PM UTC+5:30, Asa R. wrote:
>
> Avinash my friend,
>
> My pleasure.
>
>
>
> *As to the formula for C2…* You should get the same result for formula #1
> and formula #3. The downside with those is that they refer to the
&g
How can I save excel macro file (.XLSM) file to XLS format? and macro
still working in that file?
Thanks and Regards,
Avinash Daga
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
hi all can anyone help me to get the desired result in this sheet
i have attached the sheet please see the attachment for better
understanding.
Regards
Avinash
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
is to true so that it may change but it is not usefull
when i am manualy entering TRUE it is changing but when i click on the chek
but it is not changing so i request all you masters please help.
Regards,
Avinash
On Tuesday, February 28, 2012 8:20:11 PM UTC+5:30, Avinash wrote:
>
> Dear Ex
stead
of true i want date and time to come in this format (m/d/ h:mm AM/PM)
can anyone please help me to get this done by macro or something in this
regards.
--
Thanks and Regards,
Avinash Patil
"Love does not happen its a choice. Its not magic or fate, but it is when a
person
t; See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
>
t; See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
>
yes dilip, i guess u r right. i want the results as per the results
highlighted in red border. and hyperlink format in red font.
regards,
Avinash
On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey wrote:
> Hi Avinash,
>
> Not entirely getting your point.
> Please confirm if you ne
signs,
Regards,
Avinash
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/group
t;><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Thanks and Regards,
Avinash Daga
Sr. Analyst,CMG
Mortgage Industr
; HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks and Regards,
Avin
Using "Application.Screenupdating = False " will disable the Screen
flickering. you can enable after the loop.
Also, I using ActiveCell for time consuming tasks. there are alternatives
like With Selection etc.. if you could post more details or the code
snippet, we can suggest more.
On Thu, Sep 11
Its variable declaration
On Thu, Sep 4, 2008 at 10:46 AM, Arjunm1984 <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am new to creating Macros in Excel..
> Can someone please let me know how and what is Dim function while
> creating Macro's ?
>
> Regards,
> Arjun
>
> >
>
--~--~-~--~~---
You can create hyperlink in the cell. And point it to the area you want to
highlight. Just google "How to create Hyperlinks in Excel" you will get
enough information
On Wed, Sep 3, 2008 at 5:00 PM, bpatton <[EMAIL PROTECTED]> wrote:
>
> I have my first page in soffice/excel the contains a manager
You can use a reference cell, Set its value to FALSE when you switch the
calculation mode to Manual. Create a Sheet change macro, and check if the
value is FALSE > Prompt yo user that Calculation mode is Manual > Press F9
On Wed, Sep 3, 2008 at 4:09 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]>wrote:
Below is a smaple snippet that shows how to use
-- to select the properties
For Each chrt in ActiveSheet.ChartObjects
chrtName = chrt..Parent.Name ' chrt name
if chrtName = "Chart1" then
chrt.delete
end if
Next
--- to set other properties
With ActiveSheet.ChartObject
47 matches
Mail list logo
