Thanks champ for give more information..
i will start using code provided any challenges will post..of course aim trying my end as you suggested before positing question.
Hey monty...
U there long time.
It's a simple question out of my big project, am using different things to achieve this.
can i have simple on line code fo this!
Cheers!
Hello Everybody.
Can i have a simple one line code to select 3 rows down and 2 columns right.
am struck with the code in one of the macro development.
Cheers!
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
Application.ScreenUpdating = False
Application.EnableEvents = False
With ActiveSheet
If Not Target.Font.Bold Then
MyStr = Empty
y =...
Thank you so very much!
it works...but takes lot of time to get the result.
Can this happen by auto filter instead of hiding the rows to do this quick.
Cheers!
Hello Vletm.
Thanks for your efforts.
As i told you there are other filter which are running with a button which i wanted to included in the same ..
Need to filter with a button click.
Cheers!
vletm
Thank you so much for the above code..
cam i have same to auto filter rather then with
Private Sub Worksheet_Selection Change(By Val Target As Range)
i just need for autofilter for "A" column with "A"
As iam doing autofilter for "B" column with starting with "A" which is working fine...
Hello Experts
@vletm your code works perfectly but highlights...But wanted to filter.
@ jindon your code works perfectly but hides which are starts with 6 digits.
What really i wanted is to filter with starts with 6 digits.
Please help.
Cheers!
Hello Vletm.
Thanks for responding.
Actually the number may start with any number...it may contain 6 or 10 digits or so on...but wanted to filter only 6 digits numbers in filter irrespective of data it contains....It's really strait only 6 digits to filter.
Data is at work...So i just gave an...
Hello Experts.
Aim tired of getting this solutions...tried different ways before posting this.
Wanted to filter "A" column with condition with 6 digits only with VBA as rest of the filter's managed with recording.
My data consists of 78000 rows from which need only starting with 6 digits...
Hey little champ.
You are right when it can show data for first and two as value is existing because of third showing blank rows..which is not right.
Cheers!
Hello
I have attatched excel file with code which contains dummy data of course.
1) what i wanted is from A column wanted to filter starting with "A" and "B" filter which is working fine.
ActiveSheet.Range("$A$1:$C$9").AutoFilter Field:=1, Criteria1:="=a*", _
Operator:=xlOr, Criteria2:="=b*"...
Hello Chihiro.
Yes we can think on this...iam trying install sql server 2012...i will start writing code and will take your help.
at age of 50 trying to safeguard my job for my family and learnt lot of things from this forum.. and trying to survive...
But one thing learned from this...
Hello Chihiro.
Thanks for the link which i was going through since last week.
Connecting to SQL server with Excel is found.
But taking excel 3 cells as concatenation and checking with the table which is exiting in database and need to validate.
Example : First row
100 AA 50000 to be...
Hello
Version details
Excel 2013 and SQL server 2012 management Studio or 2014.
Please advise do i need to go for 2012 or 2014 for my requirment.
This is yet to install.
Cheers!
Hello Chihiro
Thanks for responding.
i havnt started with any coding...Am not that expertise..Minimum code i can manage as just taking baby steps with this forum.
I have same table format in SQL server like EXCEL as per screenshot.
That's how i defined so that coding should not have any...
Hello Everybody.
Working with some new assignment, project is all about from excel vba sheet need to validate data with the tables existing in Sql server.
1) From excel first row should be concatenated not in excel workbook rather in the code and should go to SQL server table 1 and check if...
Hello Marc.
Here is my macro which work great..but what if the value india not available in the autofilter?
Sub Macro1()
Range("C3").Select
Selection.AutoFilter
ActiveSheet.Range("$C$3:$C$7").AutoFilter Field:=1, Criteria1:="=India", _
Operator:=xlAnd
End Sub