Hi Taigo,
You can use text to columns command from Data tab.
Data--->text to columns>Delimited-->comma-->enter.
Hope this will help you friend.
Mahesh
On Thu, Jul 16, 2009 at 6:36 PM, TAlgo wrote:
>
> _ Sept. 15, down 504.48 at 10,917.51.
>
>
>
>
> Hello,
>
> I have above data in cell A1
Hi Dili,
Gud Morning,
I using the same file which is already attached.
On Thu, Jul 16, 2009 at 5:42 PM, Dilip Pandey wrote:
> Dear Mahesh,
>
> It will be good to explain, if you can share the test worksheet with us
> (having relevant data portion).
>
> Thanks
> DILipandey (Back from Holiday
I would be interested if there is simpler method to perform your task.
Meanwhile you can use the following function.
'
Function StrSubTotal(r As Range) As String
Dim i As Integer
i = 1
While r.Cells(i, 1).Height = 0
i = i + 1
Wend
I am getting the following error on the ** line in the below code
Error:
Application-defined or object-defined error
Function test()
Dim x, y, MyArray
ReDim MyArray(1 To 10, 1 To 5)
For x = 1 To 10
For y = 1 To 2
If x > y Then MyArray(x, y) = x & "," & y
MyArray(x, 4) = MyArr
Guys,
I am not well versed in vba, more just excel functions. So I recorded
a macro where I typed in the if then statement shown below, and I have
a bunch of zeros that come up as a result. I have two questions:
1. is there a cleaner way to write the if then statement in vba?
2. how can i dele
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 = [A1]
> > txt = Application.Substitute(txt, "_", "")
> > txt = Applica
Hi Ashish,
Thanks! for the reply. But in this case, anyone can stop the Track Changes.
This won't work as a hidden kind of thing for others.
The purpose behind this is, that whenever anyone make changes on the
worksheet(which is in shared mode) and save it, then the changes should be
highlighted
to basically help with proramming in vb excel to do things such as:
1. create if then statement where the =if(file\1.xls\sheet1!a1=
something, 1,0)
where the filename is dynamic, its set to month-date-xls and
i want to automate the filiing name.
2. create a dynamic median(a1:b1) equat
Find replace " Down " with "xDownx"
Find replace " at " with "x"
Then delimit the columns using "x" as the character. I have used this
method hundreds of times. Basically you just Find Replace everything
until it can be delimited properly.
On Jul 16, 9:06 am, TAlgo wrote:
> _ Sept. 15, down
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 = [A1]
> txt = Application.Substitute(txt, "_", "")
> txt = Application.Substitute(txt, ",", "")
> txt = Left(txt, Len(txt) - 1)
> txt = Right(txt,
Dear All,
I need some ideas from you experts.
I need to design a financial reporting package. I can download the
trial balace from SAP in excel format after monthly closing and
accounts have unique GL numbers , I want a package to be created where
I need to get all reports populated immediately af
Hi.
Try :
Sub test()
Dim txt As String, Tabl
txt = [A1]
txt = Application.Substitute(txt, "_", "")
txt = Application.Substitute(txt, ",", "")
txt = Left(txt, Len(txt) - 1)
txt = Right(txt, Len(txt) - 1)
Tabl = Split(txt, " ")
[B1] = Tabl(0) & " " & Tabl(1)
[C1] = Tabl(2)
[D1] = Tabl(3) * 1
[E1] =
Awesome..you da man...Thanks
On Jul 16, 10:16 am, Thierry wrote:
> You can use some fancy string manipulation. I got this to work:
>
> 'input is "_ Sept. 15, down 504.48 at 10,917.51." in cell A1
>
> Dim sInput, sDate, sDown, sFirstNumber, sSecondNumber As String
>
> sInput = Range(
Hi,
If you have the same data type, huge in size, then you should use Text - To
- Column feature of Ms-Excel. if not then a combination of nested functions
can be developed
Thanks & Regards,
DILipandey (Back from HOlidays)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
di
You can use some fancy string manipulation. I got this to work:
'input is "_ Sept. 15, down 504.48 at 10,917.51." in cell A1
Dim sInput, sDate, sDown, sFirstNumber, sSecondNumber As String
sInput = Range("A1")
sDate = Left(sInput, InStr(sInput, ",") - 1)
sDate = Right(sDate
Thanks Dilip and everyone for solving the issue.
Appreciate all your knowledge !!!
On Jul 16, 2:29 pm, Dilip Pandey wrote:
> Hi Ayush,
>
> Query raised by Suresh has been answered. Thanks.
>
> Thanks & Best Regards,
> DILipandey (Back from Holidays)
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Ho
Hello everyone
I would like to know if it is possible to query a webserver and store
the results directly into a variable instead dumping the data into a
range of a worksheet.
Here is the code I have now:
'query the webserver and dump the results onto the
"Results" sheet
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
Hi All,
This formula is working fine, But when i apply this formula to a very large
data. It is not showing accurately.
And this formula tells that it will look into only a particular cell. But i
need some formula where it should search for all cells in a particular
column.
On Thu, Jul 16, 2009 a
hI
Can we look for fist column in **1**))>> vlookup(e3,r4:y4,1,0)
Regards
manoj
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Dilip Pandey
Sent: Thursday, July 16, 2009 12:47 PM
To: excel-macros@googlegroups.com
Subject
_ 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 fnd's
if some budy looking job for MIS Profile.
Can apply.
( Note : If group owner or member do not want this type of mail in future
plz let me konw.)
Company Information
Mercer is a leading global provider of consulting, outsourcing and
investment services, with more than 25,000 clients wo
HI EVERYBODY
I CANT UNDERSTAND THE STEPS OF VLOOKUP FORMULA
PLEASE SOLVE IN ATTACHED FILE
VIKAS
On Thu, Jul 16, 2009 at 5:03 PM, Dilip Pandey wrote:
> Hey Ashish...
>
> Thanks a TON...!!!
>
> Remeber..>> "Everyone is learning here.. including me as well"..!!
>
> Best Regards,
> DILipandey (Ba
Savio,
I am not sure if I understand the problem completely. Do you want excel to
activate www.google.com I need to know specifically what the address of the
website you are wanting excel to switch to. Also is the yahoo and google
windows opened as tabs or New windows?
Regards,
Mog
On Thu, J
Thanks Daniel
On Thu, Jul 16, 2009 at 7:12 AM, Daniel wrote:
> Right click on the project name, choose VBAProject properties, protection
> tab and enter a password.
>
> A rather weak protection at least for versions prior to XL2007.
>
> HTH
>
> Daniel
>
>
>
> *From:* excel-macros@googlegroups.c
Everything's possible.
The main problem I see is when the macro should fire (I'm guessing it
should start automatically and only after the complete entry). So is
there a way to discern if you've already finished entering data in the
row?
So basically I would make a sub Worksheet_Change and every t
Use check boxes instead of option buttons.
Regards.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sachin Shukla
Sent: jeudi 16 juillet 2009 11:41
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Multiple Option in Box
Dear All,
Right click on the project name, choose VBAProject properties, protection
tab and enter a password.
A rather weak protection at least for versions prior to XL2007.
HTH
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of obahor o
Sent: mercredi 15 ju
Dear Mahesh,
It will be good to explain, if you can share the test worksheet with us
(having relevant data portion).
Thanks
DILipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On T
Yes the workbook is already open. Supposing i have 2 browsers open as
well say one with google and the other with yahoo, i want to switch
the active window from the excel spreadsheet to the browser with
google as the open page.
Ive got the following code however i dont know how to edit it to make
Savio do you just need to open an internet explorer window, and do you need
the code in an excel workbook that is already opened.
On Thu, Jul 16, 2009 at 5:50 AM, Savio wrote:
>
> Hi
>
> I'm trying to write a code that will use VB to switch from an open
> excel spreadsheet to an open internet ex
hi Dilip,
I am using Excel 2007.
On Thu, Jul 16, 2009 at 5:10 PM, Mahesh wrote:
> Hi Dilip,
>
> But when i pressed up arrow the selection automatical removed for the
> sheet.
>
> Rgds,
> Mahender Bisht
>
> On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey wrote:
>
>> Hi Mahesh,
>>
>> now do Up
Hi Dilip,
But when i pressed up arrow the selection automatical removed for the
sheet.
Rgds,
Mahender Bisht
On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey wrote:
> Hi Mahesh,
>
> now do UpArrow -> means press up arrow key of your keyboard and press CTRL
> + Enter.
> For your convienience, enti
I required when i filter, the filtered row should be display on other
column.
On Thu, Jul 16, 2009 at 1:19 PM, Rabindra Thapa wrote:
> Thank for your kind information.
>
> Have a good day.
>
> On Wed, Jul 15, 2009 at 4:51 PM, Naveen Sharma
> wrote:
>
>> Hi Rabindara,
>>
>> Solution is attach
Hey Ashish...
Thanks a TON...!!!
Remeber..>> "Everyone is learning here.. including me as well"..!!
Best Regards,
DILipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Jul 16,
Hi
I'm trying to write a code that will use VB to switch from an open
excel spreadsheet to an open internet explorer window.
Could you help me out?
Thanks
--~--~-~--~~~---~--~~
--
So
Hi Mahesh,
now do UpArrow -> means press up arrow key of your keyboard and press CTRL +
Enter.
For your convienience, entire process is explained below:-
Select the data, leaving headings
Press F5
Press Alt + s
Press k
Press Enter
Press Up Arrow
Press Ctrl + Enter
Thanks & Best Regards,
DILipand
Suresh
Key in this formula, this will serve. Unable to upload xls from my end.
Please read alphabets as columns. *Sheet 1* ** ** *C* *D* *E* *F* Name
Data Date No. Su 12 01/01/1999 123 gu 22 02/02/1999 124 gg 33 03/03/2000 125
*Sheet 2* ** ** ** ** *C* *D* *E* *F* *G* *H* Name Data Date
Thank for your kind information.
Have a good day.
On Wed, Jul 15, 2009 at 4:51 PM, Naveen Sharma wrote:
> Hi Rabindara,
>
> Solution is attached. Please have a look.
>
> Naveen Sharma
>
>
>
> On 7/15/09, Rabindra Thapa wrote:
>>
>> Hello Guys,
>>
>> can somebody help me on attach file.
>> --
>>
Hi Dilip,
What do u mean by "now do UpArrow" , unable to understand.
Rgds,
Mahender Bisht
On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey wrote:
> *Dear Mahesh,*
>
> According to me, the best way is to follow the below method:-
>
> Select the blank region (cells), right below the data headings.
Dilipji
Even though the solution to this problem was not requested by me, I must
tell you that just seeing the solutions you and a few others so regularly
provide have helped me understand Excel a lot more.
Thanks a lot for your contributions, Dilipji and many others who help us in
understanding
Sorry, Please find the revised file
On Thu, Jul 16, 2009 at 2:27 PM, Atul Kesaria wrote:
> Hello Suresh,
>
> Please find the attached sheet, hope this is what you are looking for.
>
> Thanks and Regards
> Atul Kesaria
>
> On Thu, Jul 16, 2009 at 1:29 PM, Ayushj wrote:
>
>>
>> Dear Members,
>
Hello Suresh,
Please find the attached sheet, hope this is what you are looking for.
Thanks and Regards
Atul Kesaria
On Thu, Jul 16, 2009 at 1:29 PM, Ayushj wrote:
>
> Dear Members,
>
> Can anyone assist Suresh on his query ?
>
> Thank you.
>
> On Jul 16, 12:57 pm, suresh k wrote:
> > Hi
> >
Concatenate the two fields(Name & Data) in both sheets and then put
Vlookup..
On Thu, Jul 16, 2009 at 1:29 PM, Ayushj wrote:
>
> Dear Members,
>
> Can anyone assist Suresh on his query ?
>
> Thank you.
>
> On Jul 16, 12:57 pm, suresh k wrote:
> > Hi
> >
> > I have one query.
> > I have data
*Dear Mahesh,*
According to me, the best way is to follow the below method:-
Select the blank region (cells), right below the data headings. (Press F5 ->
Alt + S -> k -> hit enter. Now do UpArrow and press Ctrl + Enter). It will
fill out the blank cells with the data from above row.
If you wan
Hi Ayush,
Query raised by Suresh has been answered. Thanks.
Thanks & Best Regards,
DILipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Jul 16, 2009 at 1:29 PM, Ayushj wrote:
Hi Suresh (Brave man)
Solution is attached. Enjoy..!! This is slightly delayed as I was occupied
with some other urgent project meetings.
Thanks
DILipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New
Give a try at the following macro; it uses columns B and C for the results
:
Sub test()
Dim c As Range, Dict, Res As Date, Ctr As Long
Set Dict = CreateObject("scripting.dictionary")
For Each c In [Dates]
Res = DateSerial(Year(c), Month(c), 1)
If Not Dict.exists(Res) Then
Dict.Ad
Dear Members,
Can anyone assist Suresh on his query ?
Thank you.
On Jul 16, 12:57 pm, suresh k wrote:
> Hi
>
> I have one query.
> I have data in two different sheets. Below are example for you.
>
> *Data in sheet 1:*
> Name Data Date No.
> Su 12
Hi
I have one query.
I have data in two different sheets. Below are example for you.
*Data in sheet 1:*
Name Data Date No.
Su 12 1/1/99 123
gu 22 2/2/99 124
gg 33 3/3/00125
*Data
Hi,
Now i also want to copy data from the above row , kindly provide the code
And syntax.
Thanx in advanc
On Thu, Jul 16, 2009 at 12:48 PM, Mahesh wrote:
> Thanx bor
>
>
> On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey wrote:
>
>> Hi Maehsh,
>>
>> Your requirement is attached herewith.
Thanx bor
On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey wrote:
> Hi Maehsh,
>
> Your requirement is attached herewith.
>
> Thanks,
> DILipandey (Back from Holidays)
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
*Hi Sandeep,*
One way is there in the footnote of your email itself. Same is copied here
also:-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Lear
Hi Maehsh,
Your requirement is attached herewith.
Thanks,
DILipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Jul
16, 2009 at 8:53 AM, Mahesh wrote:
> Hi Dilip,
>
> thanx
*Hi Vebhav,*
One way is there in the footnote of your email itself. Same is copied here
also:-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn
55 matches
Mail list logo
