Copying Data to next available empty cell in cloum

  • Thread starter Thread starter chanderjeet
  • Start date Start date
C

chanderjeet

Hi,

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

THIS IS HOW MY SHEET LOOKS LIKE
'[image: http://images6.theimagehosting.com/sheet.681.JPG]'
(http://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,""),"")

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
 
Hi,

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
 
thanks for your reply Ashish.. Can you please come to my workstation, im
only 10 metres away from you :rolleyes:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Values to next empty cell range 1
use month in cell date to sum all relevant cells 2
Go To the next empty cell in Column A 3
Reference to next non-blank cell 5
looking for formula to identify next non-empty cell on another sheet 10
Excel - Fill empty cells 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy corresponding cell in Column B if cell in A contains certain text? 1

Back
Top