+ Reply to Thread
Results 1 to 5 of 5

Excel VBA - Problem programming routine for conditional copy/paste

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2007
    Posts
    9

    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

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

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

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

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2007
    Posts
    9

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

    Quote Originally Posted by Kyle123 View Post
    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

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

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

    Please upload via the forum, I can't open that site from work

  5. #5
    Registered User
    Join Date
    07-06-2010
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2007
    Posts
    9

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

    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1