LutonBarry
06-06-2013, 11:12 PM
A little while ago I posted a problem that looks up data between coresponding cells on each tab and if the cell on the "Today" tab is empty copies the data from the "Yesterday" tab that was solved with the code on the attached spreadsheet. This works fine but the sample worksheet attached is much smaller than the one I use and it checks all the columns which takes a while to complete when all I need is for it to check the data in columns C, and J to M.
I've tried to adapt the code by in effect creating two separate modules 1 to cater for column C which worked, the other for columns J to M which didn't.
Can anyone help or advise.
I've tried to adapt the code by in effect creating two separate modules 1 to cater for column C which worked, the other for columns J to M which didn't.
Can anyone help or advise.