Thanks Aindril !!! its working
--- On Sat, 4/4/09, Aindril De wrote:
From: Aindril De
Subject: $$Excel-Macros$$ Re: urgent help req.
To: excel-macros@googlegroups.com
Date: Saturday, 4 April, 2009, 9:33 AM
Hi Sashank
if u enter the value in cell A1 and want to see the decimal valu
Hi Sashank
if u enter the value in cell A1 and want to see the decimal value in A2 then
just type =A1/100 in the cell A2.
Regards,
Andy
On Sat, Apr 4, 2009 at 1:46 AM, shashank bhosle <
catchshashankbho...@yahoo.co.in> wrote:
> HI All,
> I am having a Excel file where i need to imput the Nume
thanks
-Original Message-
From: Tom Jeffries
Sent: Friday, April 03, 2009 10:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Convert excel file to .txt
Attached is an updated version that handles the alphanumeric data in column
2 correctly.
Tom
On Thu, Apr 2, 2009
HI All,
I am having a Excel file where i need to imput the Numerical Value.
e.g 12356
but i want the same cell or adjacent cell should reflect as 123.56 i.e decimal
should move two places
Advance thanks
Regards, U r s...
Shashank
9975620752
Never Born Never Die
Just visited the Earth for
I have an Macro Which Merges Different Sheets in to a Master Sheet..
But i
have a Problem with the Macro that its not ,Merging all the Sheets
and
Complete Data Range.. So if any One Could help me.. it would be
Greatly
Appreciated
My Macro as Follows:
Sub CopyRangeFromMultiWorksheets()
Dim
I have an Macro Which Merges Different Sheets in to a Master Sheet..
But i
have a Problem with the Macro that its not ,Merging all the Sheets
and
Complete Data Range.. So if any One Could help me.. it would be
Greatly
Appreciated
My Macro as Follows:
Sub CopyRangeFromMultiWorksheets()
Dim
I had not known you can add wild cards to vlookups. That is really
cool. One note of caution is that I got false positives when entering
the name George. The method stated above will display results upon
the first match, which in this case was "George, Bush" and not
"George" as in Jefferson. T
i have some cv that has clubbed more than 100 cv in word. want to
convert list from word to excel
any help?? :(
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Exc
Hi,
Pls find the attached solution. The trick is to use wild card
character. The limitation is that the text should not be repeated in
any other cell or else the result may not be as per expectation.
2009/4/3 hari :
> Hi All,
>
>
>
> I would require the output “city name from sheet “Data” on i
Thanks - did use and the solution worked nicely.
Norman May wrote:
> Try using the Subtotal function.
>
> Norman
>
> On Thu, Apr 2, 2009 at 12:43 PM, Dave wrote:
>
> >
> > I am currently using a SumIF function that works fine, hoever, I
> > applied a series of custom views with filtered row item
Hi All,
I would require the output "city name from sheet "Data" on input of First
Name in the sheet"require information"
I tried vlookup which matches for exact search. Can anyone please suggest
how to use vlookup after using search or finding a string?
Enclosed please find the file.
R
Hi Puneet,
If there is no requirement of calculation in blank cells, just remove them.
Or probably try out exporting the data to access and work.
Regards
Hari Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of PUNEET NASA
S
Attached is an updated version that handles the alphanumeric data in column
2 correctly.
Tom
On Thu, Apr 2, 2009 at 7:56 PM, Cesar Delanoval wrote:
> Tom, the formula works great except for column 2. On this column I have
> data that is alpha numeric, The data could be from 1 digit up to 13 d
I am having a database which contains more than 5 lacs row and 35 cloumn . And
the file is taking 50 mb. when i work on that data my pc hang. Can body suggest
me how i stop my pc to hang and i can do my work easily.
according to my work i have to incerase the data upto 8 lacs lines
Advance t
Dear Guru,
I think this is possible.
Try the below steps :
1. Open your spreadsheet say A1
2. Open the first file in your folder (say X1 to X50)
3. In spreadheet A1,, in a specified cell next to the name of the file,
put a formula by typing = and go to cell T100 in file X1
Hi Gurumurty Sastry,
I have done the same thing as this before.
dim wk as workbook
For i=1 to number of files
set wk=workbooks.open (Filename:= Name of the file)
wk.range("T100").copy destination
:=workbooks("Spreadsheet").range(whatever you want)
Next i
Hope this can help
Kin
Can u tell me how can i reduce the size of data I have a excel file which
contain 5 lacs data And i m not able to work in that data due to hanging
problem. Can u tell me alternate way.
Ur urgent help req.
Regards, U r s...
PUNEET NASA
9971987033
¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)
thanks,
On Mon, Jan 19, 2009 at 8:23 AM, shay shay wrote:
> please mail ur file.
>
> On Sat, Jan 17, 2009 at 8:08 PM, Rabindra Thapa
> wrote:
>
>> i protected by password on my working files but after long time when i
>> try to open it , i can't please advise me how to open my files.
>>
>>
>
>
See attached file
Hope that helps
On Fri, Apr 3, 2009 at 12:07 PM, gurumurthy sastry Kondury <
gurumurthy.sas...@gmail.com> wrote:
> Hi All,
>
> Please help me with the below query.
>
> Suppose I have a folder Named "FOLDER". This folder has 50 Files. I have
> been maintaining a *Spreadsheet* wit
Hi All,
Please help me with the below query.
Suppose I have a folder Named "FOLDER". This folder has 50 Files. I have
been maintaining a *Spreadsheet* with the names of all these files.
Now I want to pull the data in the Cell 'T100' of each and every file to the
*spreadsheet* against each respect
20 matches
Mail list logo
