PDA

View Full Version : Solved: Copying Cell data and formats across two spreadsheets



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.

LutonBarry
06-07-2013, 04:34 AM
Folks thought about this and I came up with a a solution I just moved the columns on both sheets out of the immeadiate region ran the code to update the cells just requiring updates then copied and pasted the moved cells back into place.

It came to me while stuck in traffic this morning.:rolleyes: