you dont need access, you can continue using excel & thru DAO you can
retrieve data from closed workbook too..
On Wed, Apr 29, 2015 at 10:35 AM, Nasir Saikh wrote:
> r8 Pramod access is very easy and taking very less time than excel on huge
> data you can use it till 2 GB data.
>
> On Tuesday, A
I think you should move and grab the opportunity...
Send your resume to Puneet AON HR... All the Best buddy!!
On Wed, Apr 29, 2015 at 6:03 AM, Nasir Saikh wrote:
> Hi Pankaj,
>
> As per your post I am looking for job and I think I ll suitable for your
> expectation.
> And I have lot of experien
r8 Pramod access is very easy and taking very less time than excel on huge
data you can use it till 2 GB data.
On Tuesday, April 28, 2015 at 11:34:45 AM UTC+5:30, Mandeep Baluja wrote:
> My mmaster file is large and i just want to do lookup on my sheet from
> master file without opening my mast
Hi Pankaj,
As per your post I am looking for job and I think I ll suitable for your
expectation.
And I have lot of experience about Advance Excel, VBA , Access but I have
worked on SQL but I know some queries like select , update, append, make
table, ,making database, new users access etc.
I
Hello,
There is walk-in in AON Hewitt on Saturday..
Please share your resume to puneet.rawa...@aonhewitt.com and mention Refer
By: Pankaj Sangotra
Role: Business Analyst / Data Analyst
Experience: 0 - 4
Expertise: Excel, VBA, Access, SQL
Venue: Noida 127 Express Highway
Thanks!!
Pankaj Sangotr
Thank you so muchnow it's working absolutely!!!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Tue, Apr 28, 2015 at 2:52 PM, Mandeep Baluja
wrote:
> Sub Getvalues()
>
> Dim r As Range
> lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
> Set Rng = Sheets("Sheet1").Ra
I'm curious about your file size and response issue. What version of Excel are
you using?As ask because I use Excel 2010 and have a file that is generated
from 5 different data sources.The file contains 29 sheets,one of which contains
145,500 rows and 74 columns.There are 27 macro modules contai
Why not you are using MS Access. It's pretty cool and can we use easy..
this is best for if some one have to work in large data
Pramod
On 28 Apr 2015 15:41, "Mandeep Baluja" wrote:
> Yes it works, Thanks for the same we can considered this issue is
> resolved. But one thing Excel is not usef
Yes it works, Thanks for the same we can considered this issue is resolved.
But one thing Excel is not useful for large files On Daily basis I got
files of 350 mb having data of 2-3 lakh rows and I am unable to combine the
same jjust because excel not responds.
On Tuesday, April 28, 2015 at
Hi Mandeep
As per my suggestion you can use table link vloopup as I am using and it is
working fine. Example is given below.
Sub LoopUp()
Dim iRow As Integer
Dim MaxRow As Long
MaxRow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
Range("B2").FormulaR1C1 =
"=VLOOKUP(RC[-1],'C:\Users\n025
Sub Getvalues()
Dim r As Range
lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
Set Rng = Sheets("Sheet1").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
Sheets("Sheet1").Range("$A$1:$B$1
Dear it's not working, please check the file...i have deleted the LF
records but coding is not doing copy and paste exactly correct location to
other data!!!
You can check!!!
i m sending you both filekindly give me one coding which will be work
on both data without error.
--
Thanks & Regard
Hi Excel Beginner,
I want your help in converting the date in two columns in Excel.
If in one column(A1) I will enter Hijri Date the next column(B1) should be
changed to English date.
Please help me to solve this problem
Thanks & Regards,
Sumesh Nair
On Tuesday, September 25, 2012 at 8:15:
13 matches
Mail list logo
