*Try this also:*
*
*
*Formula in A1 is =NOW()*
*
*
*Formula in A2 is*
*
*
*=IF(WEEKDAY(IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0))),2)
= 6,
IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0)))+2,IF(WEEKDAY(IF(WEEKDAY(A1
I want to add time to a particular date and time by 5 minutes in every
subsequent cell. The time range should be between 10:00 AM to 5:00 PM. I.e.
after 5:00 PM the date should be changed to next day 10:00 AM. And the day
range will be Monday to Friday. i.e. if it’s a Saturday or Sunday it shou
Try this link and change the code accordingly.
http://www.excelfox.com/forum/f13/excel-excel-data-transfer-without-opening-any-files-source-target-339/
On Sunday, 29 April 2012 02:05:34 UTC+5:30, excelGeek wrote:
>
> Dear Anil,
>
> Yes it is possible by using odbc connection with the workbook a
Dear Anil,
Yes it is possible by using odbc connection with the workbook and query to
copy the data from source to destination where source is your 5 workbook
and the destination is your sheet where you want to paste the data.
Regards
Lalit Mohan
On Saturday, 28 April 2012 14:04:43 UTC+5:30, a
Dear Lalit,
Your really great scripter. Amazing skills
Thanks for all my requirement which is through in less time .
On Sat, Apr 28, 2012 at 11:59 PM, ╰» ℓαℓιт мσαнη
wrote:
> Dear yogananda
>
> Please find attached and try this one if it is working for you as per your
> requirement.
Dear Rajan,
What will be that formula in both scenarios ?
Please help me with the same.
Regards,
Milin
On Sat, Apr 28, 2012 at 9:24 PM, Rajan_Verma wrote:
> ** **
>
> Formula.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mili
Formula.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Milin Sulakhi
Sent: Apr/Sat/2012 08:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help required on how to create iterative
formula
Dear Rajan,
But I will need to add
Dear Rajan,
But I will need to add formula or values in cells marked Green in attached
file. Right ?
Regards,
Milin
On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma wrote:
> Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* exc
Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Milin Sulakhi
Sent: Apr/Sat/2012 06:42
To: excel-macros@googlegroups.com; milinsula...@gmail.com
Subject: $$Excel-Macros$$ Hel
Try this:
=TEXT((C7+D7)-(A7+B7),"[H]:mm:ss")
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: Apr/Sat/2012 06:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Time calculation sheet
Hi Experts,
I ha
To Understand Looping in VBA, please follow
http://excelpoweruser.blogspot.in/search?q=Loop
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of bpascal123
Sent: Apr/Sat/2012 06:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re:
*Hi Experts,
I have attached the file which i am unable to calculate the time
sheet. please help me out to sort out. thanks in advance.
*
Thanks & Regards,*
*
*Deba Ranjan P***
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thre
Dear Excel Gurus,
I need help on calculating some iterative formula where result is the basis
of some calculation within formula.
I have activated iterative calculations under excel options.
There are 2 scenarios I need to create.
Please help me with excel formulas without using Goalseek , as I
Do --- Loop While means you do what ever is inside the loop and then you
check if the while condition is met. In other words, it could be like you
first make a phone call and then check your balance, the thing is that what
ever your balance is, positive or negative, you will enter the loop (make
*Thanks.. i will try to find out myself . Thanks once again.
*
Thanks & Regards,*
*
*Deba Ranjan P***
On Sat, Apr 28, 2012 at 5:42 PM, Rajan_Verma wrote:
> These Codes are written by a Human not by machine .. you need to learn how
> to write the Computer instruction, you can download bo
Use this macro in a macro enabled workbook
Sub insertrows()
Dim i As Long
On Error Resume Next
For i = Cells(Rows.Count, "c").End(xlUp).Row To 2 Step -1
If Cells(i, "c") <> Cells(i - 1, "c") Then Rows(i).Insert
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
These Codes are written by a Human not by machine .. you need to learn how
to write the Computer instruction, you can download books from internet and
can take help of group and forum to build up your programming skills.
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googl
Thanks NOORAIN ANSARI, Rajan Verma & CoRe for solved my query.
Best Regards,
Rabindra
cid:image002.gif@01CC7D01.9571E350
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rabindra Thapa
Sent: Friday, April 27, 2012 2:35 AM
To: excel-macros
Hi Group,
how to insert the row after every unique name?
Regards,
Aamir Shahzad
--
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
*Hi sir,
See the below coding, you will find that there are so many steps and so
on. Can we run like so in the macros, if so please tell me the procedure to
that.
*
eg:-
Sub Main()
' Inserts random numbers on the active worksheet
Dim Counter As Integer
Dim RowMax As Integer, ColMax As
What do you mean by appropriate code?
Regards,
Sam
On Sat, Apr 28, 2012 at 3:42 PM, Deba Ranjan wrote:
> *Hi sir,
>
>I tried many times but the coding never comes, i mean the appropriate
> coding never comes. kindly sort out.
> *
>
>
>
> Thanks & Regards,*
> *
>
> *Deba Ranjan P***
>
>
*Hi sir,
I tried many times but the coding never comes, i mean the appropriate
coding never comes. kindly sort out.
*
Thanks & Regards,*
*
*Deba Ranjan P***
On Sat, Apr 28, 2012 at 2:17 PM, Sam Mathai Chacko wrote:
> You can record macros in Excel. To know how to record macros, just
You can record macros in Excel. To know how to record macros, just do a
google search.
REgards,
Sam Mathai Chack
On Sat, Apr 28, 2012 at 1:42 PM, Deba Ranjan wrote:
> *Hi Experts,
>
> Is there any trick or any software to create macros coding. i have seen
> many from the experts that they eas
Hello friends,
I have 5 workbook in excel and i want to copy in 1 sheet without open
any excel or 1 workbook. is that possible.
Thanks & Regards
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urge
*Hi Experts,
Is there any trick or any software to create macros coding. i have seen
many from the experts that they easily run the macros with the coding.
Please do let me the prevailing coding how to write the coding.
*
Thanks in advance. Hope you all help me out for the coding.
Thanks &
25 matches
Mail list logo
