Thanks alot Mandeep ji.
its working.
br//
rakesh
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
www.ericsson.
when you select your blank cells just see the buttons in home tab where
insert,delete,format button is showing you need to press delete ->delete
cells -> shift cells to left .
On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
>
> Thanks Mandeep ji,
>
> but dear i didn't und
Thanks Mandeep ji,
but dear i didn't under stand what your are talking about this line
*go into home tab delete cells and shift cells left you will get your data*
Pl help
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, IND
Select b3:m5 press f5 -> click special option->tick blank->go into home
tab delete cells and shift cells left you will get your data.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook
which cells you want to unmerge ??? Please clear that on which column you
need to check your physician Text. ??? Elaborate your query please as my
macro works for column 1
On Wednesday, May 6, 2015 at 11:44:50 AM UTC+5:30, Sundarvelan wrote:
>
> Please find the attached file for your reference
Dear Experts,
Kindly Help on urgent basis to get it resolve as below .
suggest any formula to get the exact data as i required. reference sheet
attached
I have data as below source 1 1 1 1 1 1 1 1 1 1 1 1 RAKESH A
B C DMUKESH A B C D E GAURAV A B
Please find the attached file for your reference.
When i apply your macro it doesn't work.
Thanks
N.Sundarvelan
9600160150
On Wed, May 6, 2015 at 10:02 AM, Mandeep Baluja
wrote:
> what is the error you are getting give me the snapshot.
>
> On Wednesday, May 6, 2015 at 6:44:12 AM UTC+5:30, Sund
what is the error you are getting give me the snapshot.
On Wednesday, May 6, 2015 at 6:44:12 AM UTC+5:30, Sundarvelan wrote:
>
> Thanks Mandeep,
>
> But the given solution is not working.
>
> Thanks
> N.Sundarvelan
> 9600160150
>
> On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja > wrote:
>
>> Sub
Thanks Mandeep,
But the given solution is not working.
Thanks
N.Sundarvelan
9600160150
On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja
wrote:
> Sub Search()
>>
>> Dim FirstAddress As String
>>
>> With ActiveSheet.Range("A:A")
>> Set Rng = .Find(What:="physician", After:=.Cells(.Cells.Count),
>>
Yes
On Tuesday, May 5, 2015 at 1:59:59 AM UTC-4, Vabz wrote:
>
> was macro was enabled on your system?
>
> On Tue, May 5, 2015 at 1:14 AM, mburkett > wrote:
>
>> One more oddity. I opened the file on another computer on our network and
>> it worked perfectly. Both have the same rights so there m
Dear Expert, Contents in Cell F2 on Sheet is being ignored by search
formula. F2 is first cell of database range "Column F". Your VB Search is
working well for contents in other cells from F3 downwards.
On Tuesday, 5 May 2015 14:51:37 UTC+3, Mandeep Baluja wrote:
>
> what F2 i didn;t get you ???
>
> what F2 i didn;t get you
>
Regards,
Mandeep
--
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. P
Dear Expert. You did a great job. I noticed that it is ignoring value in F2
(only). I think F2 is excluded from VB Range by mistake. Sorry for late
response, as our Net was not operative for last 2-3 days.
Regards,
Zafar Iqbal
On Sunday, 3 May 2015 21:38:55 UTC+3, Mandeep Baluja wrote:
>
> Chec
>
> Sub Search()
>
> Dim FirstAddress As String
>
> With ActiveSheet.Range("A:A")
> Set Rng = .Find(What:="physician", After:=.Cells(.Cells.Count),
> LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows,
> SearchDirection:=xlNext)
>
> If Not Rng Is Nothing Then
> FirstAddress = Rng.Address
Dear Sir,
PFA for Master Tracker.
On Tue, May 5, 2015 at 2:26 PM, Prasanna Jayashankar wrote:
> Hi Sandeep,
>
> The sheet you have posted looks like the output required . Could youi also
> share the "master attendance tracker" mentioned above.
>
> Does it contain the collumns:
> Date,Name, Em
Hi Sandeep,
The sheet you have posted looks like the output required . Could youi also
share the "master attendance tracker" mentioned above.
Does it contain the collumns:
Date,Name, Emp Code, Travel Distance etc
Do you want a macro based solution or a formula driven solution ?
On Sunday, May
16 matches
Mail list logo
