Hello Dave,
Incase if I have to assemble all the different cell values
like i3, j3,toz3 all these cell data to be assembled in one particular cell how
to go about it and all this data should appear one after the other and in one
whole cell.
--- On Tue, 7/28/09, Dave Bonallac
Hi..
wondering y u dint go for "text to columns"
--- On Mon, 7/27/09, Pinky Sangani wrote:
> From: Pinky Sangani
> Subject: $$Excel-Macros$$ Segregation of data on a button click in excel
> To: "MS EXCEL AND VBA MACROS"
> Date: Monday, July 27, 2009, 4:18 PM
>
> HI
> i need this ASAP i h
Hi, Hemant ,
Please see the attched file It will you to get the desired output
...Thanks
On 7/27/09, hemant shah wrote:
>
> Hi All,
>
> I have recently join the group and i have one query on excel.
>
> Please see the attached file for the query.
>
> Hope i will get the response fr
Hi Hemant
Following is the code that does your task... Hope it Helps
===
Sub Fill_Names()
Dim vListNames As Range
Dim vListGrade As Range
Dim vGrade As String
Dim vCells As Range
Set vListNames = Range([j2], [j2].End(xlDown))
Set vListGrade =
Hi,
If Pinky's data is just like you say, have a look at the attached.
You can copy down to accommodate more data.
However, if the sheet has a lot of data, ie thousands of lines, the attached
worksheet function solution may take too long, and a VBA solution would be
better.
Regards - Dave.
Hi All,
I have recently join the group and i have one query on excel.
Please see the attached file for the query.
Hope i will get the response from this group.
Regards,
Hemant Shah
--~--~-~--~~~---~--~~
If like me you find resizing array formulas awkward, you will find the
following code to a time-saver. It will automatically create an array
formula to fit the currently selected cells, using the formula or
value that is in the top left cell of your selection.
I've put this code in an add-in cal
Thanks Ajitji
u have given good solution to my query.
i want to elorbrate more on the same sheet ---
that suppose if i made wrongly clik the duplicate then it macro -- ctrl
Z - undo
does not work.. --- ok i can physically delete the raw -- correct the
pending coulmn
But suppose that raw t
andy, tried to send the sample file to your gmail address
(ai...@gmail.com) but it failed maybe i have wrong address?. giant
On Jul 26, 5:37 pm, giant wrote:
> andy, ymail aint working on my pc at the moment, will send a sample
> file when it does.thanks, giant
>
> On Jul 26, 2:37 am, Aindril
I have public function in XLA file which I access from XLS sheet.
How do I access current worksheet from XLA.
I tried all options thisworkbook, activeworkbook or activesheet
nothing works.
Thanks
--~--~-~--~~~---~--~~
-
Use the following formula
=CONCATENATE(A1," ",TEXT(A2,"mm-dd-"))
where A1 = Today is and A2 = date
Rg
On Mon, Jul 27, 2009 at 8:38 PM, Radhe Sham L wrote:
> Hi Group
>
> This is a query regarding the date format retention in concatenate
>
> What happens is while concatenating some text wit
You have to keep in mind that what YOU see as a date
is actually a number FORMATTED as a date.
the Display format of "Date" is much the same as "blue", or "bold".
so.. if you're concatenating strings together and wanted to keep the "blue/bold"
FORMATTING in the combined string... I suppose it COUL
Hello All,
Please find attached input and desired output of Pinky.
Thanks for your help,
Ayush Jain
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tuto
I am working on a project with MS Excel 2003, using VBA. Part of the
project is adding 34 separate sheets to the workbook, each loaded with
data imported from txt files. I also need and created a procedure to
delete the 34 sheets so they are be reloaded.
The 1st time through, everything works a
Dear Pinky,
Can you please attach a sample file. This will help a quick solution
Regards,
Andy
On Mon, Jul 27, 2009 at 9:22 PM, Ayush Jain wrote:
>
> Dear members,
>
> Can anyone assist Pinky ? She is in urgent need.
>
> Thanks.
>
> On Jul 27, 3:48 pm, Pinky Sangani wrote:
> > HI
> > i need t
HI Pinky
Use Text to columns options for segregating the data into columns :)
Ashish
--- On Mon, 27/7/09, Ayush Jain wrote:
From: Ayush Jain
Subject: $$Excel-Macros$$ Re: Segregation of data on a button click in excel
To: "MS EXCEL AND VBA MACROS"
Date: Monday, 27 July, 2009, 7:52 PM
D
Dear Radhe Sham,
Use
Text(Date,"dd-mmm-yy")
while concatenating
e.g. "Today is "&Text(Today(),"dd-mmm-yy") will give Today is 27-Jul-09 as
result.
Please let me know if it helps.
Regards,
Andy
On Mon, Jul 27, 2009 at 10:08 PM, Radhe Sham L wrote:
> Hi Group
>
> This is a query regarding the
Hi Group
This is a query regarding the date format retention in concatenate
What happens is while concatenating some text with a cell containing date,
the out put is text with the date in number format whereas ther equirement
is date format
Output for eg " Today is 40021" ; required out put is T
I have uploaded the file to the group. It is called SPC_Cells.xlsx. I
hope this helps. Nothing too fancy at this point, but again, I would
like to try and automate the copying of the formula into new rows so
that the uses don't have to do it.
Cheers,
Russ
On Jul 25, 11:29 am, Dilip Pandey wrot
Yes Sir, but I couldn't able to view this. How to open it?
On 7/27/09, vivek agrawal wrote:
>
> Hi Dhananjay.
>
> Have you been able to download the file
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com - Saving energy-Save Earth
>
>
>
>
> On Mon, Jul
I think you just have to use Data->Text to Column->Delimited->Space->Finish
Saurabh Patel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Pinky Sangani
Sent: Monday, July 27, 2009 4:19 PM
To: MS EXCEL AND VBA MACROS
Subject: $$E
Hi.
Try :
Sub test()
ActiveCell = "YES ABC NO XYZ YES AGH NO HGT"
tabl = Split(ActiveCell, " ")
For i = 0 To UBound(tabl)
ActiveCell.Offset(, i + 1) = tabl(i)
Next i
End Sub
Regards.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegro
Thank you very much --
I will check the function -- & let you know.
Ms. J. Shah
On Mon, Jul 27, 2009 at 3:26 PM, Ajit Navre wrote:
> Please find the file attached….
>
>
>
> Let me know if you have any doubts
>
>
>
> Regards
>
>
>
> Ajit
>
>
>
> *From:* excel-macros@googlegroups.com [m
Pinky...
can u please attach the file..so that the solution can be worked out in that
itself
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Mon, Jul 27, 2009 at 4:18 PM, Pinky Sangani wrote:
>
> HI
> i need this ASAP i have 1
Dear members,
Can anyone assist Pinky ? She is in urgent need.
Thanks.
On Jul 27, 3:48 pm, Pinky Sangani wrote:
> HI
> i need this ASAP i have 1 long string in 1 of the cell in the
> worksheet where in i have 2 segregate the datas in it to various
> columns as in the THe String is like
> "YES
Hi Dhananjay.
Have you been able to download the file
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Mon, Jul 27, 2009 at 7:25 PM, Dhananjay Pinjan wrote:
> Hello Mr. Vivek Agrawal,
>
> I cannot able to view the below addressed
Hi Martin,
After you select your range (which may include the hidden cells) try
to press Alt + ;.
This selects only visible cells. Once this is done, you can clear your range.
If this does not work, you'll have to create a macro which will
unprotect your worksheet, clear the required range and
Hello Mr. Vivek Agrawal,
I cannot able to view the below addressed file.
"
http://groups.google.com/group/excel-macros/web/Microsoft_Office_2007_eBooks_Collection_%5BPDF_CHM_-_ENG%5D.4573644.TPB.torrent
"
Pl. Can you assist me about how to view it?
Thanks & Regards,
Dhananjay
On 7/23/09, vivek
HI
i need this ASAP i have 1 long string in 1 of the cell in the
worksheet where in i have 2 segregate the datas in it to various
columns as in the THe String is like
"YES ABC NO XYZ YES AGH NO HGT" AND IT DIFFERS IN VARIOUS COLUMN
WHEREIN SOME COLUMN It IS "NO ABC YES XYZ..."KINDLY HELP ME 2 WITE
HI
i need this ASAP i have 1 long string in 1 of the cell in the
worksheet where in i have 2 segregate the datas in it to various
columns as in the THe String is like
"YES ABC NO XYZ YES AGH NO HGT" AND IT DIFFERS IN VARIOUS COLUMN
WHEREIN SOME COLUMN It IS "NO ABC YES XYZ..."KINDLY HELP ME 2 WITE
I'm using the following code to access an application called ACT! that
is open and running and send the following keys. However after the
'AppActivate' line, it reverts back to excel.
Sub test()
AppActivate ("ACT!")
SendKeys ("%f")
SendKeys ("d")
SendKeys ("e")
End Sub
How do i st
Hello,
Selection.TextToColumns Destination:=Selection.Offset(,1),
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar
_
:="-", FieldInfo:=Array(Array(1, 1), Ar
All requirements are given in the excel attached in the mail
Kindly help me to solve the same
--
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing
those you hold well"
"Before you judge another, think of your own last mistake."
--~--~-~--~~--
Dear All ,
I have been facing a problem regarding opening Xls file..(2007 format 0
when a file is opened , no work sheets are seen . then I am to click
excel option tab at top left corner of the file.
Doing nothing I just clik OK .. then work sheet are coming ..
Another porblem
Hi,
Can anyone please help me to edit this code :
Selection.TextToColumns Destination:=Range("B31"),
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True,
OtherChar _
:="
35 matches
Mail list logo
