Dear Rakesh,
Do you want a text to be divided into different column based on some operators?
Then you can use "Text to column" to split a cell (read a cell containing text)
to many cells (i.e. Columns).
If this help is not sufficient then please share workbook with us as Anil bhai
has suggested
Hi Anil,
Pls find the attached sample sheet.
On Wed, Nov 21, 2012 at 11:53 AM, अनिल नारायण गवली
wrote:
> dear Rakesh,
>
> Pl specify you query to understand better.Or share a sample workbook with
> us
>
> Regards,
> Gawli Anil
>
>
>
>
> On Wed, Nov 21, 2012 at 11:47 AM, Prince wrote:
>
>> Hi R
dear Rakesh,
Pl specify you query to understand better.Or share a sample workbook with us
Regards,
Gawli Anil
On Wed, Nov 21, 2012 at 11:47 AM, Prince wrote:
> Hi Rakesh,
>
> Do you want to split data of a cell into multiple cell or somthing else ???
>
> Regards
> Prince.
>
> On Wednesday,
Hi Rakesh,
Do you want to split data of a cell into multiple cell or somthing else ???
Regards
Prince.
On Wednesday, November 21, 2012 11:43:59 AM UTC+5:30, rakesh sharma wrote:
>
> Hi experts,
> I want to split a cell to multiple cells. Pls help me.
>
> --
> Regards,
>
> Rakesh Kumar Sharma
>
PFA
On Tue, Nov 20, 2012 at 10:20 PM, renuka chari wrote:
> hi Excel beginner,
> i don't know your name?
> but you gave me a wonderful solution
> thanks allot.
> but is there any easy formula for that..
> this mega formula usage in my sheet every time is difficult for me...
> is ther
Hi Viswanathan,
Just Copy And paste the following code in the module and run it.
Sub RemoveDuplcate()
Dim rngData As Range
With ThisWorkbook.Worksheets("Sheet1")
Set rngData = .Range("A1:E" & .Range("E" &
.Rows.Count).End(xlUp).Row)
rngData.RemoveDuplicates 5, x
The Invoicing are different for different organization. Better to attach
your excel sheet.
Regards,
Anoop
Sr. Developer
On Tue, Nov 20, 2012 at 3:49 PM, Amresh Maurya wrote:
> Hi Everyone,
>
> I Need invoicing Tool for Printing Invoice. Please share if you have
> any kind of tools for invoicin
Hi Raj,
Just copy and paste this code on worksheet1 code window
Private Sub Worksheet_Change(ByVal Target As Range)
If Trim(Target.Value) = Trim("2 City") Then
ThisWorkbook.Worksheets("Sheet1").Range("F13").Interior.ColorIndex
= 6
ElseIf Trim(Target.Value) = Trim("1 City") Then
It's better to attach the file and put you query there.
No one gonna study this code as different people have different logic.
Regards,
Anoop
On Tue, Nov 20, 2012 at 1:49 AM, Natron wrote:
> This is close and might get you a kickstart.
>
> Sub selectme()
> ''
> 'Origina
Event macros do NOT go in "standard" modules.
Your change event must be in the Sheet module for the sheet you wish the event
to "monitor".
If you want it to apply to ALL sheets, then a variation must go in the
Thisworkbook module.
If you right-click the sheet "tab" and select "View Code",
the
Hi,
The Easiest way is just go to data and then to remove duplicates (Alt+A+M)
Regards,
Jaysheel Bhasme.
On Wed, Nov 21, 2012 at 2:43 AM, Viswanathan Yoganathan <
viswanathan.yoganat...@asia.xchanging.com> wrote:
> HI,
>
> ** **
>
> In the attached excel, I need to remove the duplicate lin
HI,
In the attached excel, I need to remove the duplicate lines based on the
"Column E".
Example:
The first line and the second line have same value in the "Column E". The
first line should remain same and second line should be deleted, no matter what
the other cell value has in the same lin
Thank you so much Natron.
You have made my work very easy.
Thanks again.
On Tue, Nov 20, 2012 at 6:35 PM, Natron wrote:
> See attached, with the code I used below...there are many other ways to do
> this.
>
> 'This is hooked to your Export Specific Data Button on your form
> Private Sub cmdExp
Dear Friends,
kindly help out on below macro, i am not able to get output.
I Wants to auto change Cell color Range "F13" to Blue when Range "F11" is
as "1 City" and cell color Range "F13" to Yellow when range "F11" is as "2
City".
I have also attached xls for your reference.
Private Sub Works
hi Excel beginner,
i don't know your name?
but you gave me a wonderful solution
thanks allot.
but is there any easy formula for that..
this mega formula usage in my sheet every time is difficult for me...
is there any alternate solution for that...
i mean that make it simple
Hello Every one. Please find the attachment.
rgds
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi Shrini,
I think without macro it is not possible to do as formulas can not control
objects and a workbook is an object. But you can do one thing by using
conditional formatting you can intimate user to fill the cell B1 if there
is any value into cell A1.
Regards
Prince.
On Monday, Novem
Not possible to disable closing the file without a Macro.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need A
Hi All,
I need to copy paste current dated allocation file data in to my local
drive (i.e. C:\ ) with an existing excel file called ( i.e.allocation file)
and the sheet name should be same in both files. And when i try to run the
macro the current dated data should be past in the current sheet.(i.
See attached, with the code I used below...there are many other ways to do
this.
'This is hooked to your Export Specific Data Button on your form
Private Sub cmdExport_Click()
Dim intStart As Integer, intEnd As Integer
On Error GoTo whoops
intStart = Me.txtStart
intEnd = Me.txtEnd
Hi Friends,
Please help me by providing the solution.
Thanks in advance.
-- Forwarded message --
From: Mangesh Vimay
Date: Tue, Nov 20, 2012 at 12:24 AM
Subject: $$Excel-Macros$$ Please help - How to export specific range by ID
to other excel file.
To: excel-macros@googlegroup
Hi Everyone,
I Need invoicing Tool for Printing Invoice. Please share if you have
any kind of tools for invoicing in excel.
Regards
Amresh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread tit
22 matches
Mail list logo
