Dear Ashish,
Thanks a lot for your efforts. However, I need the output in the same way as in
my file...only difference is, the current file is not able to process text in
cell with special characters.
Regards,
Amit Desai – MIS Manager
M: +91 9867232534
[Description:
cid:image005.jpg@01CFB633.1
With macro also it is possible & quite easy.. will send you soon..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Nov 13, 2014 at 11:52 AM, Pol Ktk wrote:
> Thank you Sir
> wanted this type filter
> is it possible using macro
> pls send otherwise it
Thank you Sir
wanted this type filter
is it possible using macro
pls send otherwise its ok
thanks
On 13 November 2014 11:26, Vaibhav Joshi wrote:
> Hi
>
> Check this..
>
> You need to create helper sheet to list all unique values if condition
> matched..
>
> First i created unique list for fir
not accurate.
thanks for your mail sir
On 13 November 2014 10:33, Mandeep Baluja wrote:
> Hey Pol check this sheet and confirm you want this kind of filters or not
> .
>
> *Thanks *
> *mandeep Baluja*
>
> On Wednesday, November 12, 2014 5:29:41 PM UTC+5:30, Pol Ktk wrote:
>>
>> Sir,
>> in attac
I am trying to scrape questions, options and answers from this url
(http://www.indiabix.com/general-knowledge/basic-general-knowledge/) but I
have two issues:
1. In the ForEach loop, it has empty value and does not go in the following
If Condition
2. Answer is not visible on webpage to scrape.
Hi
Check this..
You need to create helper sheet to list all unique values if condition
matched..
First i created unique list for first condition met then for second & third
& for 4th..
Then using offset function i used those unique values in list box / data
validation...
HTH/Cheers!!
+
*I
Thanks Vaibhav Bhai
--
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/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
U
Hey Pol check this sheet and confirm you want this kind of filters or not .
*Thanks *
*mandeep Baluja*
On Wednesday, November 12, 2014 5:29:41 PM UTC+5:30, Pol Ktk wrote:
>
> Sir,
> in attached there are 2 sheet
> 1 sheet contain data in 2nd sheet need filter data
>
>
> thanks
>
--
Are you =E
Great one buddy!
On Nov 13, 2014 4:13 AM, "Bé Trần Văn" wrote:
> Opening a file to show form.
>
> To import the data: Typing data into the form and click the Data Entry
>
>
> To edit data:Click listbox to select data, The data will appear on the
> form, Edit the data needed, and click Edit Data.
Cool bro..
On Nov 13, 2014 10:20 AM, "Ashish Kumar" wrote:
> Hi Amit Sir,
>
> Pls check, can it helps.
>
>
> Regards
> Ashish
>
> --
> 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 Amit Sir,
Pls check, can it helps.
Regards
Ashish
--
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/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
Welcome Bud.
Regards
Ashish
--
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/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Opening a file to show form.
To import the data: Typing data into the form and click the Data Entry
To edit data:Click listbox to select data, The data will appear on the
form, Edit the data needed, and click Edit Data.
2014-11-12 13:34 GMT+07:00 Kamal Ganeshan :
> Hi All,
>
> I want you to
Thanks Vabz:) I will try this.
On Tuesday, November 4, 2014 12:55:50 AM UTC-7, Vabz wrote:
>
> Hi
>
> Use this code:
>
> Sub Macro1()
> If ActiveSheet.FilterMode Then
> ActiveSheet.ShowAllData
> End If
> Range("F4:F16").ClearContents
> ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1, Crit
Hooray! This is exactly what I needed and it did the trick.
Thanks for all your help, Paul and Ashish!
On Wednesday, November 12, 2014 1:31:12 PM UTC-6, Paul Schreiner wrote:
>
> When you open the new workbook, it will be "active"
> using something like:
> WbName = activeworkbook.Name
>
> will
When you open the new workbook, it will be "active"
using something like:
WbName = activeworkbook.Name
will store the name of the open workbook.
later:
Workbooks(WbName).Close SaveChanges:=False
will close that workbook
Paul
-
“Do all the good you c
Thanks! I'm not sure I understand yet though.
When I run this macro, I've already got the sheet
BusinessOrganizerMapping2013.xlsm open. I hit the button to run the macro
and another sheet opens based on the sheet name that's in cell A7 of
BusinessOrganizerMapping2013.xlsm. I can manage the c
ok, thank you;)
Dne úterý, 11. listopadu 2014 6:47:02 UTC+1 Vabz napsal(a):
>
> Once you are in the Account Settings, look under 'Personal Info', and look
> at the current Country/Region of your account it should be Czech Republic
> to change it to comma instead of dot.
>
> +
> *I did not do
Hey Amit,
kindly find the attachment of data .
Thanks
*Mandeep Baluja *
On Tuesday, November 11, 2014 10:37:18 PM UTC+5:30, Anil Kumar wrote:
>
> how to use function show all location by country name
>
> pfa
>
>
> Regards,
>
> Anil Kumar Maurya
>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)
Sir,
in attached there are 2 sheet
1 sheet contain data in 2nd sheet need filter data
thanks
--
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/discussexcel
FORUM RULES
1) Us
It is very well programmed application that immediately repair and recover
badly damaged or corrupt Excel file within few clicks. If you want to know
more about the software visit:-
http://www.recoverydeletedfiles.com/excel-file-recovery-tool.html
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Thanks vabz,
How to achieve the second macro using vba.I tried here but am failing when
trying to fetch details..
Lax
--
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/discu
Thanks Vaibhav I got to know that I have not entirerow while pasting the
data to sheet2 . thanks :)
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
>
> I have made this code for I have two worksheets that are in the same
> workbook.
>
> I want to check the values of WS
Use this
formula
=IF(COUNTIF($A$2:$A$64,VLOOKUP(A2,$A$2:$A$64,1,0))>1,"Duplicate","unique")
if you want to be specific for only using vlookup function in this you can
use =VLOOKUP(VLOOKUP(A2,$A$2:$A$64,1,0),A3:A64,1,0) if na received then
value is unique if value retreived value is duplicate.
Hello kamal,
check dis out .
Private Sub CommandButton1_Click()
Dim brand As Long
Dim invoice As Long
Dim cell As Range
brand = TextBox1.Value
invoice = TextBox2.Value
temp = brand & invoice
Set ws1 = ActiveWorkbook.Sheets(1)
For Each cell In ws1.Range("a1", [a65535].End(xlUp))
If cell.Va
25 matches
Mail list logo