Hello,
In case a formula is returning “#N/A” then is there a way by which the
output of the formula could be made blank or zero. please help.
regards, Harris
--~--~-~--~~~---~--~~
--
On Aug 4, 10:44 pm, shivashankar katageri
wrote:
> Dear all,
>
> any body help me to sort out the with attached sheet
> --
> Thanks & Regards
>
> Shivashankar.C.Katageri.
Hi Shivashankar,
Here's another solution using VBA that may interest you.
Hope you find it usefull.
Regards,
Jonell
im using formula now, and i dont like filled cells, cause some people
will be confused when they see many data, lots of numbers going down,
but if it possible to change fields like i found script for date auto
fill, like line by line, without copying anything,
just enter qty number and that's it.
-Original Message-
From: Aindril De
Sent: Saturday, August 01, 2009 8:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Submit data to a web site from excel
[The entire original message is not included]
--~--~-~--~~~---~--~~
-Original Message-
From: Aindril De
Sent: Saturday, August 01, 2009 8:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Submit data to a web site from excel
[The entire original message is not included]
--~--~-~--~~~---~--~~
pls search the forum. I had posted a solution some months back. Rgds
On 8/6/09, Ujjwal Jha wrote:
> Dear All,
>
> I can use mail merge with msword. But if I want to write mail in outlook and
> want to send to many recipients but dont want them to see multi recipients'
> names. I can use BCC but
Hi Osiso,
Can you just clarify what you are trying to do, as it sounds like we
are trying to make this more difficult than it needs to be.
Presumably you have an array of exchange rates from date x (eg 199712)
to date y (eg 200712) on one sheet.
On another sheet you are wanting to pull back the
Dear All,
I can use mail merge with msword. But if I want to write mail in outlook and
want to send to many recipients but dont want them to see multi recipients'
names. I can use BCC but dont want to. I want to write mail and send them to
multiple but i want them to see their name only in 'TO' fi
I am assessing how many days poeple have off sick and have a sheet to
record this as follows.
cola Date_off
colb Date_ret
colc Total days (networkday between off and ret)
Does anyone have an idea how I can calculate in column colc how many
days a person hs been absent in the previous 6 mont
i would like to add an example of what im trying to do. please let me
know how to add a file.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(V
could you please let me know how did you do it...
On Wed, Aug 5, 2009 at 11:32 PM, Harmeet Singh wrote:
> done!!!
>
> On Wed, Aug 5, 2009 at 9:18 PM, Ujjwal Jha wrote:
>
>> Dear All,
>>
>> I am not able to remove the filter. Can anyone help me on this.
>> --
>>
>> Luv & Regards
>> Ujjwal Jha
>>
We just converted to the new version of Excel. I used to use a couple
of functions from the data analysis toolpack (regression &
histograms). Can anyone tell me how to get at that functionality from
"the ribbon"?
--~--~-~--~~~---~--~~
Try to use shortcut key.*"Shift + Space Bar"*
On Tue, Aug 4, 2009 at 2:29 PM, Sheyn Lee wrote:
> Dear All,
> Is there any option that when I select a cell in the sheet, the whole row
> corresponding to that cell is highlighted.
> In the attached example I have selected cell C7. Required
Before pasting ur values press "F2" then paste the text which u copied from
notepad.
I hope this will help
On Wed, Aug 5, 2009 at 1:42 PM, Vivien Parlat wrote:
>
> Hello,
>
> When I write the following string in notepad:
>
> A B
> C D
>
> and copy/paste it to Excel, it fills 4 cells.
> I tri
see attached file
On Wed, Aug 5, 2009 at 3:27 PM, mageshwaran jayaraman
wrote:
> If till now, no body has replied then try this
> Before deleting the entries, in a new cell put the comments in text.
> then use '&' key eg..if ur numerical entry is in B2 and comment in F2, then
> in G2 put formul
For example "Journal" this word is in one column of every sheet. This word
is in the same column of every sheet. i.e. Column D. I want the rows having
word "Journal" in a new sheet.
On Wed, Aug 5, 2009 at 4:51 PM, Prasanth wrote:
>
> i am guessing what your need might be...need some more details
Dear All,
I am not able to remove the filter. Can anyone help me on this.
--
Luv & Regards
Ujjwal Jha
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA T
Rakesh,
Thank you very much for your input.
I appreciate you and others (Jaspal) taking the time to write.
Regards.
Peace
On Aug 5, 3:17 am, Rakesh Sharma wrote:
> Hi Peace,
>
> May be this would resolve your problem,
>
> Regards
> Rakesh
>
> Yahoo! recommends that you upgrade to the new
Jaspal, Thank you very much for your input.
Regards.
Peace
On Aug 5, 12:52 am, Jaspal Rehal wrote:
> check this page... may be it could be any use for you
>
> http://www.ozgrid.com/forum/showthread.php?t=98321
>
> Rg
>
>
>
> On Wed, Aug 5, 2009 at 12:19 AM, peace wrote:
>
> > I need to retrieve
One way to do it by formulas would be
StartSerial - Formula - "=1"Cell Format - Custom "0"
EndSerial - Formula - "=Qty" Cell Format - Custom "0"
Date- Cell Format - Custom "yymmdd"
Having done this, you can programmatically read the cell contents as
displ
Just sent them an Excel file designed to get that CSV file as it
opens
--- Use Auto open macro in the file File
--- Ask user where the CSV file is
Execute formatting macro
PS Ensure that you put in place a Excel update routine because people
will ALWAYS uses th
You can download the file from that link. And then suitably modify the code
to suit to your requirements.
Ajit
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Deepak Rai
Sent: Wednesday, August 05, 2009 11:34 AM
To: excel-macros@googlegroups.com
Subje
i am guessing what your need might be...need some more details to
help...
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Fre
Its amazing as to what I learn from this group
Keep sharing keep growing
BEST regards
Subu
On Aug 5, 12:17 pm, Rakesh Sharma wrote:
> Hi Peace,
>
> May be this would resolve your problem,
>
> Regards
> Rakesh
>
> Yahoo! recommends that you upgrade to the new and safer Intern
If till now, no body has replied then try this
Before deleting the entries, in a new cell put the comments in text.
then use '&' key eg..if ur numerical entry is in B2 and comment in F2, then in
G2 put formula "=B2&F2"
Send me your excel file or sample one and I'd solve it with formula.
Thanx '
good day everyone,
i need some help with little script, actually i need script to auto
fill serial numbers when qty is entered.
lets say i type in F530 product qty, 5, and i need that in H530 will
be start serial number,
starts with zero: 1, and in I530 stop serial number: 5.
cells J and K
Dear all,
I have several sheets in one excel file. I want to club row of each sheet
containing particular word in a new sheet.
Kindly help me on the matter.
Thanks all.
Narendra Ashara
--~--~-~--~~~---~--~~
---
Hello,
When I write the following string in notepad:
A B
C D
and copy/paste it to Excel, it fills 4 cells.
I tried to set the value of a range in a macro to a string containing
an equivalent content ("a" & vbTab & "b" & vbNewLine & "c" & vbTab &
"d")
But this does not work.
Could someone gi
Good morning folks
I am looking for a database / excel list to maintain supplier invoices. I give
below what I could manually enter and what outputs I am looking for .
I am ready to / I will manually enter and maintain the following
(1) Supplier master data :
1.1. Supplier name
1.2.
Hi,
If you can please provide a sample file of the same, it will help us to find
the solution.
Regrds,
Deepak
On Wed, Aug 5, 2009 at 1:56 AM, Tim wrote:
>
> Hello all,
> I'm attempting to have a window pop up when the user clicks a
> command button on the sheet. The hurdle I have come to is
Hi,
Jaspal Rehal
Thanks'Thanku very much it works,
On Tue, Aug 4, 2009 at 9:25 PM, Jaspal Rehal wrote:
>
> Try : COUNTIF formula
> Rg
>
> On Tue, Aug 4, 2009 at 6:14 PM, shivashankar
> katageri wrote:
> > Dear all,
> >
> > any body help me to sort out the with attached sheet
> > --
> > Thanks
Take a look at the link below:-
http://www.andypope.info/vba/userformdraw.htm
The approach is, copying the shapes from the worksheet to clipboard, and
then reading the clipboard and place the clipboard BitMap/metafile on the
form as an OLE Picture.
Regards
Ajit
-Original Message-
Fro
check this page... may be it could be any use for you
http://www.ozgrid.com/forum/showthread.php?t=98321
Rg
On Wed, Aug 5, 2009 at 12:19 AM, peace wrote:
>
> I need to retrieve stock information from a web site. (It can be any
> site that provides such information - the site is not important)
33 matches
Mail list logo
