Hi friends
Why don't you use ISERROR formula with IF formula!
Using this you can handle other errors like #REF! with #VALUE! error
use
=IF(ISERROR(Your formula),Value you want to replace the error
with,Your formula)
I think this formula is simple enough and should work very unless your
Hi Dhananjay
Please find herewith excel file as per your requirement.
U just set the currency 0=-
Dhartikumar
On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear All,
Please ignore the previous mail sent by me because i forgot to attach the
excel file.
Can
Hi Dhananjay
Please find herewith excel file as per your requirement.
U just set the currency 0=-
Dhartikumar
On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear All,
Please ignore the previous mail sent by me because i forgot to attach the
excel file.
Can
Hi All,
Can anyone help me in loading the excel information to Oracle Applications.
I have a list of transactions which I manually enter in to Oracle AP
transactions manually. can we record macro which automatically pic the
transactions by step and post it to the Oracle Applications tab which I
y can either use sendkey or go to a website cld. Www.dataload.net
On 8/17/09, bala Subrahmanyam puligadda simplyb...@gmail.com wrote:
Hi All,
Can anyone help me in loading the excel information to Oracle Applications.
I have a list of transactions which I manually enter in to Oracle AP
Hello Friend,
How to convert left side to right side?
Iqbal
On 8/14/09, A alsulaiman alsulaima...@gmail.com wrote:
I need help
in the attach
Conversion of data in the Sheet1
Like in Sheet 2
What is the Function that can be used
Thank for all
--
Iqbal Shaikh
I use Excel as a front-end to an Oracle database
EXTENSIVELY.
I have over 60,000 lines of code running applications
which store ALL of the data to Oracle.
I have a sub that connects to the Oracle database.
then, I build the SQL command and execute it.
if you'd like an example of this approach,
You can set the atctive-x Move and Size property to adjust when you change
the cells.
right click on the atctive-x and go to the last tab...
2009/8/14 KMG katieg...@gmail.com
Hi,
I am writing an application in Excel that will be used by lay people
and need to simplify the appearance of my
Hi Roopesh...
Thanks for that...
On Mon, Aug 17, 2009 at 1:31 PM, Roopesh Kapur roopesh.ka...@gmail.comwrote:
y can either use sendkey or go to a website cld.
Www.dataload.nethttp://www.dataload.net/
On 8/17/09, bala Subrahmanyam puligadda simplyb...@gmail.com wrote:
Hi All,
Can
Hi Paul,
I will describe you what exactly I do in Oracle Apps.
By taking the information in Excel I will post them in AR Batches - Reciept
Batches Reciept #, Amount, Customer# and Invoices # in the next screen.
If your process help me. could you please send it to me.
Thanks...
On Mon, Aug
independence day? which country ?
On Sat, Aug 15, 2009 at 10:19 AM, Dhananjay Pinjan dppin...@gmail.comwrote:
Wishing you all a very happy Independence Day.
Thanks Regards,
Dhananjay
--~--~-~--~~~---~--~~
Dear Freinds,
please help me
i have a workbook in word there are many pages in workbook but i want Separate
workbook for every pages.
Regards
Amresh
--~--~-~--~~~---~--~~
Hi
I think you can use the WEB ADI functionaly to upload data in ORacle AP..
On 8/17/09, bala Subrahmanyam puligadda simplyb...@gmail.com wrote:
Hi All,
Can anyone help me in loading the excel information to Oracle
Applications. I have a list of transactions which I manually enter in
India celebrated 62th Independence day this year
Thanks for asking :)
On Aug 17, 5:06 pm, zheng yu vincent2...@gmail.com wrote:
independence day? which country ?
On Sat, Aug 15, 2009 at 10:19 AM, Dhananjay Pinjan dppin...@gmail.comwrote:
Wishing you all a very happy Independence
right click on sheet1View Source CodeSheet1 propertiesDiplay right to
lefttrue or
Date: Mon, 17 Aug 2009 13:34:14 +0530
Subject: $$Excel-Macros$$ Re: I need help !!! Thank for all
From: iqbal.sw...@gmail.com
To: excel-macros@googlegroups.com
Hello Friend,
How to convert left side
Hi Amresh,
Could you please clarify!! Workbook in Word
Please send a sample file.
Regards,
Andy
On Mon, Aug 17, 2009 at 7:15 PM, amresh kumar amreshkushw...@gmail.comwrote:
Dear Freinds,
please help me
i have a workbook in word there are many pages in workbook but i want
Hi Dhananjay,
Thanks for encouraging words.
This is done using custom format. Whenever you type in zero, it will treat
that as -.
Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Aug 17, 2009
I think I see.
Here's the problem though.
Oracle is a Database.
There are sample tables, but for each APPLICATION,
tables are DESIGNed to store data and connect the data
to establish relationships between the data elements.
It uses SQL to store and retrieve data from the tables.
APPLICATIONS are
Hi,
I have certain reports that recur every 9 days, 16 days, 22 days, 43
days and 76 days respectively. Some of these are workdays and some of
them are calendar days.
I have a weekly report tracker that lets me track which report is due
on a certain week. I want to automate it further. I am
I am trying to populate cells with a certain addresss from a
spreadsheet called Let1 to another spreadsheet called Let2. I have
this code in Let1. My problem is that this code will not execute
consistently, Even though I may have some value in cell H12 in Let1
the values are not written to
20 matches
Mail list logo