copy adjacent cell

  1. S

    Copy target as well as three cells to the left of the target.

    Is there any way that I can copy, on the double click of any cell in column A, the cell that I clicked on as well as the 3 cells to the right of that cell in sheet1, and then paste them in a column on sheet2 in the cells B2:B5. Alternatively, is there any way when i double click a cell to have...
  2. M

    VBA Macro: Lookup Word, Copy Cell, Lookup Word (next tab), Paste Copied Value

    I'm looking for a Macro to run that will lookup "Project #" in Sheet 1 (named ProjectID), copy its adjacent cell value on the right, look for every time the word "Project #" appears in the remaining sheets and paste the previously copied value into the adjacent cell on the right. [e.g. Project...
  3. T

    copy paste calendar tab cells to summary page

    I have 52 tabs that i want to link to a summary tab. each tab has a different date, by week (7 day increments) i have 14 different columns for 14 different 'districts'. i have already linked the first column (52 rows for each week of the year) to the summary page. Question - how to i copy and...
  4. D

    need to copy cell to empty cells in a range

    Hi I need some help. I have data in a column where cell A1 has data followed by multiple cells with no data, then another cell with data followed by one or more cells with no data, and continuing down a particular column. e.g. Real Data (null) (null) (null) (null) Real Data (null) (null)...
  5. D

    Find empty cell in range and copy range next to it

    I need some help on writing a code that finds any empty cell in a range ("Q4:Q46") and then cuts the cells ("A:P") in that same row and paste it to another sheet starting with cell ("A4"). Then delete the rows that the data was cut from. This code will be linked to a command button. Any help...
  6. F

    quickly repeating long-winded formula

    please bear with me with this... I'm trying to write a spreadsheet for stocktaking where rows 2-40 have the stock items, column C has the price, and then each subsequent column has a different job I've used the stock for, so I can go down the rows adding how many of which item I've used for...
  7. D

    Active Cell Trigger

    Hello, I have a Spreadsheet where: Column B = Project Number Column C = Project Title Column D = Workstage Column E = Workstage Description I have code that will sort what can appear in workstage(D) depending on whats selected in Column A. this is done using the active cell at the time...
  8. J

    VBA - Search column from cell, then copy and adjacent cell and paste to another cell

    Hello, I've only recently begun to use Macro's so please forgive my ignorance! I've created a form for users to advise a project is to begin - Cleverly named the "Project Commencement Advice" form. I've created and named a list of all of the projects scheduled for the year (cells C69:C158)...

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