Re: $$Excel-Macros$$ Query to retreive data

2015-04-27 Thread Mandeep Baluja
Excel 2010 and file is on the same machine. Vabz I know the procedure to get the data from excel file but here my file is always large and opening will take a lot of time . On Tuesday, April 28, 2015 at 11:59:45 AM UTC+5:30, Vabz wrote: > > Which version of excel you are using? > > Are both fil

Re: $$Excel-Macros$$ Query to retreive data

2015-04-27 Thread Vaibhav Joshi
Which version of excel you are using? Are both file on same machine or they are on Network? On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja wrote: > My mmaster file is large and i just want to do lookup on my sheet from > master file without opening my master file as it is of huge mb around 25

$$Excel-Macros$$ Query to retreive data

2015-04-27 Thread Mandeep Baluja
My mmaster file is large and i just want to do lookup on my sheet from master file without opening my master file as it is of huge mb around 250 mb or more than that. any ideas -- 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 Face

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-27 Thread Mandeep Baluja
change activesheet to Sheets("sheet1") On Monday, April 27, 2015 at 5:41:00 PM UTC+5:30, Mandeep Baluja wrote: > > Sub Getvalues() > > Dim r As Range > lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row > Set Rng = ActiveSheet.Range("B2:B" & lr) > > For Each cell In Rng > If cell.Value Like "*LF

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-27 Thread Mandeep Baluja
Sub Getvalues() Dim r As Range lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row Set Rng = ActiveSheet.Range("B2:B" & lr) For Each cell In Rng If cell.Value Like "*LF*" Then cell.Offset(0, 1) = 0 Else cell.Offset(0, 1) = 1 End If Next On Error Resume Next ActiveSheet.Range("$A$1:$B$16").AutoFil

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-27 Thread Sunil Kumar Yadav
Dear Mandeep, I need to some modification in this, when no record of LF exist in this data then your query showing error and stop it but I want to go on next step(copy other data) without error or stop Please also check my coding!!! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-27 Thread Sunil Kumar Yadav
Thank u so much it's working as per my requirement :-) -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja wrote: > check this out code given > > > Regards, > Mandeep Baluja > > On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-27 Thread Mandeep Baluja
check this out code given Regards, Mandeep Baluja On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.yadav7186 wrote: > > hi...pls any revert > > -- > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav7186 > > On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav > wrote: > >>

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-27 Thread Mandeep Baluja
check this !! Regards, Mandeep https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.yadav7186 wrote: > > hi...pls any revert > > -- > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav718

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-27 Thread Sunil Kumar Yadav
hi...pls any revert -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav wrote: > My means sometimes LF invoice no. not exist in data that time my filter > query got error bcoz filtered value blank i want to query go to next s