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.
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 mmayank2...@gmail.com wrote:
plz replyyy
On Mon, Jun 1, 2009 at 7:13 AM, mayank khare mmayank2...@gmail.comwrote:
Hai,
I want to learn indepth excel
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
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 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
--~--~-~--~~~---~--~~
Dear Team,
Could any one suggest me to solve this task.
Thanks,
Sharma
On Mon, Jun 1, 2009 at 7:25 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi Dilip Sir,
Can you please look into this query.
Regards,
Harmeet
-- Forwarded message --
From: amrahs k
Hi,
See the attached solution. I used array formulas to identify which company
should be excluded.
regards!
2009/6/3 Sachin Shukla sachina...@gmail.com
Dear All,
Please help me on analysis of different senarion. details question and
sheet attached.
Thanks
Sachin Shukla
--
Fabio
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
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
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
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
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
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
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
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 schreiner_p...@att.net wrote:
the simplest approach would be to use a
worksheet Change Event like:
Option
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 trading.a...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent:
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
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
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
19 matches
Mail list logo
