moving row to new sheet

  1. S

    VBA- Move Row to Another Sheet Based on Text- Multiple Sheets

    Hello, Forgive me, this is my first time working with VBA. I have done my fair share of Googling but have not found a solution. I am trying to get my workbook to move an entire row of data from one sheet to another based on the text found in a column. I was able to figure this out- to an...
  2. A

    VBA for moving rows based on cell text

    Hi all. I have 2 columns of data. And I have plenty of workbooks to work with. Anyway... Column A has codes and Column B has links. Both of columns have headers. I can do this with conditional formatting but it would take me alot of time like that. What I need is this. To write somewhere...
  3. T

    I would appreciate some help, if someone has the time!- Moving rows to different worksheets.

    I would appreciate some help, if someone has the time! I have an excel workbook that has three different tabs, tab1= repairs tab2=completed repairs tab3= follow up; all tabs have the same column headings A:K. In column "K", I have a data validation to determine the status on the repair...
  4. F

    Moving entire row to new sheet when date is entered

    Hi there, I wonder if any one can help me. I want to move an entire row in spreadsheet A to the next empty line in Spreadsheet 2 if a date(any) is entered into column J. Can this be done?? Regards Foxylady

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top