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)...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top