If you don't want to open the other workbook and you don't want to usa VBA,
I don't know how to COPY a worksheet from one workbook to another, but you
can link to desired values.
For example, in cell A1 of your destination sheet/workbook, type:
=[OtherWorkbookName.XLS]Sheet1!A1
To rerieve
Dear All,
Please help me with below mentioned query.
On Sat, Apr 28, 2012 at 10:05 PM, Milin Sulakhi wrote:
> Dear Rajan,
>
> What will be that formula in both scenarios ?
>
> Please help me with the same.
>
> Regards,
>
> Milin
>
>
> On Sat, Apr 28, 2012 at 9:24 PM, Rajan_Verma wrote:
>
>> ** *
Hello sir,
First of all thanks, secondly I don't know vba so can't use it. is excel
have any formula. plz tell me.
Thanks & Regards
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Hel
Can you attach an example.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Filip Houdek
Sender: excel-macros@googlegroups.com
Date: Sun, 29 Apr 2012 21:58:39
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find column # of first value greater than sp
What formula would return the row or column number of the first value in an
array greater than a specified value? Eventually I'll need to compare the
location with another location to see which comes first chronologically. I
could list the numbers either vertically or horizontally, whichever is
Thanks for your revert rajan, but i've one query ma sheet(report) contains text
line as "A112354 xyz abc etc" or "xyz A112354 abc etc" in several row of sheet
and other sheet(user id) contains only "A1123" now i want to know if "A1123"
available in sheet(report) or nt...
Regards,
Prabhat S
--
Hi All,
I'm asking you for help, I have a problem with compering two cells base on
conditions. There is no problem if everything is running in order, but if there
is a gap ... there is wrong answer given, pls see attachment and if you can
advice I'll be appreciated.
Regards,
Pawel
--
FOR
I have two sets of Excel worksheets I am trying to compare. The cells
contained multiple lines of text. Some identical-looking lines do not
compare with string1 = string2 syntax. It appears the comparison is
failing when it tries to compare new line characters (ASCII code 10).
Has anyo
Hi
Please find solution with Formulas. I just replace “Email Address” to “Email”
in your row data and make formula accordingly
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sara Lee
Sent: 29 April 2012 23:29
To: excel-macros@googlegroups.
it s working- Thank you so much .. appreciate it.
On Sun, Apr 29, 2012 at 1:55 PM, dguillett1 wrote:
> Really good
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* ╰» ℓαℓιт мσαнη
> *Sent:* Sunday, April 29, 2012 12:25 PM
> *To:* excel-macros@googl
Really good
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ╰» ℓαℓιт мσαнη
Sent: Sunday, April 29, 2012 12:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ data needed in this format
Hi Sara
PFA
Regards,
Lalit Mohan
On Sun, Apr 29, 20
Nicely done...!!
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ╰» ℓαℓιт мσαнη
Sent: Sunday, April 29, 2012 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Your Help
Hi karthik
PFA
Regards,
Lalit Mohan
On Sun, Apr 29, 20
*Hi karthik*
*
*
*PFA*
*
*
*Regards,*
*Lalit Mohan*
On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη
wrote:
> *Hi karthik*
> *
> *
> *PFA*
>
> *Regards,*
> *Lalit Mohan*
>
>
>
> On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote:
>
>> Hi friends,
>>
>> Find the attachment of company address,how
*Hi karthik*
*
*
*PFA*
*Regards,*
*Lalit Mohan*
On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote:
> Hi friends,
>
> Find the attachment of company address,how to spreat'up the colomn wise
> data
>
> Sample data is attached.
>
>
> Regards
> karthik.N
>
> --
> FORUM RULES (986+ members already
*Hi Sara *
*
*
*PFA*
*Regards,*
*Lalit Mohan*
On Sun, Apr 29, 2012 at 12:38 PM, Sara Lee wrote:
> Attached is the file with 2 sheets - input and output.
> output i require is based on input tab--- i need every reference value to
> be listed as columns and then list down the load nos in which
See the attached file.. Result on Sheet 2
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prabhat.shrivasta...@gmail.com
Sent: 29 April 2012 22:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find the cell value from other sheet
Dear Frnds,
I've a data sheet(reports) containing some data text in several row of
entire sheet & have another sheet(user ids) in column A containing few
words these words may be or may not be the part of other sheet(report) text
in cell of column A, now i wanna know if the sheet(user ids) text
Hi
Add the following code in user form code module.
Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
If TextBox1.Value = "" Then
MsgBox "Please enter the name"
End If
End Sub
Rajan.
From: excel-macros@googlegr
Hello Karthik,
You can use text to columns function to get your desired format.
Check attached file.
On Sunday, April 29, 2012 11:08:10 AM UTC+3, karthik n wrote:
>
> Hi friends,
>
> Find the attachment of company address,how to spreat'up the colomn wise
> data
>
> Sample data is attache
Dear everyone,
Referring to subject line attached a excel file with user form, my question
is
if text box 1 is “” (blank) then while moving cursor to combo box 1 it
shows msgbox with “please enter name” if this condition fulfill (means user
enter the name in textbox1 then it not supposed
Attached is the file with 2 sheets - input and output.
output i require is based on input tab--- i need every reference value to
be listed as columns and then list down the load nos in which these
reference values exist in the input tab.example
reference7151865O is in 2 load nos below
load 0
21 matches
Mail list logo
