i need to check on date and time...
On Jun 3, 1:41 pm, Paul Schreiner wrote:
> I think I may have something...
> but there's a new wrinkle...
> I know A1 is being "updated" from an external source.
> let's say it updates every minute...
> but what if the value hasn't CHANGED since the last updat
Hello there,
You recently requested an email subscription to Excel-Matic. We can't wait
to send the updates you want via email, so please click the following link
to activate your subscription immediately:
http://feedburner.google.com/fb/a/mailconfirm?k=HKqbLBg-2ej7T2GYlu75R_fyfF0
(If the l
Hi All,
Is there anyway to have checkboxes in a cell and then be able to
autofilter based on which cells have been checked?
Ex. Creating a task list in column A and put checkboxes in column B,
when tasks are completed they are checked off. Want to see what tasks
are left so I would like to auto
Basically value has to change for macro to trigger and copy and paste
to another cellthere is no fix time when A1 (last traded price )
will update..normally its every few seconds.
So A1 will only update ( change price ) if there is new price
otherwise it will remain the same and macro wo
I think I may have something...
but there's a new wrinkle...
I know A1 is being "updated" from an external source.
let's say it updates every minute...
but what if the value hasn't CHANGED since the last update?
let's say for the last 10 minutes, the values were:
1,2,5,5,5,6,7,5,5,3
Would it be a
You're right.
technically, A1 doesn't change.
the VALUE of A1 changes, but the formula used to calculate the value does not.
I'll have to look into it...
paul
From: TAlgo
To: MS EXCEL AND VBA MACROS
Sent: Wednesday, June 3, 2009 12:50:00 PM
Subject: $$Excel-
Paul, it works but my value in cell A1 is derived from external
sources via DDE. you think worksheet event does not recognize cell
value if its DDE?
On Jun 3, 12:32 pm, Paul Schreiner wrote:
> the simplest approach would be to use a
> worksheet Change Event like:
>
> Option Explicit
> Private Su
the simplest approach would be to use a
worksheet Change Event like:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim X
If (Target.Address = "$A$1") Then
For X = 20 To 2 Step -1
ActiveSheet.Cells(X, 2) = ActiveSheet.Cells(X - 1, 2)
Next X
Hello All,
I'm stuck on this one. Any help will be greatly appreciated.
Let me see if I get this correct. I' have a cell - A1 which receives
'LAST Traded Price ' of a stock through DDE so cell A1 keeps changing
dynamically during trading session.
I need a macro which will copy value from A1 and
We have to be careful in "assuming" that the terminology you are using
means the same for us as it does for you.
To ME, what you said is that you want to select one of the cells in Column A
and have a list of data in column B to change.
there are many, many questions that arise.
Where do you get
Dear Mr. Sharma,
I have already answered this and replied back with a query to you. Can you
please go back and check out the chain email on this topic.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On
Please check out the attachment.
Regards,
Mudassar Ramzan
- Original Message -
From: Akshu Bhagat
To: excel-macros@googlegroups.com
Sent: Wednesday, June 03, 2009 3:46 PM
Subject: $$Excel-Macros$$ Urgent help to split the column values
Hi everyone,
I want each name of
Hello everyone,
I am facing a problem and would appreciate your advise on the same.
I have an excel file in which i have put Data Validation - List in one
column (for example - Col A). Now, i want another list in the other column
(for example 0 Col B) to be refreshed automatically whenever the se
Scenario: Each column heading is an hour in a day (ex: hr 1, hr 2, hr
3, etc...up to 20 hr.)
Each row is a production line (1 thruough 17)
These hour 'blocks' are linked to a master schedule which populates
each hour and line with an item number. Between jobs, one hour block
is left blank (to all
Hi,
See the attached solution. I used array formulas to identify which company
should be excluded.
regards!
2009/6/3 Sachin Shukla
> Dear All,
>
> Please help me on analysis of different senarion. details question and
> sheet attached.
>
>
> Thanks
>
> Sachin Shukla
>
> >
>
--
Fabio Lemos
e
Dear Team,
Could any one suggest me to solve this task.
Thanks,
Sharma
On Mon, Jun 1, 2009 at 7:25 PM, Harmeet Singh wrote:
> Hi Dilip Sir,
>
> Can you please look into this query.
>
> Regards,
> Harmeet
>
> -- Forwarded message --
> From: amrahs k
> Date: Sat, May 30, 2009 at
Hi everyone,
I want each name of the company separated by comma (,) in different columns.
Attached herewith is the sample file
-->"Anything less than Extra Ordinary is shear waste of time"
Regards,
Akshu Bhagat
--~--~-~--~~~---~--~~
-
Hi,
Please check if the attached solution suits your need
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sachin Shukla
Sent: 03 June 2009 10:43 am
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help requir
Hi Talgo,
Thankss for the solution, below code does not work. I want to copy
all the visible cells which are present in A1, B1 and C1 sheet into Jan sheet.
Note: here I want to add all the data from A1, B1 and C1 other that the 1st row
appearing in all 3 sheets as it is the
Hi Mayank,
please look into the site.
http://www.vbamacros.blogspot.com
regards
Hari Kumar
On Mon, Jun 1, 2009 at 7:16 AM, mayank khare wrote:
> plz replyyy
>
> On Mon, Jun 1, 2009 at 7:13 AM, mayank khare wrote:
>
>> Hai,
>> I want to learn indepth excel macros.
>> Plz tell the resource to l
Hi,
Take a look at the attached.
Regards - Dave.
Date: Wed, 3 Jun 2009 10:43:07 +0530
Subject: $$Excel-Macros$$ Help required
From: sachina...@gmail.com
To: excel-macros@googlegroups.com
Dear All,
Please help me on analysis of different senarion. details question and sheet
attached.
21 matches
Mail list logo
