populate data

[edwardpestian]

Hi All.

I'm trying t0 enter specific numerical data in to one table on Sheet3. I then want that data to populate into specific cells in Sheet2. Once the data has been populated, any future attempts to populate would give a message: "This cell(s) have already been populated. Do you wish to continue: Yes NO

Thanks for any help.

EP

[[email protected]]

Test the cell before you do the input - if you are putting data into
cell A3 for example

if len(range("A3").value)>0 then n=msgbox("Do you wish to
continue?",vbyesno)