cell copy

  1. G

    Copy only single value from named range of values

    I am using O365 and trying to copy a single value from inside a named range of values. When I use Range.Copy even if it references a single cell (example: Range("A2").Copy ), the whole named range that fills that column (example A1:A50 = _Range1) comes with it to the destination. Is there a...
  2. S

    Copy data from one sheet to another based on criteria

    On sheet one I have event dates in column C starting on row 7 and ending on row 105, event names in column D starting on row 7 and ending on row 105, and event type drop down in column F starting in row 7 and ending on row 105 with a color coded fill that changes with event type in column E...
  3. J

    Search Function with Personal Data Following

    I have a table of data and have created a search function to find a name within a column of that data. What equation would I need to use to have the next few cells of information that is attached to that name appear in the cells following the search function cell? I used Aaron as an example, but...
  4. L

    conditional cell copy with multiple conditions

    Hello, new to the forum and I'm new to VB so please be patient with me. My questions is how to code so as to copy a group of cells to another sheet in different cell location based on conditional cell data. To be more specific, say in cell B11 is a qualifier "MT" or "AT" or 15 other such and I...
  5. A

    How to execute loop only on the filtered range

    Hi All, I want to filter the range on Column D and want to copy those filtered data from column D to column A in same row i.e next visible cell value of columns D should be copied to column A. I tried to record a macro for same , but there i get the fixed value of range. Below is the code of...
  6. J

    Need to copy certain cells to different worksheet based on cell value

    I have a spreadsheet in Excel 2010, that I am wanting to take certain cells in a row and copy them to another worksheet when a certain value is entered into a specific cell in the same row. For example: In Worksheet A, in cell A2, if a "X" is entered, I want cell A5, A7 and A13-17 to be copied...
  7. S

    Auto copy cell value, color and comments

    Dear friends, I'm glad to be here with all the excel users/lovers/experts. I've being using excel for a long time now, I'm not a pro but I know my way around. Now I've go a task to do, to make automated "replica" of certain cell(s) on the same sheet or on a other new sheet. So let's say I have...
  8. S

    Copy and Paste Help

    Click a Button to start.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Looks through column C for blank cells (Cells equal to “”)<o:p></o:p> 1 – Identifies First blank cell in Column C<o:p></o:p> 2 – Copies data from an offset of (1, -2) and...

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
Back
Top