On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Macro Help
To: excel-macros@googlegroups.com
Date: Tuesday, December 19, 201
On Mon, 12/18/17, V wrote:
Subject: Re: $$Excel-Macros$$ Excel Macro Help
To: "MS EXCEL AND VBA MACROS"
Date: Monday, December 18, 2017, 7:56 PM
Hi, do you know how
can I get using validations in Google Drive that change the
colo
Hi, do you know how can I get using validations in Google Drive that change
the color by codes.
El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5), GENIUS escribió:
>
> look at the attachment, I can do only this.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
look at the attachment, I can do only this.
--
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 thread titl
Dear Paul,
Thank you for your help.
I have attached both files in the mail.
In the master file I’ve highlighted some columns, if I update any value in
the master file automatically it’s need to update in the another attached
excel..
Thank you in advance.
On Mon, 09 Oct 2017 at 14:41, Paul Schre
sure.fairly easily done.Please provide sample files.
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
--
I have a master excel file (ABC.xls) which has n number of rows and
columns.
And also i have another excel file (DEF.xls) which has limited number of
same data from the master excel file (ABC.xls).
I need a macro code for if i update some values in the master excel file
(ABC.xls), automatica
As you can imagine, it's not easy to set up such a relationship that pays
on a weekly basis. Instead of paying weekly, why don't you hire a developer
on project basis only as and when you need it? You could use
http://www.excelfox.com/forum/f21/ to post queries that you are willing to
pay for.
On
I neeed excel macro help on a regualr basis...can pay in dollars every
week. if you have time this week, can you pleas reply to me?
--
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
can you share the sample file
On Mon, Dec 17, 2012 at 9:57 PM, sw1085 wrote:
> Hi all,
>
> I've been searching for hours looking for a generic macro to help with the
> following problem.
>
> If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then
> copy that cell plus the previ
Hi all,
I've been searching for hours looking for a generic macro to help with the
following problem.
If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then
copy that cell plus the previous 4 cells to a new worksheet called "Sheet2".
Hope someone can help.
Best regards
sw10
Hi all,
I wanna learn Excel Macro.
Can someone help me or provide step by step procedure in pdf file to learn
it?
I dont know anything about Macro. But I am eager.
Appreciating your help in advance.
Regards,
M.Md Ali
--
--
Hi Friends,
Please help me to solve the below issue.
While i try to use the below code it says "Ambiguous name detected :W028M"
Private Sub CommandButton1_Click()
Dim fn As String
fn = Trim(TextBox1.Text)
If fn = "W001M" Then
Call W001M
TextBox1.Text = ""
ElseIf fn = "W002BW" Then
Call W002BW
Te
Hi,
VBA code for yesterday's date is:
A = Date - 1
The variable 'A' will contain yesterday's date.
Regards - Dave
Date: Tue, 25 May 2010 12:08:06 +0530
Subject: $$Excel-Macros$$ Excel macro Help : Date of Previous day
From: nsund...@gmail.com
To: excel-macros@googlegr
Hi,
I want to learn macros step by step. Please guide me.
Regards
Rakhee
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
use the following formula to get only the date.
=TODAY()-1
Regards,
Putta Madaiah
On Tue, May 25, 2010 at 1:15 PM, Swapnil Palande wrote:
> Hi Sundarvelan,
>
> There is no need to write vba code for this.
>
> Use following function:
> =NOW()-1 //This will return date and time ex.: 5/24/2010 13:11
Hi Sundarvelan,
There is no need to write vba code for this.
Use following function:
=NOW()-1 //This will return date and time ex.: 5/24/2010 13:11
=DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-1) // this will return only date
ex: 5/24/2010
Regards,
Swapnil.
On Tue, May 25, 2010 at 12:08 PM, Su
Hi Friends,
Please give the VBA code to find the date of previous day (yesterday).
Thanks,
N.Sundarvelan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
Hi friends,
Please help.
How to automatically set the range to clear the pagebreaks in different
data.
Thanks,
Sundarvelan
On Wed, May 5, 2010 at 5:42 AM, siti Vi wrote:
> try:
>
> Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone
>
>
> --
> On May 4, 6:09 pm, Sunda
try:
Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone
--
On May 4, 6:09 pm, Sundarvelan N wrote:
> Hi Friends,
> Please help me to solve the final step of my project.
> I need to remove the page break lines to the end of the column upto which
> the data is available.
> Thanks
Hi Friends,
Please help me to solve the final step of my project.
I need to remove the page break lines to the end of the column upto which
the data is available.
Thanks,
N.Sundarvelan
--
--
Some important links fo
Hello Friends,
Any one please correct the error
Dim fcount As Range
With ActiveSheet
Set fcount = Worksheets("N136D").Cells.Find(what:="COUNT",
MatchCase:=False).Select
Range(Chr((ActiveCell.Column) + 64) & ":" &
Chr((ActiveCell.Column) + 64)).Select
Selection.Delete
On Er
Hello Sundarvelan,
I suggest you try first the subtotal function of excel. On the menu click
on data then sub total, follow as prompted. It should give you what you
need.
On Sun, Apr 25, 2010 at 7:49 PM, Sundarvelan N wrote:
> Hi Friends,
>
> I need a macro to sort the below excel by client a
Subtotal ??
Sub SortAndSubTotalOnColumn4()
Cells(1).CurrentRegion.Select
Selection.Sort _
Key1:=Range("A2"), Order1:=xlAscending, _
Key2:=Range("B2"), Order2:=xlAscending, _
Header:=xlYes, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom, _
DataOpt
Hi Friends,
I need a macro to sort the below excel by client and patient in Ascending
order, and insert blank row between each client and Groos Assign column to
$.
Please help me to do this work by macro
Thanks,
N.Sundarvelan
--
-
Dear Friends,
I have one query regarding macro.
i want to record a macro for goal seek.
Attached reference sheet says following
Column A - my goal starts from 2009 for 16 years till 2024.
B - Accumulated amount equal to one row up for column E
C - goal seek result i.e investment amount, please ref
26 matches
Mail list logo
