Is there a way via a macro to copy the values in a range of cells to another range of cells, but if there is anything in the destination range of cells, do not overlay with the values you are copying from?
Consolidating would work, except I would need my destination cell range to be one of the consolidation cell ranges.
HTH
Please Login or Register to view this content.
Tom Stock
Office version: MSO 2002 SP3
OS: Windows XP Pro
Hardware: IBM Thinkpad T41
Thanks, but it did not work.
I have attached an example spreadsheet with the macro in it. Maybe I am missing something. I want to be able to copy cells E1:G3 to A1:C3 but not overlay what is already in cell A1:C1.
That work for you? I thought if your paste range contained ANYTHING you didn't want to paste anything. If you are just filling in, this should work.Please Login or Register to view this content.
Got it....many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks