Hi
Chekc this attachment, press Apt + F8 and click on Macro1 to run macro.
On prompt select range B2:B15 for this data & you will get output on output
sheet..Make sure you empty column A in output sheet before running macro
else your all data will get deleted bu macro from output sheet..
Cheers
Its owesum...
Cheers~!!
ᐧ
On Tue, Jan 20, 2015 at 11:05 AM, Pravin Gunjal wrote:
> Good Morning,
>
> It's fantastic...
>
> On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar
> wrote:
>
>> Dear Pravin jee
>>
>> PFA
>>
>>
>>
>> Regards
>> Ashish
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
Dear All,
I have a one issue. I want the define in particular category.
eg:-
Value Category
Emp_code+Emp Name "new code"
Emp_name_Mob_No "Old Code"
Means:- Pre Numerical + Any String then write the* "New Code*" in Category
columns
Any
Thanks...!!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! 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, N
Hi Vaibhav Bhai,
Thanks..!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread ti
Dear Sir,
A sample file would help to understand the issue.
On Wed, Jan 21, 2015 at 4:45 PM, Rajeev Ranjan <06raj...@gmail.com> wrote:
> Dear All,
>
> I have a one issue. I want the define in particular category.
>
> eg:-
>Value Category
> Emp_code+Emp Name "n
HI,
please find the Sample data
Input Data are Value columns
output data are Category columns.
Value*Category*Description001_Anil Sikdhar_MPCG_VAINew
Codeinteger value+ String456_RAJENDRA Kewat_MPCG_VAINew CodeAP_Adecco_Maheshwar
Kumar.V_98660Old CodeString + IntegerAP_Adecc
check col. B in attachment
Cheers!!
ᐧ
On Wed, Jan 21, 2015 at 5:47 PM, Rajeev Ranjan <06raj...@gmail.com> wrote:
> HI,
> please find the Sample data
>
> Input Data are Value columns
> output data are Category columns.
>
> Value*Category*Description001_Anil Sikdhar_MPCG_VAINew
>
Hello,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Build Release consultant with TFS. *position in* Chevy
Chase, MD. *Please find below the job description for the same and revert
back to me with your updated profile and contact details at the earlie
Hello,
i'm having trouble with a macro that i've sent up to:
1) unprotect a sheet with a password
2) do some filtering and set a print area
3) apply the password again
Looks like steps 1 and 2 are working fine but step 3 isn't working. After
running the marco I can click the "Unprotect Sheet" b
*Hi**,*
*Hope you are doing great!!*
* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com
and I will get back as soon as possible.*
*Position: Busine
The problem is that you cannot protect a protected sheet.
So once you use:
ActiveSheet.protect DrawingObjects:=True, Contents:=True, Scenarios:=True
then the line:
Activesheet.protect Password:="deck"
does NOTHING, because the sheet is already protected!
you need to combine the two lines:
A
Hello Associate,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *AB Initio Developer or Lead *position in *Chevy Chase, MD**.
*Please find below the job description for the same and revert back to me
with your consultant updated profile and contact detai
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed ?
Option Explicit
Private Sub CommandButton1-Click()
Dim Range As Integer
Dim UsedRange As Integer
Sheets("RegionalAreas").Select
Intersect
HI
Have cells that have had serial numbers entered (up to 50 serial numbers)
each separated by a comma.
Is there a VBA argument that can take the cell and transfer each serial
number to its own cell.
Part of a larger VBA project. VBA rather than function wanted.
e.g.
45,55,56,57,58,60,71
Elaborate more with Example
On 22 January 2015 at 12:12, sswcharlie wrote:
> HI
>
> Have cells that have had serial numbers entered (up to 50 serial numbers)
> each separated by a comma.
> Is there a VBA argument that can take the cell and transfer each serial
> number to its own cell.
> Part of
This code is not complete, do check & report..
ᐧ
On Thu, Jan 22, 2015 at 11:20 AM, sswcharlie wrote:
> Hi
>
> Excel2000
>
> On code below I get a 'syntax' error. On row- Intersect. Code
> off the net. Have tried some things but no luck. What have I missed ?
>
> Option Explicit
> Pri
Hi
Put your value in Cell A1 & put below formula in B1 & copy and paste it
next columns
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),(COLUMN(A$1)*99)-98,99))
Cheers!!
ᐧ
On Thu, Jan 22, 2015 at 12:25 PM, Ashish Kumar
wrote:
>
>
> Elaborate more with Example
>
> On 22 January 2015 at 12:12, s
Nice solution Vaibhav Bhai.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread tit
check this Attachment..
ᐧ
On Thu, Jan 22, 2015 at 12:58 PM, Vaibhav Joshi wrote:
> Hi
>
> Put your value in Cell A1 & put below formula in B1 & copy and paste it
> next columns
>
> =TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),(COLUMN(A$1)*99)-98,99))
>
> Cheers!!
> ᐧ
>
> On Thu, Jan 22, 2015
Formula is working Well. Nice Solution Vaibhav bhai.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate threa
Cheers Buddy..
ᐧ
On Thu, Jan 22, 2015 at 1:08 PM, Ashish Kumar
wrote:
> Formula is working Well. Nice Solution Vaibhav bhai.
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Thanks for the function options. Look great but I would prefer to do with
VBA
23,34,56,57,60... would
become
23
34
56
57
60
etc
Thanks
Charles
On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote:
>
> HI
>
> Have cells that have had serial numbers entered (up to 50 ser
Double Cheers to you.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! 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,
Hi
Have checked and this is all the code I had.
What I want the code to do is to put the last number in a list in the text
box on user form.
Thanks for your help.
Charles
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
>
> Hi
>
> Excel2000
>
> On code below I get a 'syntax'
Hi Charlie,
Check this.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles
26 matches
Mail list logo
