Hi Gargi,
Can you please explain your problem a bit more, and may be with a example
worksheet of what you want to achieve,
This will help in answering your query more easily.
Regards,
Andy
On Sat, Mar 14, 2009 at 12:08 PM, Gargi wrote:
> Dear All,
>
> Can any of you please help me with how to
Hi Gargi,
Here is the
Solution: http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html
For more tips, tricks, downloads and problem solutions: visit -->
http:/
Dear All,
Can any of you please help me with how to work on V Look Up , and use
functions such as transpose and concatination.
I am working In SAP as FICO .It would be of great help if any of you can
give other relevant functions required for SAP datas to be taken up in
Excel.
Thanks in Advance
Hai,
Keep the Cell activated in Cell A1.
Click "Conditional Formatting" from "Format" Menu
Select "Cell Value Is" > Select "Equal To" > Enter "0.33" without
double quotes
Click on "Format" button > Goto "Patterns" tab and Select Grey color >
Click OK
Now, You are done This solution is ava
2003, I am really looking for VBA code to do it
On Mar 13, 2:04 pm, Paul Schreiner wrote:
> Which version of Excel are you using?
> 2007 has a Rows-to-columns selection, but you need to know the character code
> for the line break.
>
> Paul
>
>
> From: jaysfive
Hi Team,
I have a list of numbers in an excel columns. I need to open a site and
enter the numbers one by one in the search field of Open site and hit
enter. I also need to capture the some information from the screen after
clickling enter and then get back to the search page. Can anyone please
Hi,
check if you have any column which tell tell you when this row is updated or
changed i.e I used to have a column in my every table as " last_updated_date
" if you have any column like this then apply where condition on that
otherwise you need to contact your DBA for providing you a view (Query)
Which version of Excel are you using?
2007 has a Rows-to-columns selection, but you need to know the character code
for the line break.
Paul
From: jaysfive
To: MS EXCEL AND VBA MACROS
Sent: Friday, March 13, 2009 5:39:19 AM
Subject: $$Excel-Macros$$ Multilin
*Greatbuddies.
Congratulations..*[?][?]
*Unfeigned Regards
Manoj S Negi *
*"Miles & miles to go before I sleep"*
*¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·.
.·:*
*:·.
*«*:·.
.·:*
*:·.
*
On Thu, Mar 1
I have a "library" XLS file containing a number of macros which are
used in other XLS files, for example
Private Sub CommandButton1_Click()
Application.Run "'LibFile.xls'!Enter_Journal"
End Sub
This file needs to be open when the macro is invoked. Is there any
way in which the macros can be
I have a spreadsheet in which in one column the cells have multiple
lines with end of line characters imported from Outlook. I would like
to split the lines into new columns before the next original column
eg
Column 3new columns Column 4
joe brown
$12345
34 my street
london
I am having to write some macros in the older XLM language (because I
need this to work also on Excel 2008 for Mac which now has no VBA and
you can't do Excel UDFs in Applescript). Everything is fine except for
one thing:
I have a defined-name macro which calls =ALERT() to open a pop-up. It
never
I am waiting for 16th March. As my name is there in the winners list.
On Thu, Mar 12, 2009 at 8:12 PM, Harmeet Singh wrote:
> Congrats to all the winners,
>
> Watch out for me as my name is going to be there in place of Dave next
> time.
>
> :)
>
> On Wed, Mar 11, 2009 at 5:23 AM, Ashish Jain
This is not possible in Excel 2003
On Thu, Mar 12, 2009 at 8:05 PM, Harmeet Singh wrote:
> Would be easy if you use conditional formatting. Open excel, Goto format->
> conditional formatting then choose as shown in attachment.
> See solution in attached file.
>
> On Thu, Mar 12, 2009 at 5:21 P
14 matches
Mail list logo
