overwriting

  1. D

    Dragging data over without overwriting existing data.

    Hi All, Please see the below example. Is there a way I can select the data in col. B and either cut / paste or drag over into col. A without overwriting the existing data in Col. A? So as to essentially just fill the gaps. Dragging the Col. B items over one at a time will be rather time...
  2. K

    Copying data from Sheet1 to Sheet2, but in different order - Destination Row getting overwritten

    Good Day, I am trying to copy data from Sheet1 (which meets the conditions of an IF statement) and then paste the relevant cells for said row into Sheet2 of the same workbook. Initially I managed to use the following code to simply pull in the relevant rows: Sub Copy_to_Sheet2() a =...
  3. M

    Copy two different tables into lastrow in one table in a new sheet

    Hei, I´ve tweaked a code to copy/paste two different dynamic tables into one dynamic table in another sheet. However, it seems that the latter part of the code (copying the last table) overwrites the first one. I´ve used lastrow to determine the last cell with data, but it failes. Sub...
  4. S

    Help with Macro VBA - copying cells to another workbook without overwriting

    Hello, Please could you help me, i am trying to create an archive macro which will take all rows in the sheet entered and are copied to the archive workbook, i was previously able to make it work to copy however it would overwrite the archive data from before in the archive sheet. Now it...
  5. D

    Excel 2010: Search function - Write over last searched term after search is completed

    When using the search/replace function, I find it extremely annoying that I have to delete the last searched term every time before entering the next. In a lot of other programs, the last searched term is automatically marked/"blackened" once the search is terminated, and you can then simply...
  6. S

    Excel Timer Macro overwriting data in active worksheets

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I am running a program that when a ‘Start’ command button is clicked, a timer begins counting in seconds and displays the value in cell B3 until a ‘Stop’ command button is...
  7. S

    Multi User Saving HELP!

    My self and a group of people are using a shared workbook, But not everyone is great with computers that use this work book and if a popup appears they normally just say ok with out actually thinking about what it says! The problem is when people are saving there overwriting other peoples work...
  8. A

    File Saving

    I am using a script to save the active workbook only thing is when the user already has the workbook saved with the same name excel asks them if they want to replace it or not. If the user clicks the cancel button an error screen pops up Is there a way avoid the error screen or better yet is...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top