Hi Anton,
XL can almost do what you want, which may be sufficient for you.
If you want to be able to enter your grocery expenditure always in the same
cell, XL can accumulate those entries in another cell using VBA.
For example, You may enter your grocery expenditure always into A2, but the
a
I am trying to display a freeform shape on top of a label control. In
Excel 2002, I used an EMBED("Forms.label.1","") or EMBED("Forms.Image.
1","") control in a worksheet. Using that control, I used mouse_down
events to determine the point coordinates (ex. digitizing a picture of
a shape) and pu
Dear Anton
Please send the sample sheet. as you have to input the values in two
different cells to get the accumulation.
You cannt overwrite the cell and expect a cumulative figure
Please elaborate and if possible send the worksheet.
Regards
Jagjeet Singh
On Wed, Jun 23, 2010 at 11:52 PM, ant
If you are not using Dynamic Range then use simple Sum formula, Just
change range n column number
Sub SUM()
ActiveSheet.Select
ActiveCell.FormulaR1C1 = "=sum(R[-1]C:R[-22]C)"
Range("B23").Select
End Sub
On Jun 24, 7:58 am, Markkim wrote:
> Hi
>
> I have a set of data which I need to sum up bet
No, I think he wants the formatting present in Cell A3, but I don't think it
can be done within a formula.Dave.
Date: Wed, 23 Jun 2010 21:28:14 +0530
Subject: Re: $$Excel-Macros$$ PLS HELP
From: cs4...@gmail.com
To: excel-macros@googlegroups.com
Dear Darmesh,
Please elaborate i think you want
Hi
I have a set of data which I need to sum up between unknown range..
The following is the code I am using
Range("C:C").Find("Description", LookIn:=xlValues).Select
FBTFirstrow = ActiveCell.Offset(1, 0).Row
FBTlastrow = ActiveCell.End(xlDown).Row
ActiveCell.Value = "Total FBT Transfer to Fun
Hi Bob,
I think it will be difficult to stop Solver, once it starts its
iterations. The people that may best be able to help you would be one
of the old time MVPs, although the Microsoft site is now shut down and
I do not know how you would go about getting in touch with one of them
now.
Good luc
Hi,
I am looking for a relatively simple macro (that I am not capable of
doing) that would copy and paste all "pages" contained within the URL
http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1
- Each page contains 50 records.
- There are close to 19,000 records.
Thanks in ad
Dear Group,
I am constructing a single entry accounting spreadsheet in excel. i
would like to input numbers for, say grocery expenses, in a cell of
fixed location. when I buy more groceries i would like to type in the
new expense in the same cell so that the output of that cell is the
cumulative to
Dear Anil,
MS word did not have pivot table function , but you can use them by
insert excel object and use pivot table same as Excel.
2010/6/23 Anil Saxena
> Dear Sir / Mam,
>
>
> Do the create the excel pivot table in to MS world without copy past and
> show the example ?
>
> --
>
> --
Dear Darmesh,
Please elaborate i think you want it as i am sending i am sending u a
attachment.
Thanks,
Chandrabhan Singh
On Wed, Jun 23, 2010 at 12:31 PM, Dharmesh Shah wrote:
>
>
>
>
> Dear group
>
> Please help in attached excel file.
>
> Regards
> Dharmesh Shah
>
>
>
> --
>
> ---
Assign the output to a variable and paste in excel using the variable. I had
the same issue with russian chr and it worked.
Regards,
Roopesh Kapur
Sent from my BlackBerry® smartphone from !DEA
-Original Message-
From: taquito
Sender: excel-macros@googlegroups.com
Date: Wed, 23 Jun 2010
Hi Regina,
The problem seems to be that XL has dropped off the leading zeros, so sometimes
your data is 6 characters long, and sometimes just 5.
When the data is 6 characters long, you need MID(E2,1,4)
But when the data is only 5 characters long, you need MID(E2,1,3)
(Since you aren't using 2
Hi,
I am trying to pull data from Oracle using ADOconnection.
I was able to connect to Oracle, pull some data, and pasted into
worksheets, but every Japanese characters were garbled like "??".
I appreciate if anyone can help.
I think my Excel uses "shift-jis" character set while Oracle data
Dear group
Please help in attached excel file.
Regards
Dharmesh Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Link
Thanks David.
Please mail the file to me at
jagjeet.si...@jcb.com
mark a copy to
jagjeetgul...@gmail.com
On Jun 23, 5:08 am, who wrote:
> Hello,
>
> I have a file that aligns a trial balance by branch, which I think
> will come very close to what you want. I think it can be adapted so
> th
Dear Sir / Mam,
Do the create the excel pivot table in to MS world without copy past and
show the example ?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twi
17 matches
Mail list logo
