Re: $$Excel-Macros$$ Combined Output

2016-01-14 Thread PRADEEP KUMAR KOKNE
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

$$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-04 Thread PRADEEP KUMAR KOKNE
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) !

Re: $$Excel-Macros$$ vlookup query

2011-07-11 Thread PRADEEP KUMAR KOKNE
~~ 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 pradeepkumar...@gmail.com wrote: I have a some query regarding the vlookup can somebody help

$$Excel-Macros$$ vlookup query

2011-07-09 Thread PRADEEP KUMAR KOKNE
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

$$Excel-Macros$$ Vlookup Query

2011-07-09 Thread PRADEEP KUMAR KOKNE
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

Re: $$Excel-Macros$$ Vlookup Query

2011-07-09 Thread PRADEEP KUMAR KOKNE
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 NMVE321745 Actual file: I have same 3 columns, I want a macro which has

Re: $$Excel-Macros$$ Vlookup Query

2011-07-09 Thread PRADEEP KUMAR KOKNE
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 koul.ash...@gmail.com wrote: check the attachment see if it helps On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE pradeepkumar