Put the below formulae in cell f2 then drag it till 10 rows
=CONCATENATE($A$1,":",A2,";",$B$1,":",B2,";",$C$1,":",C2,";",$D$1,":",D2,"
",E2)
On Fri, Jan 8, 2016 at 7:57 PM, Veera wrote:
> Dear Experts,
>
> PFA the scenario.
>
> Please provide solution for that scenario
>
> Regards,
> Veera
>
>
Hello all,
Can you write code for to filter(Column S)-> select the complete visible
data and paste it in new workbook and save it.
Example: Column S can have 50 lines data with 10 names
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) !
Hi, have you tried LensKart? I just did!
--
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,
ot like the rest~~
>
>
> On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas <
> venkateshs@gmail.com> wrote:
>
>> please shoot your query
>>
>>
>> On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE <
>> pradeepk
Hey how can i attach sample files, which button to click? as i dont
see any button with browse or attach. please help
On Jul 9, 11:31 am, ashish koul wrote:
> check the attachment see if it helps
>
> On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE <
>
>
>
>
t, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE <
> pradeepkumar...@gmail.com> wrote:
>
>> Base file: this file has 3 columns which has
>>
>>
>> CustomerLE Cost Center
>> AUG0001 SDFV445858
>> USA0001 JHNE652147
>> ZMA0001 N
Base file: this file has 3 columns which has
CustomerLE Cost Center
AUG0001 SDFV445858
USA0001 JHNE652147
ZMA0001 NMVE321745
Actual file: I have same 3 columns, I want a macro which has to
CONCATENATE all the 3 columns and do a vlookup to check the
combination, if the co
I have a some query regarding the vlookup can somebody help
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
*Can you please send me those e-books to my mail id*
On Sat, Jan 30, 2010 at 4:10 PM, ankur wrote:
> hi chetan
>
> i had send some ebooks at your email id plz check it
>
>
>
> On 30/01/2010, chethan wrote:
> > Hi Everybody,
> >
> > i am very new to the world of VBA macros. i would like to lear
