e
> can help you better.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 1/26/10, TAlgo wrote:
> >
> > A2 =IF(A1="buy
+A2 being in Cell A2. Try uploading a sample file so that we
> can help you better.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 1
A2 =IF(A1="buy",(B1+A2),A2)
if A1 is buy then add value in (B1+A2) or else keep value of A2..
A3 = IF(A1="sell",(B1+A3,A3)
if A1 is sell then add value in (B1+A3) or else keep value of A3
cant get it work..above formula...
thanks
--
---
Hii..
I'm looking for a macro or condition statement which would do
following for me:
If cell A1 is "BUY" then run a macro automatically which will add
current value in cell B1 to cell A3
so everything theres a "BUY" in cell A1..macro will keep addiing B1
values in cell A3
and
If cell A1 is "SE
All,
I have multiple workbooks with unique names in one of my folder. Each
workbook has similar sheets and it contains pivot values.
I recorded the program from one of the workbook which selects the
fields i need.
Is there a way I can do this for all the workbooks in the folder
without opening
need real help
On Sep 17, 1:06 pm, Algo Trading wrote:
> All,
>
> I have a 'Master.xls' and multiple workbooks ( Posrep 1-2 to Posrep 9-16 ).
> Those multiple workbooks have data in one sheet ("Main").
>
> In each workbooks and sheet ("Main")
> If any cell in Column B contains " Project Meal Tot
On Sep 10, 9:15 am, Algo Trading wrote:
> Attached please see file which I found online. Sheet 1 has 'Specified
> Entries' which allows users to select FROM and TO dates.
>
> Another sheet " REquirements" I have raw data and would like to do the same
> thing but this time I have more columns to
All,
This is just my thought but have no idea how to proceed. Can someone
please provide a solution, I will really appreciate.
Not sure how to attach a spreadsheet by my data spreadsheet is
uploaded to File section known as DATA.XLSX.
Col A. contains dates ( 1-Jan to 16-Aug ) and Col B-K contai
I have a cell A1 in which I enter a number value everyday. I was
hoping some type of function or form in differet cell B1 so each time
A1 is updated it add up previous A1 value and show the cumulative.
Example:
this is the way I want B1 to add previous values when I enter value in
A1 manually eac
; Can you give some more background information, maybe the file so I can
> take
> a look at it?
>
> On 20 aug, 15:40, TAlgo wrote:
>
> > Hi,
>
> > I have a market data linked to excel through DDE link so prices are
> > updated real time.
>
> > Cell A
Hi,
I have a market data linked to excel through DDE link so prices are
updated real time.
Cell A5 contains last traded volume which updates whenever a trade is
done.
I would like to SUM/ADD all last trade volume in cell C5. Is there any
function or macro can help me to do this?
Thx in advance
On Aug 2, 12:41 pm, TAlgo wrote:
> Ayush,
>
> Thanks and appreciate your help in this matter.
>
> Just was little frustrating to search and find out that your topic
> was completely changed by someone.
>
> thx again,
>
> On Aug 2, 2:02 am, Ayush Jain wrote:
>
Ayush,
Thanks and appreciate your help in this matter.
Just was little frustrating to search and find out that your topic
was completely changed by someone.
thx again,
On Aug 2, 2:02 am, Ayush Jain wrote:
> Dear members,
>
> We have received concerns from few posters that there subject line
On Aug 1, 3:02 am, mageshwaran jayaraman wrote:
> Hi Guys,
>
> Need a small favour/suggestion.
> I've created an excel fail where I insert datas on daily basis and take a
> summary report at the end of the month.
> For a daily summary, I've used DATA > SUBTOTAL function, wherein I get the
> s
\MY Very Own Folder\test 1.xls"
>
> try again
>
> personally, I think #1 is the best solution.
> Although #2 SHOULD have worked too... unless you accidently
> changed the association to the 2003 version!
> (they're both called EXCEL.EXE !!!)
>
> Paul
>
&g
d hit the "Change" button.
> Now BROWSE to the C:\Program Files\Microsoft Office\Office12\EXCEL.EXE file
>
> 3) Uninstall Excel 2003 (I know, it may not be possible due to the need for
> testing,etc)
>
> hope this helps.
>
> Paul
>
> _
All,
I've scheduled a task to open my test.xlsm ( excel 2007 macro
enabled ) file everyday but when it opens automatically, it opens as a
2003 excel file and messes up few formulaes and charts which I have
created in 2007.
When I open test.xlsm directly it opens as a regular 2007 excel.
Any ide
All,
data on my workbook 'cricket.xlsx' is updated through a DDE link and
located under g:\ drive
I'm trying to link to same file from another machine so data can be
updated on both the workbooks at the same time.
my source file - 'G:\NT\Cricket.xlsx
Target - 'G:\NT\[Cricket.xlsx]Sheet1'!B3
I
To copy & paste cell content to thousands of cells:
1. Select and copy cell A1.
2. Type a cell address in the Name box, for this example, type A5000.
3. Press Shift+Enter to select the cells from A1:A5000.
4. To paste, press Enter.
--~--~-~--~~~---~--~~
--
To print a single Comment in cell:
1. Select a cell containing a Comment.
2. From the File menu, select Page Setup, and then click the Sheet
tab.
3. In the print area, insert the cell address.
4. From the Comments dropdown list, select At end of sheet and click
OK.
5. Click the Print icon
--~--~
To delete empty rows between data:
1. Select all columns containing data.
2. Click the Sort icon (either Ascending or Descending).
--~--~-~--~~~---~--~~
--
Some important links for exc
mean that it stopped "recognizing" range 3 and 4?
>
> What are the values you're testing?
> B1 =
> B2 =
> B3 =
> B4 =
>
> Paul
>
>
> From: TAlgo
> To: MS EXCEL AND VBA MACROS
> Sent: Tuesday, July 21, 2009 10:27
stopped "recognizing" range 3 and 4?
>
> What are the values you're testing?
> B1 =
> B2 =
> B3 =
> B4 =
>
> Paul
>
>
> From: TAlgo
> To: MS EXCEL AND VBA MACROS
> Sent: Tuesday, July 21, 2009 10:27:17 AM
> Subje
Trick to get serial number behind Date format
Select a cell and enter today date into the cell by pressing Ctrl+;
than press Ctrl+~.
Press Ctrl+~ again to restore the sheet to its normal appearance.
thx
On Jul 21, 11:18 am, Ayush wrote:
> Dear Members,
>
> Let us begin week # 29 quiz with the
Kamal,
Can you please forward the formula for standard exchange rate..thx
On Jul 19, 4:04 pm, kamal shah wrote:
> Are you looking for standard Exchange Rate or a variable?
> If so then u dont need macro for it. you can get it done with simple
> formula..
>
> let me know if u need it.
>
> kamal
hello,
I was successfully using the following code as entering orders to
trade commodity futures in to exchange.
Private Sub Worksheet_Calculate()
Const WS_RANGE As String = "B1" '<== change to suit
On Error GoTo ws_exit
If Range(WS_RANGE).Value = oldval Then Exit Sub 'value has not changed
oldv
rial there
> :http://www.iopus.com/guides/winscheduler.htm
> Regards.
> Daniel
>
>
>
>
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-
> > mac...@googlegroups.com] On Behalf Of TAlgo
> > Sent: vendredi 17 juillet 2
quot;.bat" file containing :
> cmd /c "c:\TrustedFolder\masterfile.xls"
> Hope this helps.
> Daniel
>
>
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-
> > mac...@googlegroups.com] On Behalf Of TAlgo
> >
Hello,
Something new for me so need some help :
I' would like to have a macro which will extract data automatically
and daily from multiple workbooks ( Source ) and copy to Master
workbook ( target ) located under same network drive.
Say around 5 pm EST macro should auto run and complete the a
got it..thanks guys
On Jul 16, 11:01 am, TAlgo wrote:
> Dilip.
>
> How do I use text to column feature of 07?
>
> On Jul 16, 10:36 am, "Daniel" wrote:
>
> > Hi.
> > Try :
>
> > Sub test()
> > Dim txt As String, Tabl
> > txt
l
>
>
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-
> > mac...@googlegroups.com] On Behalf Of TAlgo
> > Sent: jeudi 16 juillet 2009 15:06
> > To: MS EXCEL AND VBA MACROS
> > Subject: $$Excel-Macros$$ One Cell
uot;))
> Range("D1") = sFirstNumber
>
> sSecondNumber = Right(sInput, Len(sInput) - InStr(sInput, "at ") -
> Len("at ") + 1)
> sSecondNumber = Left(sSecondNumber, Len(sSecondNumber) - 1)
> Range("E1") = sSecondNumber
>
> Che
Dave, It works..thanks a lot
On Jul 15, 11:13 pm, Dave Bonallack wrote:
> Hi,
>
> You just need to find a unused cell near by, and use it as a recorder.
>
> If the unused cell is, say, E1, then your macro would look like this:
>
> Sub resetval_SCRUSH()
> Range("d1") = "0"
>
> Range("E1") = R
_ Sept. 15, down 504.48 at 10,917.51.
Hello,
I have above data in cell A1 ..I'm looking to separate Sept 15, Down,
504.48, 10917.51 in to different columns.
Any idea?
--~--~-~--~~~---~--~~
-
Hello,
A newbie here and I think this should be really easy for othersI
have a macro which reset cell value to "0" and I have created a text
box and assign this macro to it. So everytime I click that box it
resets D1 value to "0".
I just want to have a count the number of times macro -
RESET
Hello,
A newbie here and I think this should be really easy for othersI
have a macro which reset cell value to "0" and I have created a text
box and assign this macro to it. So everytime I click that box it
resets D1 value to "0".
I just want to have a count the number of times macro -
RESET
Hello,
I need some help in creating an user form or input screen in excel so
I can input two number manually...my code is as follows:
I need to create some type of input box for specifying range numbers
1) f Range(WS_RANGE).Value > 6465 And Range(WS_RANGE).Value < 6469
Then and
2) If Range(WS_RA
was able to figure it ouyt myself
On Jul 10, 9:02 am, TAlgo wrote:
> Hello,
>
> I've a quick question on an event Private Sub Worksheet_Calculate().
>
> I got Private Sub Worksheet_Calculate() running on Sheet1 which does
> few calculations and calls a macro.
>
>
Hello,
I've a quick question on an event Private Sub Worksheet_Calculate().
I got Private Sub Worksheet_Calculate() running on Sheet1 which does
few calculations and calls a macro.
Is it possible I can create another event in same worksheet Private
Sub Worksheet_Calculate() which would do anot
Hello,
I will try to explain this as much as possible.
I receive real time data ( Last Trade Price ) of soybean commodity
futures through DDE in to excel ( cell A1 ). During market hours A1
will keep updating every milliseconds or seconds.
My cell B1 ( =A1 ) will have same value as A1 and will up
ot;B2").Select
> ActiveCell.PasteSpecial xlPasteValues
> Range("B1").Value = Range("A1").Value
> Range("A1").Select
> End If
> Application.StatusBar = "Last run at " & Now()
> Else
> Application
a cell with
> the TIME of the last update?
> then, do the same thing but also record the date/time of the data record?
>
> ??
>
> Paul
>
>
> From: TAlgo
> To: MS EXCEL AND VBA MACROS
> Sent: Wednesday, June 3, 2009 12:50:00 PM
> Subject: $$E
. is it possible for your DDE update to also update a cell with
> the TIME of the last update?
> then, do the same thing but also record the date/time of the data record?
>
> ??
>
> Paul
>
>
> From: TAlgo
> To: MS EXCEL AND VBA MACROS
&
iveSheet.Cells(1, 1)
> End If
> End Sub
>
> hth
>
> Paul
>
>
> From: TAlgo
> To: MS EXCEL AND VBA MACROS
> Sent: Wednesday, June 3, 2009 10:47:37 AM
> Subject: $$Excel-Macros$$ Excel Macro - copying cell value as it changes
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
Jay, it defeats the purpose of using public forum if you sent
solutions to personal email. Post it here.
On May 29, 6:03 am, Jay wrote:
> I have sent your solution on your mail id.
>
> Pls check it.
>
> On May 29, 11:26 am, Prashanth Banneni wrote:
>
> > Hi All,
>
> > I have a issue with excel.
Guys,
trying to create a macro which will copy column A to column B. This is
simple
but only exception I m looking is macro should not copy any value = 0
I m trying this but no luck so far..any help will be greatly
appreciated..
Sub test_again()
If cell("a:a") > 0 Then
Sheets("sheet7
No file attached.
ankur kochar wrote:
> Hi,
>
> Sorry for attaching the password file. Please find here attached file for
> help on how to work in excel with macros when it is s
>
> On Thu, May 21, 2009 at 10:02 PM, Fabio Lemos wrote:
>
> > Your file has password... please attach a file without
Try this if this helps
Sub CopyPaste()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Name <> "JAN" Then
ws.Select
ws.Application.Run "Macro1"
End If
Next
End Sub
Sub Macro1()
Range("A2:B13").Select ' select all the data range
Selection.Copy
Sheets("Summary Sheet").Select
ActiveSheet.Paste
Still it asks for a password
On May 20, 11:05 am, H Upadhyay wrote:
> Hi Tariq
>
> Passwored.xla crack password, but there is some way that we know what is the
> password.
>
> Regards
> Harish Upadhyay
>
> On 5/18/09, tariq wrote:
>
>
>
> > hello mahesh,
>
> > this file password is : AABBBA
(Hons.),BCA
> 'Mobile: +91 9810929744
> 'dilipan...@gmail.com
> 'dilipan...@yahoo.com
> 'New Delhi - 110062
>
>
>
> On Mon, May 18, 2009 at 1:16 AM, TAlgo wrote:
>
> > I am trying to copy and past data in a cell from another cell in my
&g
Hello,
I need help in 2 macros. Any suggestions will be greatly appreciated.
thanks in advance.
1) Is it possible to run a macro automatically if certain cell value
changes?
e.g Cell A1 has a value which comes from a formula
and
1) Can I schedule a fixed time to run a macro but only on weekda
I am trying to copy and past data in a cell from another cell in my
workbook.
I then want to move down one cell each and every time I have pasted
the data.
Source Data always in Cell A1
target :
I would like to copy in B1
Tomorrow when I open my spreadsheet, I would like to copy new data
from
All,
I've just started learning vba with few books but need a help:
I receive the daily settlement data from external source for
different commodity products in excel
So I was thinking if I can write a macro which would grab that
settlement data for each day and put in new row.
So there will
54 matches
Mail list logo
