Try this see if it helps
Sub A()
ThisWorkbook.Worksheets("Sheet2").Select
Dim LastRowTotal As Integer
Dim LastRowData As Integer
LastRowTotal = Range("B65536").End(xlUp).Row
LastRowData = LastRowTotal - 1
ThisWorkbook.Worksheets("Sheet2").Select
Range(Cells(2, 1), Cells(LastRowD
Sir,
As per my interpretation your output is in Attached file.
Regards, Rahul Gandhi
+91-9711772297
On Thu, Dec 16, 2010 at 11:06 PM, santanu_ca wrote:
> I want to Add two digit or multiply as this way.
>
> Column A Column B
> Rs. 5.00Rs. 10.00 = Can I sum two cells by
Do you mean the cell value will have a numeric value preceded by "Rs.
"? If so, something like this should work:
Rs. 5 is in cell A2. Rs. 10 is in cell B2.
Operand1Operand2Sum
formula
Result
Rs. 5 Rs. 10 =RIGHT(A2,LEN(A2)-find(" ",A2))+RIGHT(B2,LEN(B2)-find("
",B2)) = 15
Hi,
After a week of trying, I found the following (fso) code to be useful:
Application.FileDialog(msoFileDialogOpen).Show
sFullName =
Application.FileDialog(msoFileDialogOpen).SelectedItems(1)
However, it does not give me access to the directory folder/path and
filename. In the Macro help, I man
Thanks for the info. Yes it works!
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of dailem
Sent: Thursday, December 16, 2010 5:25 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Automatic Update to formula after select
I'm not sure of having understood,
try:
Sub MFR_Textbox()
Dim Wks As Worksheet
Dim rngSrch As Range
Dim rngFind As Worksheet
Dim rngFound As Range
Dim oShp As Shape
Dim oTotalRng As Variant
Dim oTxtRng As Variant
Dim oTxtRng1 As Variant
Dim oTxtRng2 As Variant
This macro works fine for copying and pasting totals:
Sub Copy_Paste_Totals()
ThisWorkbook.Worksheets("Sheet2").Select
Dim LastRowTotal As Integer
ThisWorkbook.Worksheets("Sheet2").Select
LastRowTotal = Range("B65536").End(xlUp).Row
ThisWorkbook.Worksheets("Sheet2").Select
In th cells do u have formatting or value like "Rs. 5.00"
If it is the Formatting then u can do directly or if it is the value
u need use "Find" formula
On Thu, Dec 16, 2010 at 11:06 PM, santanu_ca wrote:
> I want to Add two digit or multiply as this way.
>
> Column A Column B
> Rs. 5.00
Have u tried using Vlookup?
On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain wrote:
> Hi All,
> Please help me in finding the missing entries from the below data.
> ListA ListB
> 1 1
> 2 3
> 3 5
> 4
> 5
> Regards
> Vebhav Ja
Sir,
I don't know your expertise level in excel, the only one solution I Can give
you with the help of formulas only. Not with the macros.
Please find attached for your reference.
Regards, Rahul Gandhi
+91-9711772297
On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain wrote:
> Hi All,
>
> Please
check the attachment
On Thu, Dec 16, 2010 at 11:06 PM, santanu_ca wrote:
> I want to Add two digit or multiply as this way.
>
> Column A Column B
> Rs. 5.00Rs. 10.00 = Can I sum two cells by formula ?
> Rs. 5.00Rs. 10.00 = Can I multiply Two Cells by for
check the attachment
On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain wrote:
> Hi All,
>
> Please help me in finding the missing entries from the below data.
>
> ListAListB
> 1 1
> 2 3
> 3 5
> 4
> 5
>
> Regards
> Vebhav Jai
There are several different ways to approach this, but without using
VBA I would suggest
the following:
1) create your category drop-down list in a cell using the validation
tool in excel.
2) in a part of your worksheet that won't be used create a list of all
your budget categories
that are in yo
Dear All,
Attached is the sample data file, I am looking for vba code to get the same
automated.
Details are mentioned in the attached file, looking forward for your reply.
Please can you also share details if I want to customize the macro and use
if for more data.
Thanks
--
-
I want to Add two digit or multiply as this way.
Column A Column B
Rs. 5.00Rs. 10.00 = Can I sum two cells by formula ?
Rs. 5.00Rs. 10.00 = Can I multiply Two Cells by formula ?
--
hey guys,
need some help here.
1. how can i get to know if a specific cell has formula or normal value?
2. can we unzip folder or file using excel maco?
3. if a specific cell has formula whose value is lets say "shinde" how can i
find it.
i.e lets say A1 has value as "shinde"(its not fomula
Hello,
I have attached sample workbook I need a macro to do this task. In
*Sheet1*I got Input Data based on
*column A* I need to separate worksheets as shown in workbook.
Thank you.
Chandra Shekar
--
--
Some import
hi
Thanks 4 ur reply,it was a sample what i required, in the actual data
its around 300 items in it
the data will never in the order.Formula given under is giving a
correct answer in my actual database, but it have auto filling problem
=SUMIF(R8:R96,a12,(X8:X96))
=SUMIF(R8:R96,a13,(X8:X96))
=SUMIF
Hi All,
Please help me in finding the missing entries from the below data.
ListAListB
1 1
2 3
3 5
4
5
Regards
Vebhav Jain
--
--
Some impor
19 matches
Mail list logo