Dear All
I want vba code where I serach any any Specific word in all excel tabs
where it is input (hidden or unhidden).
Regards
Amar
--
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 Facebook page of this forum @
https://www.faceb
Hi friends,
Useful VBA for ur reference Feels worth to sharing
https://youtu.be/3Dbd-AsUIf4
Regards,
Prabhu.R
--
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 Facebook page of this forum @
https://www.facebook.com/discus
Hello I'm currently have a workbook with over 2000 lines of information.
What I'm trying to do is to search for a number in the B Column and copy the
results to A2 in sheet2 going down A3 A4 A5 as there is numerious results could
be up to 2000 results for what I searched
The code below searchs
Oh my god!
Thank you very much!
André
2016-05-25 15:14 GMT-03:00 Abhishek Jain :
> Please see attached
>
> On Wed, May 25, 2016 at 4:43 PM, André D'Avila
> wrote:
>
>> Hello Experts!
>>
>> I have a cell containing the info "Invoice Google Nr 123456789" and
>> another containing "Invoice Twitter
Please see attached
On Wed, May 25, 2016 at 4:43 PM, André D'Avila
wrote:
> Hello Experts!
>
> I have a cell containing the info "Invoice Google Nr 123456789" and
> another containing "Invoice Twitter Nr 1234567" for exemple.
>
> And I have a list of keywords that I named "keywords" like below:
Hello Experts!
I have a cell containing the info "Invoice Google Nr 123456789" and another
containing "Invoice Twitter Nr 1234567" for exemple.
And I have a list of keywords that I named "keywords" like below:
-GOOGLE
-TWITTER
What I would like to do, without using macro, is to put beside of "In
Is it possible to send me the excel file itself?you can send it directly to my
email (schreiner_p...@att.net) rather than posting it to the group.
Your first question is a bit confusing.Copying values from one cell to another
is as simple as:
Range("I7").Value = Range("D8").Value
Range("J7").Valu
Thanks Paul!!!
it works perfectly fine.
This is the code that I have so far. first time working with a pivot table
macro. the final result should like the screen shot below.
the problem is
1) how do I copy the data highlighted in blue and yellow to the right table
in green? I tried using the
Yes, this is much easier to understand.Did I miss where you mentioned your VBA
code before?I TOTALLY didn't understand that you were working with VBA.I
thought you were using Excel functions.
So, now that we're on the same page, let's take a look at your code:
When the macro first runs, colLast i
I am a bit confused with your question.
This is what I am able to come up with so far.
maybe you might be able to understand what I am trying to do from the code.
So I was able to come up with this but it is not placing the value in same
come as the word type
Dim colLast As Long
Dim Rng
I'm sorry, I STILL do not understand.
How does the value in column "J" determine the value to display in column "O"?
as for "empty" rows.How can a row be empty if it has a value or something in
it?If it has something in it, it is not empty.If it is empty, it doesn't have
anything in it!?
I suspec
I am using 2010 excel.
I have attached a file. The value in column J will determine what will go
into o. So I don't have the value for column o stored any where.
what I mean by delete row. Is to clean up the rows after the last row with
data. Sometimes some rows might be empty but have in val
It would be helpful to provide a sample file.But:What version of Excel are you
using?
Where do you get the values for column "O"? Your example has entering "utility"
when something other than "fuel" is in column J.Are there other values?
And, what so you mean by "Delete any extra line after the l
Hello All,
Please I need help with the below macro.
I have a worksheet with lots of data.
1.
I want to go through each cell in column J.
To find data and put the answer in column O.
2.
Then left and Right trim spaces
3.
Delete any extra line after the l
Dear All experts team,
Good morning!
Question: how to search specific text or numbers in excel folder.
I have folder where there are a lot of excel sheet ( more than 100) & I
have to search specific text or numbers in all excel from that folder.If I
search specific text or numbers through VBA co
In MS Word, I can
search for any letter using ^$
search for any number using ^#
Is there an equivalent in Excel?
e.g., if I want to find a number followed by a - (hyphen), is there a way
to do this?
Thank you.
Kannan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
try below code.
Sub Button3_Click()
Dim wSheet As Worksheet
Dim wBook As Workbook
Dim rFound As Range
Dim bFound As Boolean
Dim lngNextRow As Long
Dim strMyString As String
strMyString = Application.InputBox("Enter the number you wish to find")
On Error
Hi all,
Thank you in advance for all your help it is really appreciated. I have the
following code which looks for a certain value into all the open workbooks
and then pastes the entire row into a sheet from the current workbook named
'RESULTS'. The problem is that it does not copy the row con
>>
>>
>>
>>
>>
>>
>>
>> *“Do all the good you can,By all the means you can,In all the ways you
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>>
g as ever you can.” - John Wesley*
> -------------
>
>*From:* Bill Q >
> *To:* excel-...@googlegroups.com
> *Sent:* Thursday, January 22, 2015 12:15 PM
> *Subject:* $$Excel-Macros$$ Search Box - Event Macro ??
>
> Hi,
>
> I curre
From: Bill Q
>To: excel-macros@googlegroups.com
>Sent: Thursday, January 22, 2015 12:15 PM
>Subject: $$Excel-Macros$$ Search Box - Event Macro ??
>
>
>
>Hi,
>
>
>I currently use filter tabs when filtering data. It is a very useful.
>
>
>However, what I woul
Hi,
I currently use filter tabs when filtering data. It is a very useful.
However, what I would like is to have a search cell (Say "A1")that
specifically would filter All cells from A3 to A1 that "contain" what
ever is typed in as you type in without having to press the enter button or
g
Hey
Pl refer attached file, I have done for few cases.. You have to finish home
work for rest of cases.
Make Sure Header is matching with Heading of Data.
Thanks!!
On Fri, Jul 12, 2013 at 11:23 AM, Kannan Excel wrote:
> hi,
>
> pls find the attached file,
>
> 2nd sheet is master data... 1st s
hi,
pls find the attached file,
2nd sheet is master data... 1st sheet is searching data...
if i enter employee id in 1st sheet 2nd sheet data want to come
automatically...
pls do the needful urgent base
regards
Kannan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
le you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Putta Madaiah
> *To:* excel-macros@googlegroups.com
> *Sent:* Mon, September 17, 2012 11:33:59 AM
> *Subject:* $$Excel-Macros$$ Search tool in Excel s
59 AM
Subject: $$Excel-Macros$$ Search tool in Excel sheet
Hi Ex(cel)perts,
I am in need of a macro based search tool in Excel 2010.
If I type some text in cell A2, then it look for in the column range A5:F1
and filtered data should be shown.
With Best REgards,
Madaiah--
Join official fac
Hi Ex(cel)perts,
I am in need of a macro based search tool in Excel 2010.
If I type some text in cell A2, then it look for in the column range
A5:F1 and filtered data should be shown.
With Best REgards,
Madaiah
--
Join official facebook page of this forum @
https://www.facebook.com/discus
I no longer have it. Send your file direct to ME along with the solution I
proposed.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Wednesday, August 22, 2012 8:00 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Search
Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* amar takale
> *Sent:* Wednesday, August 22, 2012 1:37 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Search & Highlight name in list (1000
> name list)
>
My guess is that you didn’t like my solution.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Wednesday, August 22, 2012 1:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name
Dear Mr. Amar,
Can you explain me in detail that will help me lot.
I am not able understand the logic behind the attached excel
THANKS & REGARDS,
CA KSAGAR
On Tue, Aug 21, 2012 at 4:01 PM, Amresh Maurya wrote:
>
> Hi CA KSAGAR ,
>
> GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET L
AllData
tc = Target.Column - 1
Range("b6:d6").AutoFilter Field:=tc, Criteria1:="=*" & Target & "*"
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Tuesday, August 21, 2012 3:52 AM
To: excel-macros@googlegrou
Hi CA KSAGAR ,
GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET LOGIC..
Regards
Amresh
On Tue, Aug 21, 2012 at 3:42 PM, SAGAR KASANGOTTUWAR <
sagarkasangottu...@gmail.com> wrote:
> Dear Ameresh,
>
> Kindly tell me how we can put scroll in excel like you have done in
> attached work
Dear Ameresh,
Kindly tell me how we can put scroll in excel like you have done in
attached worksheet...
Thanks & Regards,
CA KSAGAR
On Tue, Aug 21, 2012 at 3:26 PM, अनिल नारायण गवली
wrote:
> Dear Amar
> Your formula is right
> if you want only the highlighted color then on filter field click o
Dear Amar
Your formula is right
if you want only the highlighted color then on filter field click on filter
by color . it is easily available there
Thanks & Regards,
Gawli anil
On Tue, Aug 21, 2012 at 3:20 PM, amar takale wrote:
> Hi Amresh
> I used excel 2003 So I cant see formulas.I also
Hi Amresh
I used excel 2003 So I cant see formulas.I also not understand what are
doing? In which cell I put search name Then highlight search name cell.
Amar
On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya wrote:
> Hi Amar,
>
> find the attached file. hope it will help you in search the data.
>
Hi Amar,
find the attached file. hope it will help you in search the data.
Regards
Amresh
On Tue, Aug 21, 2012 at 2:22 PM, amar takale wrote:
> Hi experts,
> I know it is Conditional formatting but if I search name then highlight
> that cell but if there are 1000 name & I search name then I sc
Hi experts,
I know it is Conditional formatting but if I search name then highlight
that cell but if there are 1000 name & I search name then I scroll bar up &
down which cell highlight. I want to jump that cell directly with
highlight.Is it possible?
Thanks
Amar
--
Join official facebook page of
he ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: JsinSk
To: excel-macros@googlegroups.com
Sent: Fri, July 13, 2012 10:1
Hello Group,
I'm attempting to automatically format a report that has several parts and
break it down to what I need.
The report comes in plain text and has three parts that all in with the
phrase "total :" in the last part of that section. I'd like to see about
having it break down each secti
2012/5/29, Mangesh Dayne :
> Hi Friends,
>
> Please help me on above query.
>
> Please .
>
>
> With regards,
>
> Mangesh
>
> On Mon, May 28, 2012 at 7:25 PM, Mangesh Dayne
> wrote:
>
>> Hi All,
>>
>> Please help me on below query.
>>
>> With regards,
>>
>> Mangesh
>>
>>
>> On Mon, May 28, 2012 at 5
Hi All,
Please help me on below query.
With regards,
Mangesh
On Mon, May 28, 2012 at 5:12 PM, Mangesh Dayne wrote:
> HI Noorain,
>
> Thanks for your reply.
> However, I didn't get about the red highlighted code.
> I have attached snapshot about what I need. Please find it and help me.
>
> Let
Thanks Mangesh...
On Fri, May 25, 2012 at 11:04 PM, Mangesh Dayne wrote:
> Simply Awesome !!!
>
>
> On Fri, May 25, 2012 at 8:27 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Mangesh,
>>
>> Please try it...
>>
>> *Sub search_domain()
>> Dim rng As Range
>> Dim rw As Long
>>
>> Dim sh As Worksheet
>> Set
Dear Mangesh,
Please try it..and see attached sheet..
Sub search_domainname()
Dim rng As Range
Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets(1)
For Each rng In sh.Range("H3:H8")
If Right(rng, Len(rng) - InStr(1, rng, "@")) = Range("B1") Then
MsgBox "Found in Cell" & vbCrLf & rng.Address
Exit S
Hi All,
Please help me on attached sheet.
Thanks lot.
with regards,
Mangesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Or use the AfterUpdate event.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: Wednesday, March 07, 2012 11:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Search an fill combobox
The ComboBox1_Change
The ComboBox1_Change event is designed to work that way. Stop using the
change event for this. Each time you type a letter, there is an event
triggered. If you do not want to search to be triggered, why don't you use
a button click for this. Type in the name in the combobox, and then click
the butt
Hi. Someone help with this: I have a book with aprox 20 sheets, many
products are included. Well i need a search a defined product from
combobox inside a userform, but when i write the first letter the
macro run and don't let me write the others. I tried to put a delay
but doesn't work. If you can
-Original message-
From: Prajakt Pande
Sent: 23/02/2012, 10:30 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ search via macro like excel
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the
-Original message-
From: Prajakt Pande
Sent: 23/02/2012, 10:30 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ search via macro like excel
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the
-Original message-
From: Prajakt Pande
Sent: 23/02/2012, 10:30 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ search via macro like excel
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the attached file.I have used below codes in user form.
>
> Private Sub CommandButton1_Click()
>
> Dim rng1 As Range
> Dim lll As Integer
>
> Sheets("Sheet2").Select
> Cells.Se
>
> **
>
> 2012/2/21 Maries
> Hi Prajakt,
>
> Please find the attached file.I have used below codes in user form.
>
> Private Sub CommandButton1_Click()
>
> Dim rng1 As Range
> Dim lll As Integer
>
> Sheets("Sheet2").Select
> Cells.Select
> Selection.ClearContents
>
> lll = Len(Te
PFA.
*Formula - =INDEX(B2:B21,MATCH(TRUE,VALUE(RIGHT(A2:A21,4))=H12,0))*
On Sun, Feb 19, 2012 at 12:15 PM, Prajakt Pande wrote:
> Dear all,
>>
>> Roll on codes are maximum 8 digits, I want to search via roll on
>> codes, at least 4 digits,
>> Where ever it matches with sequence, need to update t
Dear all,
Roll on codes are maximum 8 digits, I want to search via roll on
codes, at least 4 digits,
Where ever it matches with sequence, need to update the other
information in respective field, with next and previous option,
If “Roll on code” is not available then search via NAME. Sheet
attached
gt;> ** **
>>>
>>> Regards,
>>>
>>> ** **
>>>
>>> Sam Mathai Chacko
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *chandra
cel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Search Engin
Dear all
Here with attached Seach Engines 2003. which is get from this group . i
need one more step ahead for this when i enter the Seach Criteria like
Mohan it will come all Start with Mohan is it possible or if enter one
oglegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de* C.G.Kumar
>> *Envoyé :* lundi 18 avril 2011 10:15
>> *À :* excel-macros@googlegroups.com
>> *Objet :* $$Excel-Macros$$ SEARCH FUNCTION
>>
>>
>>
>> Dear All,
&g
l 2011 10:15
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ SEARCH FUNCTION
>
>
>
> Dear All,
>
>
>
>
>
> I intend to generate list based on search of Text String.Sample file
> attached.
>
>
>
> Regards,
>
>
>
> C.G.Kumar
>
Hi,
Please, attach file ;-)
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de C.G.Kumar
Envoyé : lundi 18 avril 2011 10:15
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ SEARCH FUNCTION
Dear All,
I intend to generate list
Thanks Ranjan but I could not use file filter because;
1.Data is required at different place.
2.Filter is not effective when i have to use it more than 50 times in a day.
3.Data captured on the basis of the criteria is further required for
calculation purpose.
Therefore, i intend to use *formula
you should apply contain Filter.. i think
On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote:
> Hello,
> I have a very tricky problem. I have got an excel sheet having some columns
> but more than 5000 rows. In those columns there are some names which may/may
> not be similar to each other. I want
Hello,
I have a very tricky problem. I have got an excel sheet having some columns
but more than 5000 rows. In those columns there are some names which may/may
not be similar to each other. I want to make a macro which can:
1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
Ho
Dear All,
I intend to generate list based on search of Text String.Sample file
attached.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://t
anche 5 décembre 2010 15:38
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Search array for value and return into a another
array
Hi
I have VBA problem I hope you can help me with.
I have a two arrays and for each value I want to search in the other array,
and then copy the value from the s
Hi
I have VBA problem I hope you can help me with.
I have a two arrays and for each value I want to search in the other
array, and then copy the value from the second column in the second
array into my first array.
I need to fill in column B in Sheet 1 with the corresponding name,
leaving it blank
i have a column filled with month names. but not in order here and
there. not in a list.
I want to search for all "sep" in that whole column and put the values
next to it another column. but How to end the loop once it reach the
last "sept" in the column. In other words howt to stop it from endles
I am trying to find a easy way in excel to match and though up options
One excel sheet has names and uniqe id of staff ( say 0001,0002... etc)
Another excel sheet with code name of training programs ( say 123,b124,C234
... etc)
Some staff have attended some programs.
I want excel to through up
Hi,
I have two lists. One list is a bunch of fund names and the other
list is a bunch of different fund families (not necessarily related to
the bunch of fund names). I'm trying to figure out how many of the
funds are ones that are present on the fund family list. So to better
illustrate what
Hello
I tried to do this stuff on SAS but without much success so ... And of
course i am a total newbie to VBA ...
Here is my problem :
I need to merge 2 datasets without any common identifier except the
name of the company
Of course in both datasets the names can be writtent differently,
misspel
Is there a way to search or sort the discussions so I can easily find
one that I started?
Regards,
Doug Rohr
(330) 471-4164
-
This message and any attachments are intended for the individual or
entity named above. If you are not the intended reci
71 matches
Mail list logo
