Transfering data to another sheet and inserting a prompt

Hi there guys,

Looking for what I hope is some basic help.

I’m looking to transfer the rows that have a date in the “Call Back Date” (column B) to a separate sheet called “Call Backs”.

I’m also looking to insert some kind of prompt which tells whoever is entering data in the “Notes” (column J) to “Please enter a call-back date” (column B).

I’m still fairly new to all this, so I’m looking to learn how to do this in the future.

Attached is a test copy of the spread sheet.

Thanks!

EDIT - use this:

=IFERROR('Jan-Feb-March Deals'!$B$2:INDEX('Jan-Feb-March Deals'!$B:$B,COUNTA('Jan-Feb-March Deals'!$B:$B)),"")

Thid will also suppress any errors - enter formula into Sheet 2 cel A2 of your spreadsheet - as a new call back date is added in the first sheet this list will update automatically.

As an aside - shouldn't you have details such as a company name, contact alongside?

Just an observation - the colours of your sheet are outrageous! nearly blinded me! would trigger epileptics into spasm......

Dude - you need to format the cells to a date - that strange number is a date serial number.

Enter that formula into anysheet an drag down

If this helps please make as solved and if you are still stuck let me know.

ahhhhh yes i see. thats not a problem, but i have to go to a meeting now. will post back later. not to worry. its pretty simple.

ok - in the first row of sheet 2 copy and paste your headings from the first sheet.

then in b2 copy accross and down

=IF($A2="","",VLOOKUP($A2,table,COLUMNS($A$1:B$1),0))

sorry, you need to give your data table a name first - i called it table as u can see

thanks for the feedback dude - please mark thread as solved!