Hi Harmeet,
Please find the attached sample workbook that contains a simple query for my
project.
Thanx in advance.
Regards,
Sharma
On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote:
> Hi,
>
> Please see attached file.
>
> On Wed, May 6, 2009 at 5:53 PM, amrahs k wrote:
>
>> Hi Team,
>>
Yogendra,
To get back the original file there is a Software already installed in the
Office - just go to - Programs- Microsoft office - Microsoft office tools -
Microsoft application recovery tools then wait & see
On Wed, May 13, 2009 at 12:23 PM, Yogendra Joshi wrote:
> Dear All,
>
> I am get
Hi Andy
thank you for reply & sorry for small delay...
I have range of data C1:E10 and A1:A10 each cell got drop down list
with values: "Yes" and "No". for example i change values in A1, A4 and
A7 to "No" and i don't want the corresponding rows C1:E1, C4:E4 and
C7:E7 were taken into average calc
Dear,
Use the following formatting options with either concatenate or "&"
=concatenate(TEXT(A1,"DD/MM/ h:mm:ss AM/PM"), " ",B1)
Or
=TEXT(A1,"DD/MM/ h:mm:ss AM/PM")& " "&B1
CA_logo_icai Small1
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba
Hi,
Please find the attached workbook with the solution. Consider the Cell A1
and watch the Conditional Formatting logics.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, May 6, 2009 at 5:04 PM,
Any guy here tried to build a COM or .NET library for EXCEL?
Some calculation takes huge amount of time in VBA, so i am thinking using
C++ or C# to do the calculation and VBA just calls this add-in class to do
the job and get the result .
On Thu, May 7, 2009 at 6:42 PM, Ajit Navre wrote:
>
>
Hi Harmeet,
I have attached one sample workbook that contains a query for data
validation.
I just need a macro for the same.
Thanks for your help.
Regards,
Sharma
On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote:
> Hi,
>
> Please see attached file.
>
> On Wed, May 6, 2009 at 5:53 PM, am
Hi,
following problem is causing me sleepless nights:
I have got a table containing a list of patents. I would like to
search for specific terms/words in the abstracts of the patents and to
mark them by changing their color. I do not want to change the color
of the whole cell containing the speci
I am talking about the format cells command. If you select a cell or
cells and right click you will see a format cell option. Select text
and your problem may be solved.
On May 12, 10:29 am, "2008ra...@gmail.com" <2008ra...@gmail.com>
wrote:
> i was try the cell text format.but that value is chan
Hi
You can try this.
Column A Column B Column C
5/13/2009 19:33 ABC =CONCATENATE(TEXT(A1,"m/d/ hh:mm:ss am/pm"),"
",B1)
Result would be : 5/13/2009 07:33:00 PM ABC
Regards
Rakesh
On May 12, 12:57 pm, jamadagnira...@gmail.com wrote:
> Hello,
>
> I have a proble
Hi Damian,
You can attach the worksheet with the reply email.. or directly send at
aind...@gmail.com
Regards,
Andy
On Wed, May 13, 2009 at 6:35 PM, Damian wrote:
>
> Hi Andy
>
> thank you for reply & sorry for small delay...
>
> I have range of data C1:E10 and A1:A10 each cell got drop down li
You could use the following piece of code:
With Cell(1,1).Characters(Start:=6, Length:=3).Font
.FontStyle = "Bold"
.Color = -16776961
End With
Where Start is the first character position of the word you want to change,
and Length is the word length.
If you have some trouble with t
Its a smart trick and a quick solution too.
m i correct Dilip Sir.
On Tue, May 12, 2009 at 9:25 PM, zheng yu wrote:
> hahahaha...Ctrl+H again..hehe ,well it comes in handy:-)
>
> On Tue, May 12, 2009 at 4:54 PM, Dilip Pandey wrote:
>
>> Hi
>>
>> press Ctrl +H and replace "total charge:" with "".
Thank you in advance. I searched many sites and threads. I am most
likely missing something very easy but I am just lost at this point.
I have en Excel file that contains a "save" button. The button will
help the user execute an auto save to a folder along with a file name
(based on the invoic
Hey Rakesh,
Thanks It Works,
Thanks
Regards,
Jitendra
On Wed, May 13, 2009 at 7:38 PM, Rakesh Sharma wrote:
>
> Hi
>
> You can try this.
>
> Column A Column B Column C
> 5/13/2009 19:33 ABC =CONCATENATE(TEXT(A1,"m/d/ hh:mm:ss am/pm"),"
> ",B1)
>
> Result would be
hi all newbie here, need some help
so i have a list of file names in cells
i.e.
b4 "aaa01"
b5 "bbb02"
b6 "ccc09"
.
.
.
how can i loop thur those cells, get there values and do a search on a
local computer folder?
i.e.
c:\from files
then copy files inside the foler ( i dont need zzz000
I work with Excel spreadsheets that are imported from another database
application.
After importing the data into Excel I run 3 separate macros to format
and sort the data that I want to keep and work with.
Currently I run the three macros one at a time because I do not know
how to define a variab
Hi Sharma,
First you have to format all the necessary cells as 'Text', otherwise the "0"
is lost.
Then try putting this into data validation (Custom, Formula) of A3:
=AND(ISNUMBER(VALUE(A3)),LEN(A3)=10,LEFT(A3,1)="0")
Copy validation to necessary cells.
Hope this helps.
Regards - Dave
D
do u want to average where coresponding cell is " marked as "yes"?
Paul
On Wed, May 13, 2009 at 5:05 PM, Damian wrote:
>
> Hi Andy
>
> thank you for reply & sorry for small delay...
>
> I have range of data C1:E10 and A1:A10 each cell got drop down list
> with values: "Yes" and "No". for exampl
I think, u need to format the cell in Number Format. Pls make decimal place
as 0. U should
get the result.
Paul
On Wed, May 13, 2009 at 7:26 PM, larry wrote:
>
> I am talking about the format cells command. If you select a cell or
> cells and right click you will see a format cell option. Selec
20 matches
Mail list logo