View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steff[_3_] Steff[_3_] is offline
external usenet poster
 
Posts: 1
Default Macro to validate is cell is not empty and copy the line

Hello Expert !!!

I would like to run a macro to validate if the cell is not empty and
copy the related lines to another worksheet.

Example :

I have Sheet 1 and Sheet 2

In Sheet 1, I would like run a macro to check if Sheet2 F3 is empty.
If not copy A3, B3, C3 and D3 to Sheet 1. If the F3 is empty, go to F4
and make the same validation.

If you have any questions, feel free to contact me

Thanks a lot

Stephane Vial