+ Reply to Thread
Results 1 to 2 of 2

Copy Cell Data from one sheet to another without overwriting

  1. #1
    Registered User
    Join Date
    Holcomb, KS, United States.
    MS-Off Ver
    Excel 2007

    Copy Cell Data from one sheet to another without overwriting

    I am still new to excel VBA and my biggest problem is that I don't use it often enough. I have used this forum to get answers to quite a few questions, and I have had help in the past, but this one has me stumped. I actually have four identical workbooks that are generated daily, but I usually copy and paste the data into one workbook with several sheets. combine them manually, then use this data from the first sheet to make the workbooks for the next day. This is done so we don't read data from areas that have already been read. I've attached a sample. We then go, take more readings each day, I combine them. We do this each day until all the rows are filled. The first two columns are for reference only and the data is filled in the third and fourth columns I need a way to copy from sheets 2-4 into sheet one but not overwrite anything, or at least have a message box pop up to ask me if I want to overwrite the cell.
    Thanks for any help.

    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2003,excel 2007

    Re: Copy Cell Data from one sheet to another without overwriting

    I am confused of your requirements.

    anyhow keep the original data safely somewhere
    your version is excel 2007
    save the file as xlsm file(macro enable file )
    experiment with this macro (modify macro if necessary). if this is what you want confirm

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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