Thread: Excel VBA - Problem programming routine for conditional copy/paste

Hi,

I have created a file with several sheets, one for each month of the year.
Each sheet has a database table with several records....what I am trying to do is to find a routine able to check, for each filled up record, if the cell related to one specific Column is either empty or not. In fact, the absence of data in that specific cell of each row, has an important meaning. In case that cell of the row, corresponding to that specific column is empty, the routine itself should copy the whole record and paste it on the first empty record row of the next month sheet, keeping each formatting setup.

How can I manage that?

I am really looking forward to receiving your help, thanks

Mark

Originally Posted by Kyle123

This would be much easier if you posted a workbook that contains sample data

Hi Kyle, you are right, sorry. Here it comes the file. The COlumn is the I.

Gestionale_test.xlsm - 197.1 KB

I don't know why but the upload manager here doesn't work out with my file. It doesn't upload it anyway.

How can we solve that?