On the fly copy cells to another worksheet

[agonza]

Hello everyone,
Basic excel skills, been reading on formulas and I am trying to do the following.

This is an ongoing spreadsheet, as I receive new info I enter it.
I have two worksheets; worksheet 1 contains names, contact info for potential volunteers for our organization. Upon submittal of a completed application we then begin the background checks, etc. which this info is contained in worksheet 2. So at that point I want to copy over the common info between the two sheets to worksheet 2 instead of manual typing.
So worksheet one contains cells A:G and cells N & P that we want to copy over to the 2nd worksheet to the next available line. Both worksheets contain other information but I only want to bring over these cells.
The kickoff I thought would be populating a cell with the date that they handed in the application, then I thought it probably would be better to use a Ready/Not Ready drop down in another cell in worksheet 1.

I have the following formula:
=IF('Online Referrals'!O2="Ready",'Online Referrals'!A2,"") but when this occurs (if a cell is blank) a 0 is placed in the destination cell. But I am starting to realize that this will mean alot of formulas in alot of cells.

cell O is the Ready/Not Ready validation

I know this is probably alot of work but I am trying to make things easier on me with typing all this information thru out the sheets.

[Cheeky Charlie]

Why don't you just add the info you have been adding to sheet 2 to sheet1?

[Marcol]

Hi agonza

Welcome to the forum

Try this
In sheet 'Offline Referrals' A2

Please Login or Register  to view this content.

Note the dollar sign
Fill across to I2
Change the last two columns(H & I) to

Please Login or Register  to view this content.

Fill down as required.

Filter sheet 'Offline Referrals' for non-blanks when you need to see a continuous list.
The filter will not automatically update as entries are added, it will need to be manually refreshed when required.

Any sorting and amendments must be done on sheet 'Online Referrals'

Add or subtract entries in 'Offline Referrals' by toggling entry in 'Online Referrals' Column O

Hope this helps

[agonza]

Thank you I will try it out and let you know how it went. Happy Labor day!