Kindly help on the said issue.
Thanks!
On Mon, Sep 24, 2018 at 5:31 PM vikas khen wrote:
> Hi All,
>
>
>
> Kindly find the attached two sheets, based on the same I need Conditional
> formatting formula to highlight the cell value in color it the given
> criteria matches. I have mentioned the c
*Regards,*
*For quick responds click here for Message *
On Mon, Feb 12, 2018 at 9:31 AM, Ruchin Gupta
wrote:
> I have a table where data changes continously (stock market data). I want
> to apply IF formula. please understand with given example.
>
> A1 = 10
> B1 = 20
> C1 = 5
> D1 = where i w
On Tue, 6/20/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Tuesday, June 20, 2017
On Tue, 6/20/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Tuesday, June 20, 201
On Tue, 6/20/17, Mustapha LMIDMANI wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: "excel-macros"
Date: Tuesday, June 20, 2017, 1:19 PM
I have fixed N° of
product and fixed N° of
I have fixed N° of product and fixed N° of customers.
It would be great if I can modify customer and product list in separated
sheet if I want to add or remove something :)
Many thanks Paul
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on t
If you can give me a larger sample of data, I can try to work on
something.Since it sounds like you have no background with VBA programming,
I'll try to develop an Excel-Function solution.
Paul-
“Do all the good you can,
By all the means you can,
In all th
adjective: dynamic1. (of a process or system) characterized by constant change,
activity, or progress.
That's why I defined the meaning in my question:
How "dynamic" is your data?Is the number of Products variable or fixed?is the
number of Customers variable or fixed?
Meaning, does the number of
Sorry Paul, I didn't get what you mean by "dynamic".
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on the screen
*NOTICE:* This privileged and confidential email is intended only for the
individual or entity to whom it is addressed. With regar
That didn't answer my questions. Paul-
“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
---
Hi dears,
Thanks for your feedback guys.
Paul: sheets are filled weekly (manually). and the dashboard have to
reflect data on sheets by selecting Customer and month
thanks in advance
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on the scre
There's not enough information for me to guess how you want the summary
populated.
How "dynamic" is your data?Is the number of Products variable or fixed?is the
number of Customers variable or fixed?
Paul-
“Do all the good you can,
By all the means you c
On Sun, 6/18/17, Rajan Verma wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Sunday, June 18, 2017, 7:09 PM
countif, sumif,
sumproduct can do this
On Sun
countif, sumif, sumproduct can do this
On Sun, 18 Jun 2017 at 9:23 PM, Mustapha LMIDMANI <
lmidmani.musta...@gmail.com> wrote:
>
> Hi Guys,
>
> I'd like to know if there is any possibility with functions to fill my
> Summary sheet from montly report sheet in the attached sample. or I need to
> cr
On Thu, 6/8/17, Mustapha LMIDMANI wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: "excel-macros"
Date: Thursday, June 8, 2017, 11:18 AM
Hi,
Can somone help on
my issue please .
Hi,
Can somone help on my issue please .
On 6 June 2017 at 10:50, Mustapha LMIDMANI
wrote:
> Hi Guys,
>
> I'd like to know if there is any possibility with functions to fill my
> Summary sheet from montly report sheet in the attached sample. or I need to
> create a macro?
>
> By selecting Cus
Thank you Paul, I've got a huge mental block on this type of expression. I
appreciate the help!
On Friday, June 2, 2017 at 11:56:24 AM UTC-4, Paul Schreiner wrote:
>
> Let's say that you have 100 rows of data.
>
> "bottom" ends up being 100.
> so your Rows statement results in:
> Rows(R:100).in
Let's say that you have 100 rows of data. "bottom" ends up being 100.so your
Rows statement results in:Rows(R:100).insert shift:=xldown
I think it needs to beRows(100:100).insert shift:=xldown
so you'd use:Rows(r & ":" & r).Insert Shift:=xlDown
Paul-
“Do all
PFA Solved question..
On Thu, Jun 1, 2017 at 7:50 PM, Secret Shot wrote:
> Dear Team,
>
> I have one very large excel table which i made from Raw data, accidentally
> raw data has been deleted and the only option i have is that table to
> convert back in raw data.
>
> Its about my job so pls hel
On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Friday, June 2, 201
On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Thursday, June 1, 201
Thanks Paul, This is exactly what i was needed. you are a life saviour
On Thu, Jun 1, 2017 at 11:34 PM, Paul Schreiner
wrote:
> In THAT case:
>
> If you name a range "Result" and have it include the "summary" table
> without the column headings or phone numbers
> B4:G9 in your sample
>
> Then, n
In THAT case:
If you name a range "Result" and have it include the "summary" table without
the column headings or phone numbersB4:G9 in your sample
Then, name a range called "Data" that includes the original "Data" without the
column headingsL4:M1000 in your example.
Then you can use a macro like
Dear Paul,
I appreciate your quick response, However when i say raw data it means just
simple table in Excel which i have shown in attached excel sheet only in
column L and M.
So you can consider it as requirement or data rearrangement from table 1
(Column A to G) to table 2 (Column L to M).
I h
On Thu, 6/1/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: "excel-macros@googlegroups.com"
Date: Thursday, June 1, 2017, 4:47 PM
There
is no standard format for &qu
There is no standard format for "Raw Data".It depends on the original
Application used to CREATE the source of data.Some systems output ASCII (text)
files Some are tab delimited.Others are comma delimited (csv).
The mechanism you used to read in the "raw data" used known characteristics of
the d
Hi Paul,
The macro for this one is not working.
Can you please share your file with macro. So i can compare with my file.
I am getting error message the data cannot be pasted as shape and size are
not same.
Regards,
Kaushik
On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner wro
What isn't working?What does your code look like?
I put random numbers in 100,000 cells in Book1.xlsbThen, in Book2, I put
100,000 cells with links to the corresponding cell in Book1.
I then created a macro module with:Option ExplicitSub RemoveLinks()
Dim aLinks, inx
aLinks = ActiveWorkbo
Hi Paul,
The code is not working.
Can you please provide full code starting with Sub...till End sub
Regards,
kaushik Savla
On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner
wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the fact that, for a giv
On Tue, 5/23/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Need help in Vba Macro
To: "excel-macros@googlegroups.com"
Date: Tuesday, May 23, 2017, 9:53 PM
That's
very CPU intensive because it copies all cells to th
Wow. This is what actually I require.
I will test in my file.
Thanks a lot.
On May 24, 2017 00:43, "Paul Schreiner" wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the fact that, for a given cell, the VALUE of the cell is what
> is displayed, wh
If you also want to get rid of the "internal" links and formulas, you can make
use of the fact that, for a given cell, the VALUE of the cell is what is
displayed, while the FORMULA of the cell is just that, the formula.
For cells with a simple value, like "3", then the formula and value are nearl
This is think will definitely help.
Thanks.
On May 24, 2017 00:23, "Paul Schreiner" wrote:
> That's very CPU intensive because it copies all cells to the clipboard
> and pastes them from clipboard.
> which can be a HUGE number of cells for each sheet.
>
> If you simply want to break the externa
That's very CPU intensive because it copies all cells to the clipboardand
pastes them from clipboard.which can be a HUGE number of cells for each sheet.
If you simply want to break the external links, you can use something like:
alinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsE
Any hope on this _
Regards,
Vikken
On Wed, Mar 29, 2017 at 3:18 PM, vikas khen wrote:
> Hi Team,
>
> Kindly find the attached sheet. In this sheet in need actual value in stud
> of 1. hence kindly assist me on this.
>
> Regards,
> VikKhen
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
You can create a Worksheet_Change event.check to see if the cell changed
(Target) is the cell with your pull-down selection, then process accordingly:
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Address = "$A$4") Then
Debug.Assert False
End If
End Sub
Paul--
Hi Team Any update regarding on the same??
Regards,
On Mon, Dec 19, 2016 at 9:51 AM, vikas khen wrote:
> Hi all,
>
> Good Morning!!!
>
> Team, need help for pooling data from Outlook2016 mails (Which is I kept
> in the one folder) to Excel Sheet in Desired format.
>
> my mail contains followin
Want to excel formula on this
Regards,
Mohd Sadiq
On Nov 21, 2016 6:54 PM, "Paul Schreiner" wrote:
> OK, I'd need a bit more information.
> I can make LOTS of assumptions, but I'd rather not do this multiple times.
>
> So, for each row of data, you want to determine the FIRST column
> containi
OK, I'd need a bit more information.I can make LOTS of assumptions, but I'd
rather not do this multiple times.
So, for each row of data, you want to determine the FIRST column containing WO
and the LAST column containing WO.
Are you wanting to use VBA or Excel functions?
A simple function would
Team ,
Pls update on this
On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq wrote:
> Team , I have data where I want to first date of "WO" and last date of
> Week off in a week.
>
> attached is the excel sheet for your reference.
>
> Pls treat it on priority
>
>
>
> Regards
> Mohd Sadiq
> 979223
Thanks for Help
On Tuesday, 11 October 2016 10:00:45 UTC+5:30, De Premor wrote:
>
> Try this one !
>
> [dp]
>
> On 10/10/2016 19:46, sonur...@gmail.com wrote:
>
> Hi
>
> I need help for separate data through VBA.
>
> My Data is below type..
> sku Size
> 10307963 XS,S,M,L
> 103
Use this Man
Sub SplitTest()
Dim VarArrayAs Variant
Dim LngRAs Long
Dim LngCAs Long
Dim LngIndexAs Long
Dim VaresultAs Variant
LngIndex = 1
VarArray = Intersect(Sheet2.Range("A1").CurrentRegion,
Sheet2.Range("A1").CurrentRegion.Offset(1))
Hi Try below VBA code
Option Base 1
Sub rr()
For Each r In Range("b2:b" & Range("b9").End(xlUp).Row)
x = Split(r, ",")
For t = LBound(x) To UBound(x)
Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1)
Range("i9").End(xlUp).Offset(1).Value = x(t)
Next
Next
End S
Try this one !
[dp]
On 10/10/2016 19:46, sonuraj1...@gmail.com wrote:
Hi
I need help for separate data through VBA.
My Data is below type..
sku Size
10307963XS,S,M,L
10307973XS,S,L
10307978XS,S,M,L
10307979XS,S,L
10307980XS,S,XL
10307981XS,S,M,L
10307984XS,M,
HI Manju,
See this help you
--
On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote:
> Hi
>
>
>
> I need your help to create a macro for the below mentioned scenario.
>
>
>
> *Scenario*
>
>
>
> We need two columns namely User, drop down
>
>
>
> *“IF user enter data in User column(cells) a automa
HI ,
not sure but have you tried using the value "true" in vlookup, might as
well work out for you. sorry in advance i am not a pro at it just amateur.
thanks & regars
On Mon, Jun 20, 2016 at 4:59 PM, Paul Schreiner
wrote:
> It works fine on my file.
> However, I noticed in YOUR file, the Calc
It works fine on my file.However, I noticed in YOUR file, the Calculation
option is set to "manual".
(A "Calculate" reminder appears in the Status Bar.You have to hit an F9 to
calculate.
which means, when you copy the formula down the column, it retains the original
value until you recalculate.
Hi Paul,
Thanks for your quick reply, However your suggested formula is not working
correctly it shows "No Record Found" for all the records. Hence request you
to kindly help me on this.
Regards,
On Sat, Jun 18, 2016 at 12:50 AM, Paul Schreiner
wrote:
> You're looking for a function like:
> =
You're looking for a function like:=IFERROR(VLOOKUP(F2,D:D,1,FALSE),"No Record
Found") Paul-
“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
Hi Paul,
Please find the details in the attached sheet.
Regards,
Vik
On Fri, Jun 17, 2016 at 5:53 PM, Paul Schreiner
wrote:
> What array are you talking about?
> Your file says:
> "If E2 value is in Array then it should reflect in F
> otherwise count as a not found"
>
> So, since column E is
What array are you talking about?Your file says:"If E2 value is in Array then
it should reflect in F otherwise count as a not found"
So, since column E is labeled as "id", then I suspect you want to look in an
array of ID's.The only other ID heading is column "B" which is "Employee Id"But
those
Please Help me on this _
On Jun 17, 2016 14:43, "vikas khen" wrote:
> Hi Team,
>
> Need your help on finding the value in attached sheet.
>
> Request all of you to kindly help me on this
>
> please find attached sheet for the reference.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Since I don't know anything about your workbook or the types of values, I'd
suggest something like what follows.I've run into issues where Excel doesn't
treat a "null" value and a "blank/empty" cell as the same.Plus, when using
something like: wshD.Cells(r, "C")the "default" property is "value",
>
> Here is attached two files , install the addin windatepicker.xlam first
>> and then run that Att file, Double click on date which u want to select.
>
>
Regards,
Mandeep baluja
--
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 offici
Hi All,
Expecting your valuable reply on this _
Regards,
V!kas
On Dec 3, 2015 12:32 AM, "vikas khen" wrote:
> Hello Everyone,
>
> Please find the above attached sheet in which i need your help on the
> below said points.
>
> 1) When i click on date the Date-picker should be popup and when i sel
Thank you DP
Your explanation was extraordinary. In addition to solve my problem, you taught
me a lot! ;)
Thank you very much again
Regards
Isabel
On Monday, September 14, 2015 at 7:37:57 PM UTC-5, De Premor wrote:
>
> Hi Isabel,
>
> I'am glad that its work, ok here is the problem in out 2nd
Hi Isabel,
I'am glad that its work, ok here is the problem in out 2nd case
1st, we need to step back to learn about how the function work,
cpearson.com have a bunch article about this complete with explanation &
sample, you can follow this link
*http://www.cpearson.com/excel/optionalargumentst
Thank you DP!
Thank you very much for your help. It worked perfectly.
However, I tried to do the same in Calculation2 sheet, but inserting rows
instead of columns and it did not work the same logic. It gives me a syntax
error.
Could you help me fix this?
I used:
Dim v As Integer
v = Range("Mont
We can avoid using loop in this case, try to replace your looping code
with offset and resize, try this another solution
Dim u As Integer
u = Range("Months").Value - 1
If u > 1 Then
Range("ColumnLong").Resize(, u).Insert
Range("ColumnFormula").Copy
Range("ColumnLong").Offset(, -u).R
Hello Ashish,
Thank you for your response.
This is a simplified copy of my macro. The lines you can find there are
repeated
multiple times in my final workbook, in different spreadsheets because it
has a broader mathematical formulation.
Hope this helps,
Regards
On Saturday, September 12, 201
Can u pls share a sample file
On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" wrote:
> Thank you Basole for your message!
> I have been already using your recommendation on my code, but it still
> takes a lot of memory.
>
> Regards,
> Isabel
>
>
>
> On Saturday, September 12, 2015 at 9:20:05 AM
Thank you Basole for your message!
I have been already using your recommendation on my code, but it still
takes a lot of memory.
Regards,
Isabel
On Saturday, September 12, 2015 at 9:20:05 AM UTC-5, Basole wrote:
>
> Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
> th
Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
the start of code. and "Application.Calculation = xlCalculationManual" To
turn off the automatic calculation
at the beginning of the code
see example:
Dim u As Integer, v As Integer
u = Range("Months").Value - 1
Application.S
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*
>>> -
>>>
>>>
; -
>>
>> --
>> *From:* Nasir Shaikh
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Wednesday, August 5, 2015 7:34 AM
>>
>> *Subject:* Re: $$Excel-Macros$$ Need help to split numbers a
-
> *From:* Nasir Shaikh
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, August 5, 2015 7:34 AM
>
> *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in
> the last
>
>
> KEY=55a65c4efb80535a8efd001eee190a4795a02acc&a
-
From: Nasir Shaikh
To: excel-macros@googlegroups.com
Sent: Wednesday, August 5, 2015 7:34 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
KEY=55a65c4efb80535a8efd001eee190a4795a02acc&CLIENT=f090d7af-c960-0296-
” - John Wesley
-
From: Paul Schreiner
To: "excel-macros@googlegroups.com"
Sent: Wednesday, August 5, 2015 7:24 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
For MOST of the data, you could use an excel function like:
=TRIM(RIGHT(TRIM(A3),
ll 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*
> -
>
> --
> *From:* Paul Schreiner
> *To:* "excel-macros@google
2015 7:21 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
What type of solution are you looking for?VBA macros? Excel function?Manual
steps?
how often do you need to do this?(is it a one-time thing, or
daily/weekly/monthly?)
What is the source of the da
What type of solution are you looking for?VBA macros? Excel function?Manual
steps?
how often do you need to do this?(is it a one-time thing, or
daily/weekly/monthly?)
What is the source of the data?Can you provide delimiters in the output?
Paul-
“Do all th
Hi,
Sub CommandButton_Click()
Dim i As Long
For i = 1 To Range("K65000").End(xlUp).Row
If Trim(Range("K" & i).Text) = Empty Then
Range("L" & i).Cut
Range("P" & i).Select
ActiveSheet.Paste
End If
Next I
End Sub
On Saturday, January 10, 2015 at 2:00:54 PM UTC+5:30
Hi
Try below code..
Sub blah()
Dim fRow As Range, lRow As Range, rRange As Range
Dim c As Range
Set fRow = Range("K2")
Set lRow = Range("K" & Rows.Count).End(3)
Debug.Print lRow.Row
Set rRange = Range(fRow.Address & ":" & lRow.Address)
Debug.Print rRange.Address
For Each c In rRange
If IsEmpty(c)
Hi
You can do it using function sumifs
Share sample data in excel sheet if you need further help..
Cheers!!
ᐧ
On Fri, Jan 9, 2015 at 7:39 PM, Janani Rajagopalan
wrote:
> I have the below data. I want to dynamically sum the Value column when the
> CID and FID are the same and calculate value/t
hi
you are trying ti print payslip?
Check my last email where i have given you solution to it..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 26, 2014 at 11:49 PM, M.Rafique MRU
wrote:
> Dear Experts!
>
> I am facing problem during printing o
Try formula given by Ashish Koul, its working great!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 3:55 PM, ashish koul wrote:
> try this
>
> =TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),"")
>
> On Wed, Dec 24, 2014 at 3:46 PM, Raj Kumar wr
try this
=TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),"")
On Wed, Dec 24, 2014 at 3:46 PM, Raj Kumar wrote:
> hi,
>
> WIid is Whole seller unique id and i have to reflect total months from
> april to march individully based on WID
>
> so kidnly help me
>
> On 24 December 2014 at 15:38, Vaibhav
hi,
WIid is Whole seller unique id and i have to reflect total months from
april to march individully based on WID
so kidnly help me
On 24 December 2014 at 15:38, Vaibhav Joshi wrote:
> hi
>
> what is WID..
>
> if you want to file Apr-Mar below then select range B2:B13, after that
> using mous
Check this...
is this what you are looking for?
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 3:38 PM, Vaibhav Joshi wrote:
> hi
>
> what is WID..
>
> if you want to file Apr-Mar below then select range B2:B13, after that
> using mouse take
hi
what is WID..
if you want to file Apr-Mar below then select range B2:B13, after that
using mouse take your cursor to bottom end of right side till it becomes
dark black plus sign & then double click on it,.
+
*I did not do this for you. God is here working through me for you.*
On Wed,
cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 11:09 PM, Rob Flott wrote:
>
> Vabz...Thank you very much for the explanation and fix...it works...
>
> Rob
> On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote:
>
>> hi
>>
>> You
Vabz...Thank you very much for the explanation and fix...it works...
Rob
On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote:
> hi
>
> You will get error if no value is added in list box.
>
> add line "on error resume next" in beginning to avoid this error..
>
> cheers
>
> +
> *I
hi
You will get error if no value is added in list box.
add line "on error resume next" in beginning to avoid this error..
cheers
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 12, 2014 at 1:03 AM, Rob Flott wrote:
>
> On a worksheet I have two listboxe
Guruji,
please send to my email id only & html & php in attached file
it's my request
thank you
using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
using System.Diagnostics;
/*
* Sample code to obtain geo codes from a cell info
* "GSM/UMTS" setti
Hi
pl share us code in proper html file format instead of this code..
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 1, 2014 at 1:36 PM, my excel wrote:
> hi experts pls convert to vba macro
>
> mmc input text box
> mnc input text box
> lac input text b
hi experts pls convert to vba macro
mmc input text box
mnc input text box
lac input text box
cid input text box
button
below code
http://en.wikipedia.org/wiki/List_of_mobile_country_codes";>MCC
- Mobile Country Code
">
http://en.wikipedia.org/wiki/Mobile
hi
you can use following line in stead of yours
ieobj2.getlementbyid("cmdclose").click
IE.document.all.Item
Call IE.document.parentWindow.execScript("javafunction()", "JavaScript")
in above secone line replace javafunction with a function which is
called by your webpage on clicking ok button...
Hi
Can you share url of webpage which you are acessing..
On Nov 30, 2014 12:29 AM, "Sunil Patil" wrote:
> Hi Ravi/Vaibhav
>
> its not working at all..
> i hv button from ASP
>
> that ieobj2.getlementbyid("cmdclose").click
>
> once i click it generate alert..and my code stops debugging next, a
Hi Ravi/Vaibhav
its not working at all..
i hv button from ASP
that ieobj2.getlementbyid("cmdclose").click
once i click it generate alert..and my code stops debugging next, aleart is
do u really want to close this.. i hv to click on ok button please siggest
me further solution
On Fri, Nov 28,
hi
you can try adding either of foll lines...
Application.SendKeys("{enter}")
or
Application.SendKeys("~")
however its always not the same thing what we percieve, if it doent work pl
share ur code to chek further...
Cheers!!
+
*I did not do this for you. God is here working through me for
Hi,
Add below line in your code. Might be it works
webbrowser.Silent = True
‘webbrowser’ is your webbrowser object name like if you are using ‘ie’ so use
ie instead of ‘webbrowse’
Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com
Hi Chandru,
PFA
Regards
Ashish
On 24 November 2014 at 11:57, Chandru wrote:
> I need Excel formula or VBA for the following.
>*) To set cell width(for headers).
>*) To make hyper link text blue.
>*) Font Formatting(for headers).
>
> Regards,
> Chandru
>
> --
> Are you =EXP(E:RT) or
Used this Formula in D2 and drag down. .
=SUBSTITUTE(A2," ","")
Cheers
On Nov 16, 2014 9:32 AM, "Imran Khan" wrote:
> To All:-
>
> PLease help me to provide formula to eliminate the space. Example file
> attached.
>
> Regards,
>
> *Imran Khan*
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Welcome Sharath.
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
Thanks Ashish,
This is exactly what I wanted!
Regards,
Sharath
On Thu, Nov 13, 2014 at 7:26 PM, Ashish Kumar
wrote:
> Hi Sharath,
>
> PFA..!
>
>
> Change your data in A1. If you select Global in A1 then drop down list
> will show in B1 and If you select Local in A1 then drop down list will
Hi Sharath,
PFA..!
Change your data in A1. If you select Global in A1 then drop down list will
show in B1 and If you select Local in A1 then drop down list will be
deleted in B1. you are able to write anything in B1
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Hi Ashish,
I am sorry I was not clear in my email.
Let me clarify.
Cell A1 has a drop down list ("Global", "Local")
If someone selects "Global", Cell B1 should show a drop-down list which is
coming through a named range. I have that assigned.
But, if the user selects "Local", the Cell B1 shoul
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.
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
Hi All,
I want you to understand the requirements.
Sub Brand numbers & Invoice number combination will be multiple.
Can anyone will be help me out to create a user form.
for eg:
Brand numbers Invoice numbersStatus
90121 97012
1 - 100 of 704 matches
Mail list logo