software

Hi,

This is a wonderful forum, and i need help from excel xperts here.

THIS IS HOW MY SHEET LOOKS LIKE
'[image: images6.theimagehosting.com/sheet.681.JPG]'
(www.theimagehosting.com)

I want to copy data based on two criterias to the next empty cell in
the column.
The formula im using is =IF('Best time to
call'!$D$4:$D$3001='v-2shgup'!$A$3,IF('Best time to
call'!$A$4:$A$3001='v-2shgup'!B$2,'Best time to call'!$C4,quot;quot;),quot;quot;)

When copied to each cell this may also give blank results which is ok.Now, I dont want to leave an empty cell. I want that whenever a value
is to be pasted on main sheet after validating all criterias, it should
go to the first available blank cell in that Column--
chanderjeet
------------------------------------------------------------------------
chanderjeet's Profile: www.excelforum.com/member.php...oamp;userid=33612
View this thread: www.excelforum.com/showthread...hreadid=533918Hi,

Woul it be possible for you to mail me your excel sheet. I think i have
solved such a problem int he past and may be able to help you.

Regards,

Ashish Mathur

quot;chanderjeetquot; wrote:

gt;
gt; Hi,
gt;
gt; This is a wonderful forum, and i need help from excel xperts here.
gt;
gt; THIS IS HOW MY SHEET LOOKS LIKE
gt; '[image: images6.theimagehosting.com/sheet.681.JPG]'
gt; (www.theimagehosting.com)
gt;
gt; I want to copy data based on two criterias to the next empty cell in
gt; the column.
gt; The formula im using is =IF('Best time to
gt; call'!$D$4:$D$3001='v-2shgup'!$A$3,IF('Best time to
gt; call'!$A$4:$A$3001='v-2shgup'!B$2,'Best time to call'!$C4,quot;quot;),quot;quot;)
gt;
gt; When copied to each cell this may also give blank results which is ok.
gt;
gt;
gt; Now, I dont want to leave an empty cell. I want that whenever a value
gt; is to be pasted on main sheet after validating all criterias, it should
gt; go to the first available blank cell in that Column
gt;
gt;
gt; --
gt; chanderjeet
gt; ------------------------------------------------------------------------
gt; chanderjeet's Profile: www.excelforum.com/member.php...oamp;userid=33612
gt; View this thread: www.excelforum.com/showthread...hreadid=533918
gt;
gt;

Hi,

My e-mail address is

Regards,

Ashish Mathur

quot;chanderjeetquot; wrote:

gt;
gt; Hi,
gt;
gt; This is a wonderful forum, and i need help from excel xperts here.
gt;
gt; THIS IS HOW MY SHEET LOOKS LIKE
gt; '[image: images6.theimagehosting.com/sheet.681.JPG]'
gt; (www.theimagehosting.com)
gt;
gt; I want to copy data based on two criterias to the next empty cell in
gt; the column.
gt; The formula im using is =IF('Best time to
gt; call'!$D$4:$D$3001='v-2shgup'!$A$3,IF('Best time to
gt; call'!$A$4:$A$3001='v-2shgup'!B$2,'Best time to call'!$C4,quot;quot;),quot;quot;)
gt;
gt; When copied to each cell this may also give blank results which is ok.
gt;
gt;
gt; Now, I dont want to leave an empty cell. I want that whenever a value
gt; is to be pasted on main sheet after validating all criterias, it should
gt; go to the first available blank cell in that Column
gt;
gt;
gt; --
gt; chanderjeet
gt; ------------------------------------------------------------------------
gt; chanderjeet's Profile: www.excelforum.com/member.php...oamp;userid=33612
gt; View this thread: www.excelforum.com/showthread...hreadid=533918
gt;
gt;


thanks for your reply Ashish.. Can you please come to my workstation, im
only 10 metres away from you --
chanderjeet
------------------------------------------------------------------------
chanderjeet's Profile: www.excelforum.com/member.php...oamp;userid=33612
View this thread: www.excelforum.com/showthread...hreadid=533918