copy adjacent cell

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

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

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

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

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

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

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

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