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
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
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
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
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
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
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.
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:
>
>>
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
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
10 matches
Mail list logo