cell copy

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top